Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Left join not possible in saved search?
We are trying to search for Items, and essentially return transaction information only where available, but return all other item records even if there is no sales history.
So, I set up a saved search and added "Transaction fields..." to filter the criteria as needed (date, type, account, etc). The issue is that I want to return ALL item records and show only transaction data for those that have it - like you would with a SQL Join. Basically, I am looking for a Left Join, displaying NULLS where necessary.
Any help on accomplishing this is appreciated. I perused the forum but surprisingly can't come across a post with a similar need.