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!
Pseudo SQL Array
Hi all,
Is there a way you can use RANK / DENSE_RANK (or some other SQL function) as an array to then use inside a CASE or DECODE?
I'm trying to create a formula in a Saved Search that goes through all instances of a course topic (lesson) being run, in order to work out those topics a particular group HAS NOT yet had. I thought if there's a way I can record the group that has done each topic (of which we have many topics and many instances of these topics being run for all different groups), then I can use a CASE to see if my group is NOT IN the 'array' and show that topic as one they have not yet done.
Tagged:
0