How to display One Choice field values based on another choice field- in Catalog Item

[chanikya]

Hi,

here i have two Choice list variables, so how can i get values

How Display Site values based on Region, .....&   

javascript:'u_region  ='+current.variables.u_regionnn  is same script work for this also??? , 

i have tried it, but not working

site variables calling values from  Desktop Support table (two fields is there 1.Location Name, 2.REgion)

[chanikya]

it is a field in Desktop Support Location table

my request is , is it possible to display Site names which records of state =Publish  ,under site variable  based on Region 

[SanjivMeher]

Yes. You can add '^state=publish' to your existing reference qualifier, provided state is the field name and publish is the value.

[chanikya]

in Site Variable Reference qualifier

is it right???:     javascript:'u_region='+current.variables.u_regionnn^state=publish   

and set the variable attribute as ref_auto_completer=AJAXReferenceChoice,ref_qual_elements=u_regionnn

Make sure the back-end value of each option in Region in catalog form matches with the back-end values of each option in the region field on Desktop Support Location

[SanjivMeher]

Yes, Change it to

javascript:'u_region='+current.variables.u_regionnn+'^state=publish'

[chanikya]

Thanks Sanjiv...!!!

 it is working fine.....!!

Thanks a lot!