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

Hi Ankita This post might help you
forum.appian.com/.../e-120965

Go through the below link, it will give you an idea on how to get distinct values using queryEntity. forum.appian.com/.../Query_Recipes.html

@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.

Could you please eloborate the use case.

i am displaying a report. Here, for one caseid there are multiple objectnumbers. both are in different tables. Intially, i was showing multiple rows depending on the object numbers. So ift caseid "A" has 5 object numbers, then there would be 5 rows in the grid of the report for the same caseid. But now, i dnt want to display the object numbers. so there would be only one row per caseid. However, I have a filter criteria on object number. So by searching a particular object number it would return me the caseids which have the matching object number

Use rule!APN_distinct(array) ...should fix your issue.

hi guys, this issue is resolved. i made two datasubsets querying from two different tables and on the basis of the users selection os the search criteria, we are displaying the required datasubset in the grid