Parent children fields dependent on Record Producer

[Giovanni Tambur]

Hello everyone, I need to create two fields on a Record Producer connected to the cmn_location table, the first that shows me all the values of the locations that have no parent and the other that only shows me the values that have the Parent value selected on the first field.

The first field works, I configured it like this:

And it shows correctly the data I need:

The second field, on the other hand, I can't configure it correctly, on "Type Specification" I can't find adequate conditions for the filter. I added on "Auto-Populate" the dependency to the question where the Parent is selected but this doesn't help.

This shows all unfiltered values:

When in this case, selecting Belluno should only show the fields Piazza dei Martiri and Piazza delle Erbe.

Obviously this is just an example so I can't set a Reference qualifier condition

Do you have any ideas to suggest, maybe OOB.

Sorry for my English

Thanks in advance,

Giovanni

[Ankur Bawiskar · Accepted solution]

@Giovanni Tambur 

So 2nd variable should show locations whose parent is the value selected in 1st variable?

if yes then add this in advanced ref qualifier on 2nd variable

javascript:'parent=' + current.variables.firstVariableName;

[Ankur Bawiskar · Accepted solution]

@Giovanni Tambur 

So 2nd variable should show locations whose parent is the value selected in 1st variable?

if yes then add this in advanced ref qualifier on 2nd variable

javascript:'parent=' + current.variables.firstVariableName;

[Giovanni Tambur]

Thanks for your reply.

My 1st variable is called "sito", I changed the 2st variable as follows:

Unfortunately I was on the Record Produces I do not get any results

[Ankur Bawiskar]

@Giovanni Tambur 

are you sure the location Belluno has child locations?

Can you share that from locations table? how is Belluno related to Piazza dei Martiri and Piazza delle Erbe

[Giovanni Tambur]

yes I can confirm that they are connected:

indeed, I'll tell you more, from the opening page of the incident, I added the same fields and here it worked right away.