Dependency using reference type field

[ArpitaVK]

I have 3 tables A, B, C and having dependency on each other. B is dependent on A and C is dependent on B and A. We have used reference type field to make the dependency. In the catalog item, we have created 3 variables for 3 tables and want to make dependency as like in the platform tables. We have added the Reference Qualifier on B and C variable but it is working for B variable and some of the data in C variable. How we can resolve the issue in C variable?

Thanks in advance!

[Rushi Savarkar · Accepted solution]

Hello @ArpitaVK 

To resolve the issue, please verify below points:

1. Verify the reference qualifier on the C variable

2.  You may need to change the type of the field from reference to List type in the platform view if there are multiple dependencies on the C variable.

3. Before changing the type of the field, please verify the data you are receiving.

4. After changing the type to the List, please verify the reference qualifier condition again on the C variable.

5. If you are not getting values in the C variable, then there is a problem with "mismatched sysIDs". 

Thank you!

[ArpitaVK]

@Rushi Savarkar, Thanks for your solution. There was a problem with mismatched sysIDs. After changing the type to List, we were able to map the unique values in the data.