I am currently working on a project in which I use a Graphql query to gather some incident data. The query for the incident table works just fine, but some of the fields are values that can only be enumerated in another table called sys_choice_list. Is there any way in a single gql query to hit the incident table and enumerate a value that is known to be in the sys_choice_list table or is the better approach to pull the data from each table separately?
As an example, my gql query for incident has an impact value of 1-4, which in the sys_choice_list table map to High, Medium, Low, etc. I am trying to see if when i query an incident via GQL that the values show as High/Med/Low instead of 1/2/3/4.
Any help would be appreciated. Thanks in advance.
