Advanced Reference Qualifier Based-On Current Variable

[codechaser]

Need help setting-up an advanced reference qualifier that uses the 'u_term_code' field from the *Term drop-down as a dependency and returns a list of courses that share the value.

javascript: u_term_code = current.variables.u_term_code;

Above, is the code I currently have.

[codechaser]

No such luck.   I even tried setting 'javascript: course = new GlideRecord('u_bsu_terms'); course.get(gs.getReference()); course.u_term_code;' as the Default value, with no luck.

[maricielo]

Thanks!  this help me a lot! it works.. only one question...

If I need to add some information to my query:

This is working

javascript:'category='+current.variables.u_category;

But when I do this:

it doesn't work... why?

javascript:'category='+current.variables.u_category^u_delete=false^u_stateLIKELive^EQ;

[Michael Ritchie]

You are basically creating a string of an encoded query.  So starting with "javascript" is telling the server to evaluate the string following so that you can dynamically set values such as your current.variables.u_category.  But then you want to add some additional parts to the query.  That is a string so you need to do this:

javascript:'category='+current.variables.u_category + '^u_delete=false^u_stateLIKELive^EQ';

[SanjivMeher]

javascript:'category='+current.variables.u_category+'^u_delete=false^u_stateLIKELive^EQ';

[Harsh Vardhan]

Hi Jason,

is there any relation with dropdown and reference field.

are they storing in sys_user table?