RE: 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.

cja Rookie Asked on May 14, 2020 in SuiteCloud.
Add Comment
2 Answers

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.