Skip to main content
December 19, 2025
Question

Getting Duplicate values using Query entity 24.4

  • December 19, 2025
  • 2 replies
  • 0 views

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
December 20, 2025

What did you try so far?

shubhama926776
December 22, 2025

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