Expression rule to filter for the last entry of a DB table

Question

Please forgive me that probably very noob question - but I am really stuck here. My goal is to show just the highest three values in under Tempo > Records . 
 I have the following (working) code which constructs a expression rule. 
 a!queryEntity(
 entity: cons!myENTITY,
 query: a!query(
 logicalExpression: a!queryLogicalExpression(
 operator: "AND",
 filters: {
 a!queryFilter(
 field: "value",
 operator: "=",
 value: 42
 )
 },
 ignoreFiltersWithEmptyValues: true
 ),
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 50
 )
 ),
 fetchTotalCount: false
).data
 
 Instead of 42 I would like to have the three largest values the DB table, but I have no clue how to do that.

Bibhuti · Accepted Answer

Hello,
You can try something like the below example. Please verify my answer it it helps you.

a!queryEntity(
 entity: cons!myENTITY,
 query: a!query(
 selection:a!querySelection(
 columns:{
 a!queryColumn(field:"value")
 }
 ),
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 3,
 sort:a!sortInfo(
 field:"value",
 ascending: false()
 )
 )
 ),
 fetchTotalCount: false
).data

Expression rule to filter for the last entry of a DB table

Top Replies