Advance reference qualifier works only for admins

[sameer S]

Hello , 

I have a reference variable called as "floor" which is populated with respect to the value of another reference variable called "building" . both reference to cmn_location table. I  used this reference qualifier on floor , it worked only for admins.

javascript: 'parent='+current.variables.building+'^u_active=true^u_location_type=floor' ;

Then I created a script include and called it from advance reference qualifiar as below however that also does the same.Works only for admins. Even I tried to turn off all the client scripts related to these two fields still no luck. 

javascript:new populateFloor().getFloor(current.variables.building);// populateFloor is script include and getFloor() is the function. I am passing "building" value to the function.

I checked ACL on cmn_location as well. No such restriction.

Can someone please advise why its happening ? Please help

Thanks & Regards,

Chinmaye

[eumak]

Hello Sameer,
It's strange but can you check, Is there any roles assigned for the particular field? Can you "watch" the field via clicking right click & see if you can find something? Does the floor field is in scoped application? If its in scope application, do you have access to read the table?

May be below thread will help you to figure it out

Advanced Reference Qualifier only works for certain role

Cheers..!
Tushar

[eumak]

Hello Sameer,

Did you get my solution useful? 

Cheers..!
Tushar

[Ankur Bawiskar]

Hi,

share the script include script here

Possibly that user might not be having read access on parent field on cmn_location table

Did you check table level READ ACL on cmn_location table is blocking?

Did you check field level READ ACL on parent field of cmn_location table?

Regards
Ankur