search

pegros / PEG_LIST

Set of configurable/actionable LWC list components for Salesforce Lightning UX
MIT License
20 stars 8 forks source link

[feat] sfpegListCmp - Support SAQL queries #36

Open pegros opened 1 year ago

pegros commented 1 year ago

Is your feature request related to a problem? Please describe. Provide SAQL support in a similar way to SOQL and SOSL to fetch data.

Describe the solution you'd like Register a SAQL query in the sfpegList configuration record and choose SAQL as query mode.

Describe alternatives you've considered Initially a direct SAQL support within the component was prototyped, but this prevented any deployment on an Org with CRM Analytics not activated. A better option would then be to provide an add-on Apex generic class implementing SAQL queries and relying on the sfpegList configuration record (query template) to know which query to execute.

Additional context Tricky issue is the retrieval of DashboardId and VersionId to be set in the SAQL query, IDs required when executing SAQ queries from Apex.

pegros commented 7 months ago

This is achieveable via a custom Apex implementation with a named credential to call SAQL query endpoints. Example code to be provided soon.