Need to return latest version of custom table sop without using latest flag

[Arka Banerjee1]

Hi Team,

I need to return only the latest version in the search results of this portal for the records displayed. Cant use latest flag due to some restrictions. Please suggest. Please note that the search should return any general records as well matching the search key, here in the SS, I searched with the exact title.

Below is the search Source

@Ankur Bawiskar Please help

[palanikumar]

Hi,

Since this is custom table, it is difficult to give recommendation. 

I can see two possible option:

1) Create a field that says whether the current record is the latest version. This has to be automatically populated. Add condition based on this field

2) What is the size of the table? If it is reasonable then create a dynamic filter (should be less than 10,000) that gets the latest version of each record and can be used as filter

[Arka Banerjee1]

I cant create a field to mark latest as I said. Could you please suggest a way apart from that., like elaborating the dynamic filter suggestion that you mentioned. Thanks!