converting SQL request

smassot

Hello,
I have to do a request like that in Editor for requesting my resident database and filling the datatable :

SELECT resident.id FROM resident
    INNER JOIN (SELECT resident.id, MAX(date_modif) date_modif FROM resident GROUP BY resident.id) ss 
    ON resident.id = ss.id AND resident.date_modif = ss.date_modif

Could you help me with an example please ?
Thanks a lot.

allan

Hi,

Unfortunately such a complex query is not possible in Editor at this time. It does not support either sub-select statements nor the group by command. Sorry.

If you just want to show the data from that query you can easily run that query and show the data in the DataTable, but Editor wouldn't be able to edit it.

Allan

smassot

Ok Allan, thanks a lot for your answer I will do it using my own class and method no problem. Hope it will become supported by Editor in future. Very good job at all.

Regards.