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.
Custom Record Saved Search
We have a custom record called 'Searchable' that maps to the item record. I'm trying to create a saved search that pulls all items that don't have an associated searchable record with the name 'Blade Pitch'.
An equivalent SQL query might be:
select item_id, name from items
where item_id not in
(select item_id from searchable where attribute_name <> 'Blade Pitch')
Is there a way to do this in a saved search?
Thanks for your help,
Rob
0