Joining Through Custom Fields
If you are using 2013.2 or a later WSDL, you may notice that many RecordType Search objects include CustomSearchJoin. This object lets you join to records that are associated with the primary record through a custom field.
That is, if Record A includes a custom field of type list/record or multiple select, and this custom field references another record that is exposed to SOAP web services, the 2013.2 WSDL and later WSDLs allow your search of Record A to include a join to the SearchBasic of the referenced record.
Similarly, many RecordType SearchRow objects now include CustomSearchRowBasic. You can use this object to include columns from the referenced record in the results of an advanced search.
See the following for more details on executing searches using CustomSearchJoin and CustomSearchRowBasic:
Related Topics
- search
- Basic Searches in SOAP Web Services
- Joined Searches in SOAP Web Services
- Advanced Searches in SOAP Web Services
- Setting Valid Search Values
- Setting the anyof, mine, or myteam Filtering Values
- Searching by lastModifiedDate
- Understanding Sorting in Advanced Search
- Search-Related Sample Code
- Searching for a Multi-select Custom Field
- Search Issues and Best Practices for SOAP Web Services and SuiteScript