Hi, I am wondering if there is any ways to add a where clause in the default picker screen. Currently, out of the box we can create a picker in the UI and bound it to the entity class. When the user click on the arrow button a popup will come out and user can select one of the instances of entity class. What I am looking to achieve is that can we do a filter in this specific popup, so that only the entities belong to the same household will be shown for selection. The attached is the default picker screen.
If I understood your question correctly, to filter all results of the entity picker to be constrained to a household, you can add a where clause to the picker from the UI Action of the caller screen/form. This depends on the UI Action type:
Popup UI Action, you can specify the where clause in the advanced tab.
Script UI Action, you can specify the where clause on the “where” property of the popup (i.e. popup’where).