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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Can I simpify this SQL??
In a saved search I have a formula currency entry with a big SQL statement that I'd like to simplify - the first way should work but I'm wondering if I can do something like the second way to simplify it?
Option 1 - I have something similar working
case when condition 1 and cond 2 and cond 3 and A then $xxx when condition 1 and cond 2 and cond 3 and B then $xx when condition 1 and cond 2 and cond 3 and C then $xx else $0m end
ie you can see that I need to always use the same first 3 conditions joined with an extra condition, I'm looking for a way to put the 3 same conditions just once in the query so below is what I'd like to do but it doesn't work, any help would be appreciated.
0