Question
2
Replies
204
Views
Uhg
Posted: 4 years ago
Last activity: 4 years 5 months ago
how to get the maximum pyid
how to get the maximum pyid
Message was edited by: Lochan to add Category
Posted: 4 years ago
Posted: 4 years ago
Updated: 4 years ago
Hi,
You can actually browse on class Data-UniqueID for property pyLastReservedID with condition set pyPrefix = <your prefix of pyID>. it will return only one row and pyLastReservedID will have the last used number in it.
Regards,
Goutham
Is it for a specific class? If yes, create a report definition and then use a SQL function to get the numeric part of the pyID and then apply the max aggregate function on it.