Hi

I have a table with a column Version (int), that table also have a column Key, when the other columns change the value in column Key remains unchanged and the column Version is incremented by one.

Something like this: Key Other Version XX XA 1 XX XC 2 YY ZZ 1 YY ZY 2 YY ZW 3

and i want to filter the collection of these entities to only get that (max(version) group by Key): XX XC 2 YY ZW 3

It is possible? How?

Regards

Desbaratizador

As ever with queries like this, think about the SQL first, and work back from there. Can you create a SQL query that returns the results that you need ?

I'm guessing it will be something like

SELECT Key,Max(Version) FROM table GROUP By Key

If this is the case have a look at the documentation about using GROUP BY to generate DynamicLists

http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/Adapter/Using%20TypedViews,%20TypedLists%20and%20Dynamic%20Lists/gencode_usinggroupbyhaving_adapter.htm

Matt

OK.

I'am using the SelfServicing pattern and with this pattern i could use the getMultiAsDataTable method with something like to a GROUP BY filter to obtain the result as a DataTable, but if i want to get the result as a collection of entities?

Desbaratizador

So, you want something like:

SELECT * FROM myTable
WHERE key IN
(SELECT key, MAX(version)
GROUP BY key)

You can achieve that and retrieve entities, using FieldCompareSetPredicate. Give it a try and let us know whether you need further help.