Lookup Select Box does not Return all Items

Brian Hofmeiste · ‎12-12-2022

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

Sagar Pagar · ‎12-12-2022

Hi @Brian Hofmeiste,

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

javascript&colon;"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

The world works with ServiceNow

View solution in original post

Sagar Pagar · ‎12-12-2022

Hi @Brian Hofmeiste,

Reference or Table should be slect6ed as Choice [sys_choice] instead of User [sys_user].

Thanks,
Sagar Pagar

The world works with ServiceNow