1 Reply Latest reply on Aug 8, 2019 11:40 AM by Christian Smerz

    Where do I look for Reference Relationships in the Remedy Database?

    Joshua White
      Share This:

      I'm quite the novice regarding SQL and am still gaining knowledge.  The current issue i'm seeking help with is in querying the RemedyDB for Incident Work Info entries. I'm searching against this view:

       

      [ARSystem].[dbo].[HPD_WorkLog]

       

      But i'm trying to restrict my query based on specific 'Work_Info_Type' values.  Where is the information stored in the Database that translates these numerical values in this view to the string values that are commonly displayed to the user?  And more generally, how would i find this information for other columns that i encounter like this one in other RemedyDB Views? (i.e. 'Communication_Source', etc)

       

      Thank you in advance for any assistance you can provide, or documentation/knowledge resources you can point me towards.