How to get Top 1 record from database table using expression rule

Question

Hi, 
 I have an expression rule which is returning data from the database table. 
 Now, I would like to get a latest db record using that expression rule. 
 How can I achieve this. 
 
 Any advises please. 
 
 Thanks.

Sanchit Gupta (Xebia) · Accepted Answer

Yo can apply paging and sorting configuration by passing pagingInfo in your query with startIndex and batchSize equal to 1 and sort: sortInfo("primaryKey",false)

Harshit Bumb (Appyzie) · Answer

Please use the key-value pair while passing such values. 
 sortInfo(field: "primaryKey",ascending: false)

How to get Top 1 record from database table using expression rule

Top Replies