How to search for customer record joined with instances of a custom record which reference that customer record
We have a custom record which has a List/Record field that references a customer record. How can I do a search in SuiteTalk to get some fields from the customer record plus all the instances of that custom record which refer to that customer record?
If it helps to make it clearer:
We have custom record type C. It has field CF, which is List/Record referring to Customer record.
I want to do a search in SuiteTalk which gets Customer where internalid = 1 and all instances of C which have CF referring to Customer with internalid = 1.
Thanks, that’s what I’m using but it isn’t working and I think the reason is because it’s intended to work when there is a field on the searched-for record that references the custom record, whereas I have a field on each of the custom records which references the search-for record.
Its equivalent to the parent/child join in a saved search in the user interface. As long as your custom record field has the Record is Parent checkbox marked it should work.
It doesn’t and I can’t edit it because it is locked as part of a bundle.
Then you will have to do a search on the custom record. There is no join relationship from the customer.
Did you set the “Record is Parent” on the custom field setup? That eases having joins in searches.
I can’t edit the custom field – it’s part of a bundle and is locked.
