custom sql built for analytics builder tool

Anuja.k.619

Hello,

I am trying to build custom sql . I am trying to encode string into base 64 format. But i can not. I can easily do in MYSQL , oracle as well SQL. But that format does not work under analytics builder tool. Could anyone please help here?

or do i need to open a support case?

Thanks

Anuja

Abrar.S.661

Hello Anuja and thank you for reaching out to the Brightspace Community today!

I understand that you're having some difficulties with building custom SQL in the Analytics Builder Tool. I want to confirm if you are using the steps in our documentation below to write your custom SQL? https://community.d2l.com/brightspace/kb/articles/25603-creating-reports-using-analytics-builder#manipulate-fields-in-your-custom-datasets-using-sql

Could you please provide a snippet of the SQL code you are trying to run? Furthermore, if there are any errors that are appearing - please share these as well.

Best regards,

Abrar