Display Filter In Dictionary when choose value of Reference Field

[Dinh Nguyen]

Hello everyone,

I am having a problem with the Reference field filter and I don't know if my problem is feasible. Specifically:

I have created field "Test Filter Of Reference Field" as below with filter is Sys ID = current user:

But when I select "1" as in the picture, it opens a list from the reference table to choose.
This list has been filter correctly as set in Dictionary, but in "2" the filter is "All".
I want in "2" to be filter "SysID = sysid of current user" instead of "All" as in the picture. Is this possible?

Please someone help me, if this is possible please tell me how to setting it.

Thank you so much.

[Shree_G]

Hello @Dinh Nguyen ,

Below is working for me, try below code to see it it works for you. Reference qualifiers or queries from business rules  would not show the filter where you are expecting. It would always be "ALL" 

sys_id=javascript:gs.getUserID();^EQ

[Dinh Nguyen]

Hi @Shree_G ,

Thanks for suggesting me, but this setting doesn't work for me. I tried your solution but the filter is still "All".

[Robert H · Accepted solution]

Hello @Dinh Nguyen ,

No, this is not possible.

The purpose of the Reference qualifier is to pre-filter the records that can be selected in the reference popup, to make sure the user can never select anything that does not meet the Reference qualifier condition.

So "All" means "all the pre-filtered records" here, and users can filter those further using the condition builder in the popup.

Regards,

Robert

[Dinh Nguyen]

Hi @Robert H ,

I got it, thanks for explaining it to me.

So do you know if there is a way to set a default filter for reference field and users can edit this filter? Please tell me