Generally in AOT sometimes we can not see tthe basenum values in properties so here is the query which helps
SELECT
EIT.NAME AS EnumName,
EVT.ENUMVALUE,
EVT.NAME AS EnumElement
FROM ENUMIDTABLE EIT
INNER JOIN ENUMVALUETABLE EVT
ON EVT.ENUMID = EIT.ID
WHERE EIT.NAME = 'YourBaseenum'
ORDER BY EVT.ENUMVALUE;
No comments:
Post a Comment