Hi,
If I have a table with the same (enduser) Name (let say I have a company with multiple transactions of the same enduser) multiple times, how can I filter that Name in order to appear only once?
I ve tried to make a new custom filter and use WHERE DISTINCT {E}.buyer.name but doesn’t work.
Below collectionDatasource query doesn’t work as well:
[select distinct (e.enduser.name) from crmrai$Transaction e
where e.enduser.id = :ds$organisationDs]