How to access Label of List of Values from Named query
P
Pankajini MOHARANA
started a topic
11 months 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
10 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
10 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.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 346 topics