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.

Rookie Asked on May 14, 2020 in SuiteCloud.
Add Comment
2 Answer(s)
Advanced Answered on May 14, 2020.

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.

on May 14, 2020.

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.

on May 14, 2020.

It doesn’t and I can’t edit it because it is locked as part of a bundle.

on May 14, 2020.

Then you will have to do a  search on the custom record. There is no join relationship from the customer.

on May 15, 2020.
Add Comment

Did you set the “Record is Parent” on the custom field setup? That eases having joins in searches.

Beginner Answered on May 14, 2020.

I can’t edit the custom field – it’s part of a bundle and is locked.

on May 14, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor