Executing CustomTable_Queries in macro expression

Ethan Nguyen asked on February 4, 2021 10:12

How can I execute some of the predefined queries in the Custom table within a macro expression?

Example: CMSContext.Current.Queries.FieldsAsObjects.ClassID["customtable.IncomeTreats"].Queries.Select_response_JSON

Which is basically this in SQL: SELECT V.UserName, V.UserEmail FROM customtable_IncomeTreats AS V FOR JSON PATH, ROOT('V')

Thanks, Ethan

   Please, sign in to be able to submit a new answer.