#queryEntity #distinctrows Hi, I want to fetch distinct rows from a table using

@ankitab I assume that you don't require a grouping in your scenario, if so, as per my knowledge it's better to delegate the processing to the database (might be a database view) rather than making use of a!queryEntity() or a fn!union() function over resultant datasets. The same has been mentioned at https://forum.appian.com/suite/help/7.11/Query_Recipes.html#Get_the_Distinct_Values_of_a_Field as 'It will almost always be significantly faster to have the data source do the uniqueness calculation before returning the data to Appian.' Let's see if other practitioners can come up with better suggestions.

@ankitab I assume that you don't require a grouping in your scenario, if so, as per my knowledge it's better to delegate the processing to the database (might be a database view) rather than making use of a!queryEntity() or a fn!union() function over resultant datasets. The same has been mentioned at https://forum.appian.com/suite/help/7.11/Query_Recipes.html#Get_the_Distinct_Values_of_a_Field as 'It will almost always be significantly faster to have the data source do the uniqueness calculation before returning the data to Appian.' Let's see if other practitioners can come up with better suggestions.