Is there a way to filter the entries displayed in an LOV in a form? Let say I have an LOV with 10 entries but I only want to offer up 6 of the 10 to the user. Is this possible?
Best Answer
A
Alexia SIMOND
said
over 1 year ago
Hello Matthew,
If this LOV is a simple attribute of type LOV, then there is no way - that I know of - to filter the values on a condition.
However, if it is a closed list of values, then you could directly put those values in the "List Items" with the list type set to "manual-list":
But if the LOV is a reference, then you can configure a picker filter in the stepper for this reference. And there as you'll be able to use semql, conditions can be added up to semql capabilities:
Please let me know if you have further questions on this topic.
Have a good day.
Alexia
1 Comment
A
Alexia SIMOND
said
over 1 year ago
Answer
Hello Matthew,
If this LOV is a simple attribute of type LOV, then there is no way - that I know of - to filter the values on a condition.
However, if it is a closed list of values, then you could directly put those values in the "List Items" with the list type set to "manual-list":
But if the LOV is a reference, then you can configure a picker filter in the stepper for this reference. And there as you'll be able to use semql, conditions can be added up to semql capabilities:
Please let me know if you have further questions on this topic.
Matthew AMMONS
Is there a way to filter the entries displayed in an LOV in a form? Let say I have an LOV with 10 entries but I only want to offer up 6 of the 10 to the user. Is this possible?
Hello Matthew,
If this LOV is a simple attribute of type LOV, then there is no way - that I know of - to filter the values on a condition.
However, if it is a closed list of values, then you could directly put those values in the "List Items" with the list type set to "manual-list":
But if the LOV is a reference, then you can configure a picker filter in the stepper for this reference. And there as you'll be able to use semql, conditions can be added up to semql capabilities:
Please let me know if you have further questions on this topic.
Have a good day.
Alexia
Alexia SIMOND
Hello Matthew,
If this LOV is a simple attribute of type LOV, then there is no way - that I know of - to filter the values on a condition.
However, if it is a closed list of values, then you could directly put those values in the "List Items" with the list type set to "manual-list":
But if the LOV is a reference, then you can configure a picker filter in the stepper for this reference. And there as you'll be able to use semql, conditions can be added up to semql capabilities:
Please let me know if you have further questions on this topic.
Have a good day.
Alexia
-
LOV label in Named Query
-
How we can set Dynamically changing Form field Description?
-
Is it possible to have a conditional survivorship rule based on a SemQL filter (akin to the filter on privileges)?
-
Where Do I View 2 Merged Records?
-
Show/hide an attribute in a form
-
Restrict access of attributes
-
Is it possible to manage visible/invisible value in List depend on user role??
-
Why am I unable to merge duplicates?
-
How are child records selected when parent records are manually merged?
-
Can the response from the API Call Response can be formatted differently in the JSON output?
See all 178 topics