Saturday, December 10, 2022

SQL Syntax to find enum values of extended enum

 SELECT ev.NAME,ev.ENUMVALUE

  FROM ENUMIDTABLE ei

  INNER JOIN ENUMVALUETABLE ev

    ON ev.ENUMID = ei.ID

  WHERE ei.NAME = 'ProjTransStatus'

  ORDER BY ev.ENUMVALUE


No comments:

Post a Comment

Build Explained

Useful Blogs. https://axtechsolutions.blogspot.com/2018/08/performing-builds-in-d365.html https://community.dynamics.com/blogs/post/?postid=...