I have a flat list data table, for example Teams-Members, where each member represents a row.
In a Low code app I would like to display this more nicely?
Do you have any suggestions?
I was thinking of having a Table showing the unique teams and on selection show the members in a different table. For this I would require a means to "Select distinct" on the raw data table (result of an ad-hoc data source communicating to an API)
If possible I would like to reduce the number of queries towards the raw data table.
Any help / suggestion is appreciated.
Hi Mieke,
Getting distinct values through GQI can be achieved in two ways:
- The 'Distinct' custom operator which is available on the catalog (see Distinct operator).
- Use a trick explained by Gilles here.
In both cases, we require all entries of the column to determine the unique values.
Do note that a drop down also supports displaying GQI results. This is an ideal component whenever a single selection is required.