Hi! We are having issues with a search/join in SOAP. Can someone please advice or give some recommendations? We have tried with below but we still get all records and not only record for actual vendorId.

<q2:search xmlns:q2="urn:messages_2019_1.platform.webservices.netsuite.com">
   <q2:searchRecord xmlns:q5="<http://www.w3.org/2001/XMLSchema-instance>" q5:type="q4:CustomRecordSearchBasic">
      <q4:recType xmlns:q4="urn:common_2019_1.platform.webservices.netsuite.com" internalId="111" type="customRecord"/>
      <q4:parent xmlns:q4="urn:common_2019_1.platform.webservices.netsuite.com" operator="anyOf">
         <q3:searchValue xmlns:q3="urn:core_2019_1.platform.webservices.netsuite.com" internalId="227"/>
      </q4:parent>
   </q2:searchRecord>
</q2:search>

It would rather be best to use the scriptid of the field that serves as the parent link as a field instead of the parent field

the parent field on a custom record is used for hierarchy