Is it possible to make a filter default in a Reference field?

[spracntgw]

Hi All,

All I want to do is to make my filter default (in a pop up window of a reference field), but I don't know how to do.

Could you please give me some advice to me?

-------------------------------------------------------------------------------------------------------------------------------------------------

Below is a pop up window of a reference field (sys_user table).

Usually it is not narrowed down, hence All users are always shown.

Is it possible to set the filter from the moment that I opened the reference field?

I have made my filter (red out),

I guess my wish will come true by setting the red-out be defaulted....

(Reference Qualifiers is NOT good because it does not display Breadcrumbs)

Best regards,

Tomoaki

[James100]

Is there a solution for this question today?

The  default filter is still not available for reference lists.

[Sigval Bergesen]

did you try my suggestion?

[ralvarez]

The method you’re suggesting (using Configure > List Control and setting a default filter) only works when the referenced table is used in a related list — not in the reference field popup. For the default filter to apply, the table must be set in the Related list field of the List Control, and in that case, the configuration will not affect the reference lookup modal.

If the goal is to have an editable default filter in the reference field popup, the correct approach is to:

1. Go to the referenced table.

2. Open a list view and apply the filter you want to use by default.

3. Save this filter as a sys_ref_list record.

Unfortunately, this does not work in Workspaces.