Hi,
I have multiselect lookup control where I want to show distinct values since in the table that I am using as a query datasource I have multiple records with the same ID and I only want one to be shown.
I use
qbds = query.addDataSource(tableNum(MyTable));
qbds.orderMode(OrderMode::GroupBy);
qbds.addGroupByField(fieldnum(MyTable,Typeid));
But then when I want to get the container using
container selectedRecords;
selectedRecords = msLookupCtrl.get();
I dont get anything in the container.
Note that when I dont use group by function, I get records in the container.
Any help? IS there some other way how I can select distinct?
