Forum Discussion

Craig_G's avatar
Craig_G
Ideator I
4 years ago

Additional filter of query definition and tree grid view

Hello. On one the tabs for one of our item types, we use the tree grid view/query definition pattern to retrieve a list of the items parents. We've added a filter for is_current = 1, so that we only ...
ZackKiehn's avatar
ZackKiehn
Ideator I
2 years ago

While query definitions don't directly support MAX() or similar functions for limiting results, you can achieve a similar effect using sorting and limiting:suika game
- Sort the query results by generation in descending order.
- Set the "Maximum Number of Records" property for the TGV to 1.
This will display only the most recent parent, even for older item versions.