Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Filtering saved search results using another record.
Hello!
I am currently new to NetSuite so please bear with me....
I have a need to be able to filter the results of a saved search for a record using data stored in another record. For example:
I have a custom record table that stores a association between an employee and a project. I have written a custom server script that ensures that there is only one entry in this table per employee (when an employee creates a new record in the table the server script deletes all the other records associated with this employee before saving the new record). I would like to be able to use this single entry to find all the sub-projects associated with the project field in the record and display them in a portlet. Basically what I am going after is