How to find identical rows with the same Property values and filter those rows?

Question

Could you please help how possible to do it?

I am working with Query Definition and Tree Grid View.
I would like to make my own view with some Part filter options.
How can I find identical rows with the same Property values and filter those rows?
For example. We can see the picture below in column ‘Property1’ that two values AAA equals.
I need to find and filter out these lines.
How can I do that?

Many thanks
Best Regards,
Erlandas

erlandas · Answer

Hi,
Could you please answer. Is this question is not clear or too complex?
Is it possible to do so with&nbsp;Query builder or not?
Then how would you advise?

Thank you
Best Regards,
Erlandas

angela · Answer

I am not sure if it´s possible to use TGVs to display&nbsp;only&nbsp;duplicates. When you just want to do this&nbsp;for validation from admin side it´s maybe easier to achieve with an SQL View.&nbsp;
You can use filter for Tree Grid Views to filter your result for 'AAA'. But in this case you need to know the value you are looking for.&nbsp;
See:&nbsp;https://community.aras.com/b/english/posts/tech-tip-filter-a-tree-grid-view-with-parameters

Forum Discussion

How to find identical rows with the same Property values and filter those rows?

2 Replies

Recent Discussions

Tree Grid View slow: reads whole branch on expand — improvement ideas?

Auto expand x-properties

Does anyone see performance issues in Chrome

Aras 11SP9 Chrome remove XSLTProcessor

How to highlight a custom CUI Button like the Notification Button based on events of interest?