Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
dense_rank & decode on list
What I'm looking for is a list of Cases and want to include the date of the most recent Event completed (if applicable--in some cases there won't be an event associated with it). Furthermore, the "Event" I'm interested in displaying is for a particular type only (called "Event-Eval" in the example below).
I want to stay away from Grouping because we use direct list editing on the results... and grouping causes us to click away from the list too frequently. This is a highly interactive results list and direct list editing is essential.
I currently receive a list that has multiple lines for the same Case because it returns a separate line item for every Event on the customer's account. The results currently look like this:
0