Pulling linked data through in a product search page

Need help Database
1

Hi, I’m looking for some help on a problem I just can’t crack, hoping you can help…

I have a product search page in my app with various filters to allow the user to find the appropriate product listing in repeating group format. All the data that pulls directly from my Product data type in my database is appearing in the dynamic fields correctly apart from 2.

These 2 items are the origin country and region of the product, which are captured in the product database however, these data fields are linked to a country and region data type respectively to allow me to manage the origin data easily and avoid erroneous country spellings etc. When I set up the dynamic data for these fields, I set them up as the others “Parent group’s product Origin Country’s name_text”. All other fields that only reside directly in the product data type pull through fine, but these 2 that reside in country and origin data types and are displayed as fields in the Product data type show as blank when previewed.

Any idea what I doing wrong? Is it wrong to set up the data in this way? Its kind of important to my product to have the provenance of the product managed correctly so was keen to keep it.

Any help would be greatly appreciated.

2

Possible causes to check..

  1. The product doesn’t actually have an Origin Country or Region defined - so check that first.
  2. Your Privacy rules don’t grant access to the Origin Country and Region nae fields - so check that next.

But I’d use the Debugger first, as that will show up either issue or, if it’s neither, it should show you exactly what it is.

3

Thanks @Adamholmes, appreciate the response. #1 is not the cause, I set up test data in my database to ensure I had 6 or 7 products set up with all fields completed. I can see the Origin country and region listed in the product data table for each entry. But the privacy rules are one I haven’t checked so thanks for the tip. I’ll check it out.