Skip to main content
Known Participant
Dec 19, 2025 11:03 PM UTC
Question

Getting Duplicate values using Query entity 24.4

My Requirement is I need to fitch data from a view where all the columns are unique except 2 column data i need to show the unique data in the records page just filtering these two records. can you please help me with this using a!queryentity()

2 replies

stefanhelzle0001
Brainy
Dec 20, 2025 1:53 PM UTC

What did you try so far?

shubhama926776
Brainy
Dec 22, 2025 10:20 AM UTC

When you say filtering these two records - do you mean you want to:
Show only rows where those 2 specific columns have unique combinations (remove duplicates based on those 2 columns)?

Use a!queryEntity() with a!queryAggregation() : Groups by all columns, effectively removing duplicates based on your 2 columns while preserving other unique column data.​​​​​​​​​​​​​​​​

शुभम्