Dupicate record after a search

Classic Servoy
1

Hello,

When I do a search with related tables I obtain the same record several times on my result’s list.

I can’t use a SQL request like “SELECT DISTICT …” because it’ll be very diffcult to construct it.

I would like to know if Servoy have a method to do “DINSTINCT” on a search?

Thanks.

2

Why would a select distinct be difficult to construct? Just do something like

var query = 'SELECT DISTINCT (table.primary_key) FROM table, other_table WHERE ...';
controller.loadRecords(query);

The difficult part (if there is) is constructing the where, not the distinct, isn’t it?