I am making a search on a custom record.
I want to...
# suitescripta
Azi
04/29/2020, 5:11 PMI am making a search on a custom record.
I want to group the results by a specific field, but only get the most recently created record for each grouping.
(How) Can this be done?
a
Andrea Rivetti
04/30/2020, 11:44 AMthis is the base of SQL grouping. So how can you "select" a field of record with a single query when basing on the grouping criteria of another colum? Impossible...
Andrea Rivetti
04/30/2020, 11:45 AMYou need a nested query.
Andrea Rivetti
04/30/2020, 11:47 AMP.S: I'm assuming you are trying to get this using a Saved Search only
Andrea Rivetti
04/30/2020, 11:48 AMUsing script it's really easy
a
Azi
04/30/2020, 2:12 PM@Andrea Rivetti
@erictgrubaugh's cookbook answer fit my needs perfectly
👍 1
3 Views