I have a data source, having the following structure:
When an order is created, it gets a 0 as the version number. When it is finished, it gets the 1 as the version number and a ending date is added. So, for all finished order the relevant version is the 1 and for all pending orders, the relevant version is 0. Any idea how to load only the latest version of any order. For the example from above meaning version 1 for the orders A, B and C and version 0 for order D.
Hi Kaushik, thanks for the quick response. I'm not so experienced, so what do you mean by "add expression". Where do I have to add this expression. Am I understanding right, that I allways have to read the complete table and make the selection afterwards. Isn´t it possible to use the SQL expression HAVING Max(Version). I've read in the manual, that this expression is existing, but I didn't accomplish to get it running it. Regards Michael