Hi,
I have created a custom LU and one of fields requires LOV. LOV view is a standard view and I want to pass a WHERE clause. In this case, view is DISCRETE_CHARAC_VALUE and I always want to get records in LOV WHERE CHARACTERISTIC_CODE = ‘ABC’.
How can I get this done?
Appreciate your response.
Thank you.
Best answer by Kasun Balasooriya
View originalYou can use a saved search to populate a LOV. RMB in the LOV, then click ‘Properties’. There you can select a Saved Search.
+11
Hi
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
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
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.
+20
Hi Shewa,
Hi
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.
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
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.
+20
You can use a saved search to populate a LOV. RMB in the LOV, then click ‘Properties’. There you can select a Saved Search.
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.
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.
+20
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?
Yes, the above change can to be propagated to the users by saving this to the base profiles.
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?
Yes, the above change can to be propagated to the users by saving this to the base profiles.
You can use a saved search to populate a LOV. RMB in the LOV, then click ‘Properties’. There you can select a Saved Search.
you could try permission set filters but this could cause issues elsewhere on the system...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
