Variable reference qualifier is not working in Variable editor

[vamsi]

Variable (Type: Lookup Selectbox ) Lookup Value from table having Reference Qualifier is not working on Variable editor.

i'm working on a requirement on Record Producer, The Requirement is as follows

User will fill some minimal data while submitting the record producer, once the record producer is submitted a custom table record will be created

The record created will have variables (which are hidden during form submission) those variables contains drop down values (Look up Select Box) populated from some tables.

Suppose just as an example consider the table below

TABLE: COUNTRIES& CITIES

Country	City
USA	Washington DC
USA	DALLAS
USA	Chicago
INDIA	MUMBAI
INDIA	HYDERABAD
INDIA	PUNE
AUSTRALIA	SYDNEY
CANADA	TORONTO
CANADA	OTTAWA

Variable1:

Name: country_1

Lookup From Table: COUNTRIES &CITIES

Lookup value Field: Country

Unique Values Only: True

Variable2:

Name: city_1

Lookup From Table: COUNTRIES &CITIES

Lookup value Field: City

Reference Qual: javascript:'u_country='current.variables.country_1

So the above configuration in Variable2 is populate the values based on country_1 variable on record producer

i.e. if country_1 field contains USA as selected value then city_1 field will only populate Washington DC, DALLAS, Chicago in drop down list.

This functionality is working good on Record Producer but the similar functionality is needed on Form's variable editor where if country_1 value is changed corresponding city_1 values should get populated. This is not working in Variable editor.

Any help is really appreciated.

Thanks,

Vamsi

[kartik8]

Hi Vamsi,

I am facing similar problem. There is a look up field on my record producer which is working fine in record producer form. But after submitting the record producer this variable is hidden in variable editor(once record producer submitted it creates change,the variable editor is on change form). Did you face anything like this? Please let me know if you know the reason behind it. I want this variable to be visible on variable editor too.

Thanks,

Kartik

[vamsi]

Hi Kartik,

I haven't underwent such scenario but usually all variables will get displayed on Variable Editor unless if you have any Client side Script (Client Script or UI policy or UI Script) explicitly doing some operation. This is just my anticipation/ assumption but there might be any other reasons as well .

Thanks,

Vamsi