I have written code that grabs a column from a table in an element and returns a list of all unique entries.
In this case it’s a list of Customers.
I want to expose this list as a Custom Data Source so that I can use it in a dropdown feed.
I have checked the Kata 4 video, but it’s not clear what I should do to expose this List.
What’s the proper way to do this?
Second question, how often will it go through this Customer table to feed the dropdown?
Hi Jeroen,
Parameter data is already exposed by the native GQI data sources. Not sure if your own ad hoc data source is required for this?
If you have access to your data source through GQI, then it’s as simple as dropping it on your dashboard/app and selecting the drop down visualization. If you don’t see your ad hoc data source in the query builder, then perhaps you have a compile error. This can be checked by validating the automation script in the Automation module.
As for your second question, the data source will return data every time a user visits that page.
A custom data source is not needed in this case.
Following post helped me
https://community.dataminer.services/question/low-code-app-retrieve-unique-value-with-a-query/