You can use a saved search to populate a LOV. RMB in the LOV, then click ‘Properties’. There you can select a Saved Search.

Hi @shewa,

Could you please mention the configurations of the custom field: 

i.e. type of the custom field (persistent, read-only), any SQL statement used, etc.

Best Regards,
Binura.

Hi Binura,

Thank you very much for the reply. This is a persistent field, Reference field. Below shows the Reference page of the wizard. No SQL statements used.

Thank you.

Hi @Binura Dodangoda ,

Sorry, I am not sure you have received my reply.

Thank you very much for the reply. This is a persistent field, Reference field. Below shows the Reference page of the wizard. No SQL statements used.

Thank you.

Hi Shewa,

The screenshot from the wizard is missing in your reply, but I assume you are replying to the below screen: 

If you want to add a where clause to the select statement when running the query ( Can be seen when preview is pressed) as shown below, it can’t be edited. 

Do you want to store this value in the database for this particular filed under the Custom LU? 

Thanks,

Hi @KasunBalasooriya ,

That was the screen shot I was referring to.

Yes, I want to store value in the database under field TEST in custom LU. LOV should only show values where CHARACTERISTIC_CODE = ‘ABC’. In your screen shot above, it shows values for all characteristic codes.

Thanks.

This is the answer for your question. I’m attaching the screenshots for you to refer: 

Once the above option is set, you should get the LOV filtered with the values for CHARACTERISTIC_CODE = ‘ABC’

Hope this helps! 

Thanks. 

@KasunBalasooriya ,

Thank you Kasun. If it is the only way of achieving it, that's fine.

Could you please let me know how this will affect on user profiles? Should this to be saved into Base Profile for all the users to see only values in saved search?

Default Searches for a LOV must be included in the Base Profile.

Yes, the above change can to be propagated to the  users by saving this to the base profiles. 

@KasunBalasooriya Thank you very much for your response. Eventhough it is not ideal, saved searches work...

@Jur Thank you very much Jur. It is the only solution it seems.

you could try permission set filters but this could cause issues elsewhere on the system...