How to access Label of List of Values from Named query
P
Pankajini MOHARANA
started a topic
about 1 year ago
Hi,
I have a Person Entity with few attributes defined as List of Values such as Gender, I am building a a named query for a consumer application and would like to understand if I can show both Code and Label of the List of value( M: Male, F:Female). Currently the named query output only shows the Code (by default).
Any ideas?
Best Answer
A
Alexia SIMOND
said
12 months ago
Hello Pankajini,
I think this was answered in a ticket, but let me put back the information here, so that it can benefit the rest of the community.
There is no native way to do so for now, but we have tracked this requirement internally.
If anyone is interested to follow this internal request and to be added as a related customer, feel free to open a ticket.
As a workaround, you can use SemQL to fetch the label using a function to transcode the codes into labels based on the data stored in the MTA_LOV_VAL table.
1 Comment
A
Alexia SIMOND
said
12 months ago
Answer
Hello Pankajini,
I think this was answered in a ticket, but let me put back the information here, so that it can benefit the rest of the community.
There is no native way to do so for now, but we have tracked this requirement internally.
If anyone is interested to follow this internal request and to be added as a related customer, feel free to open a ticket.
As a workaround, you can use SemQL to fetch the label using a function to transcode the codes into labels based on the data stored in the MTA_LOV_VAL table.
Pankajini MOHARANA
Hi,
I have a Person Entity with few attributes defined as List of Values such as Gender, I am building a a named query for a consumer application and would like to understand if I can show both Code and Label of the List of value( M: Male, F:Female). Currently the named query output only shows the Code (by default).
Any ideas?
Hello Pankajini,
I think this was answered in a ticket, but let me put back the information here, so that it can benefit the rest of the community.
There is no native way to do so for now, but we have tracked this requirement internally.
If anyone is interested to follow this internal request and to be added as a related customer, feel free to open a ticket.
As a workaround, you can use SemQL to fetch the label using a function to transcode the codes into labels based on the data stored in the MTA_LOV_VAL table.
Alexia SIMOND
Hello Pankajini,
I think this was answered in a ticket, but let me put back the information here, so that it can benefit the rest of the community.
There is no native way to do so for now, but we have tracked this requirement internally.
If anyone is interested to follow this internal request and to be added as a related customer, feel free to open a ticket.
As a workaround, you can use SemQL to fetch the label using a function to transcode the codes into labels based on the data stored in the MTA_LOV_VAL table.
-
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