Hi everyone! I am having an issue regarding duplicate record. Any idea on how to only get 1 record out of these duplicate using filter? Thanks!
Hi Richard,
You could use Group By on one of the Project attributes to get unique records, but there could be a better way to rewrite your Aggregate and ensure it only returns what you need. Could you show us more of it? Entities, joins and current filters would help us give you more solutions.
Afonso could you please check this above doubt?
Richard Repolona wrote:
Try to use ListDistinct system action to filter duplicate elements.
Regards
seema
Hi SEEMA & All,
Hope You Can Help Me..
I was facing as couldn't filter the data to avoid duplicate elements from an aggregate because I using structure so i need to mapping by LISTAPPEND() . except this method(Without going the SQL)
I need a solution like a syntax format to filter ...
Is there anyother way to fix this issue?
Hi,
The other option is "White your own SQL Query"!
"The SQL element allows you to execute, test, and review custom SQL queries in your applications. The element provides flexibility in data manipulation, but we recommend using Aggregates when applicable. Aggregates are highly optimized and easier to maintain."
For more details, see https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/SQL_Queries.
Best Regards,
Wilbert Carpi !!!
Typically this is caused when a join is missing or not implemented correctly. Recheck your joins to make sure they're working properly.
use the SQL element for best result, in this case use distinct. Other way is using group by on aggregate.
I preffer use the SQL element and write the query for this.
Regards.
Thanks everyone! Done it using groupby :)
There is a better solution my friend :
use group by in aggregate you will keep the current database and keep performance at the same time, creating a duplicate list will flood the system performance if we talk about big data .