Question

Database Retrieval

0

Hi all, How to retrieve only the last record in a database? For retrieving the first object, there is a explicit option. But not able to retrieve the last object. Thanks.

asked 2019-12-09

Rohit Muralidharan

2 answers

Maarten Bongers · Answer 1 · 2019-12-09

Hi you could do a sort on one of the attributes that you like in the retrieve(ascending or descending) then just pick 'first’. This way you can get the last item from a list based on your sorting.

david verstricht · Answer 2 · 2019-12-09

Hi,

In your domain model, when opening an Entity,

you can select to store 1 or more System members.

One of those system members is: ‘Store CreatedDate’

You can use X-path to access this member, then sort DESC, and so you can access the last created object