Discussions
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