Resolve Error: “SSS_INVALID_SRCH_FILTER_JOIN”

Scenario:

The following error is thrown: “SSS_INVALID_SRCH_FILTER_JOIN” when an nlobjSearchFilter contains an invalid join ID, or is not in proper syntax. 

This error is thrown if a SuiteScript record search operation has at least one nlobjSearchFilter object that uses an invalid join table ID. A join table ID is invalid if it is not included in the record type’s list of valid search joins, as indicated in the SuiteScript Records Browser. 

Solution

To make sure that all search join IDs are valid:

1. Open the SuiteScript Records Browser
2. Navigate to the record type being searched
3. Locate theSearch Joins table and check if all search join field IDs used in the code are found within the table