Question
2
Replies
225
Views
Uhg
Posted: April 15, 2016
Last activity: April 15, 2016
Closed
how to get the maximum pyid
how to get the maximum pyid
Message was edited by: Lochan to add Category
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Updated: 5 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.