Reference qualifier not working

jose_quinonez · ‎12-01-2023

Hi,

I have a reference variable refvar1 in a catalog item.

The referenced table is u_table1.

u_table1 has a field called u_user, which is a reference field to sys_user.

I am trying to filter values in refvar1 so it only shows records in u_table1 where u_user is the logged-in user.

I wrote this advanced reference qualifier in refvar1:

javascript&colon; 'u_user=' + gs.getUserID()

It is not working. Please help.

Thanks

AnveshKumar M · ‎12-01-2023

In this case you can use simple Reference qualifier instead of using Advanced. Like the one below.

Select Simple in Use Reference Qualifier field and click on add filter condition. Then add the condition like.

YOUR FIELD NAME :: IS (Dynamic) :: Me

See the screenshot below.

Please mark my answer helpful and accept as a solution if it helped 👍✅

Thanks,
Anvesh

VaishnaviShinde · ‎12-01-2023

You want to add logged in user into u_user field ? Can you elaborate requirement?

AnveshKumar M · ‎12-01-2023

In this case you can use simple Reference qualifier instead of using Advanced. Like the one below.

Select Simple in Use Reference Qualifier field and click on add filter condition. Then add the condition like.

YOUR FIELD NAME :: IS (Dynamic) :: Me

See the screenshot below.

Please mark my answer helpful and accept as a solution if it helped 👍✅

Thanks,
Anvesh

jose_quinonez · ‎12-04-2023

Thank you Anvesh!

That was much easier!

Do you know if there is something wrong with the use of gs.getUserID() that I was trying?