Question related to Saved search: If having a record with multiple sub-records (with for example different start-dates for the different sub-records) and I want to get a result in a Search showing information for my record with sub-record information for only the sub-record with the maximum start date. How can this be done? Any ideas?
n
Netsuite Tragic
03/07/2023, 1:01 AM
Use the Order By
Assuming
Start Date ,Group By, Maximum
Main Record Field 1, Group By, Maximum, Order By, Start Date
Main Record Field 2, Group By, Maximum, Order By, Start Date
👍 1
j
Joachim Lund
03/07/2023, 11:01 AM
Wow. That looks to be working just as I wanted it. Was not aware of the "When ordered by filed" function. Thanks a LOT for very good input!!!!