Lookup Select Box does not Return all Items

[Brian Hofmeiste]

Hello! 

I have added a column to the users table called "Job Level".  The column is type "choice" and has things like "VP", "Director", "Manager", etc.  I've created a request form that uses "Lookup select box" and references this "Job Level" field of the User Table.  When I test the form in the self-service portal it only shows me the Job Title associated with the current logged in user.  I would suspect it would show all options available, am I doing this wrong?

added some photos to illustrate.  

Thanks!

Brian

[Harish Kota]

Hi @Brian Hofmeiste 

Please share the screenshot of the Lookup select box, will check and update.

Thanks,

Harish Kota

[Brian Hofmeiste]

Here is a photo of the Job Level column on the user table

Here is a photo of the variable assigned in the request form using lookup select box.

Here is a photo of all the options being available on the USER record.

Here is the photo of the self-service photo only showing the current logged in user job level. (Not all options)

[Sagar Pagar · Accepted solution]

Hi @Brian Hofmeiste,

Can you just change the Reference table to Choice [sys_choice] and apply the filter/reference qualifier condition as -

javascript:"element=u_job_level^name=sys_user^inactive=false";

Note - add correct field name form user table. here, I assume its name as u_job_level.

Thanks,
Sagar Pagar

[Brian Hofmeiste]

Tried that and it's only pulling the username field of the user table, not the job level.