Hi, What is the best way to list unique values from a datasource? E.g. I want to list all contractlines with a specific value, and I want to group them per contract header. So one contract header can have many lines. Some contract header might not have lines with the specific value and other cont…

Hi! You can list your values by using two repeating containers. In the first container you iterate your contracts data source, and in the second the contract lines data source. You can “connect” these two containers by using a filter on the second container, which displays all contract lines which c…

How to list unique values

Ask the community

Preben June 14, 2023, 9:09am 3

Thanks for your answer. So there is no other way then looping through all records to find the unique values?

There is no function similar to a SQL SELECT DISTINCT Statement?

Unique values from object class

Topic		Replies	Views
Output only unique object classes in a many-to-many relationship data Ask the community	1	194	April 20, 2023
Extracting data Ask the community app-data	1	218	March 14, 2023
Data model - object referencing and filtering Ask the community	2	218	September 8, 2023
Bug with "Read all" in database Bugs	3	190	January 20, 2023
How to display a list of runtime objects before persisting it Ask the community ui , app-data , runtime , data-source	2	301	April 19, 2023

How to list unique values

Related Topics