How the list Collector field dependent on another list collector field in catalog

[varshajain]

I have one list collector field country which takes reference from core company table
and other list collector field Company Code which takes reference from custom table and in this custom table one field country which takes reference from same core company table.

Now I want whatever multiple value I selected in country, its dependent code should only visible in company code field. 

I tried with client script and reference qualifier but it doesn't work.

[Ankur Bawiskar · Accepted solution]

@varshajain 

u_country_reports -> reference to core_country table?

Share dictionary config screenshot for this

variable "for_which_countries_do_you_want_the_" refers to core_country table?

share variable config screenshot for this

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@varshajain 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@varshajain 

it should work, please share screenshots of 2nd variable config and other details.

no script include required

If my response helped please mark it correct and close the thread so that it benefits future readers.

[varshajain]

Hi @Ankur Bawiskar 

I shared the config of 2nd variable where it is List Collector and takes reference from custom table.

[Ankur Bawiskar]

@varshajain 

I suggested to use direct advanced ref qualifier without script include.

in your custom table this field "u_country_reports" is referring to which table?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[varshajain]

@Ankur Bawiskar 
"u_country_reports" is one of field in custom table "u_hr_requestmanagement_option" , and this field stores the name of country.

And 2nd field takes the reference from this Custom Table 

[Ankur Bawiskar]

@varshajain 

u_country_reports -> reference to core_country table?

if yes then this will work

Note: colon : gets converted to : while saving the comment, so update accordingly

javascript: 'u_country_reportsIN' + current.variables.for_which_countries_do_you_want_the_report_for;

In variable attributes of 2nd list collector add this, without this it won't work

ref_qual_elements=for_which_countries_do_you_want_the_report_for

If my response helped please mark it correct and close the thread so that it benefits future readers.