Home Service Manager

ServiceOfferingCategory

Roman_NepomniashchiiRoman_Nepomniashchii Customer IT Monkey ✭
edited September 2018 in Service Manager
Hi, Team! I have ID service offering category, who know in what table in DB ServiceManager are  communication name category and her ID???

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    edited September 2018
    @Roman_Nepomniashchii - with enumerations(lists), you have to join the Display String with the Enumeration table.  It usually looks something like this:
    DECLARE @MyLanguage varchar(3)
    SET @MyLanguage = 'ENU'
    SELECT  [EnumTypeId]     
          ,[EnumTypeName]
      ,ds.DisplayName AS 'ListValue'
          ,[Ordinal]
      ,pds.DisplayName AS 'ParentList'
      FROM [ServiceManager].[dbo].[EnumType] e

      INNER JOIN DisplayStringView ds
      on ds.LTStringId = e.EnumTypeId
      and ds.LanguageCode = @MyLanguage

      INNER JOIN DisplayStringView pds
      on pds.LTStringId = e.ParentEnumTypeId
      and pds.LanguageCode = @MyLanguage

      WHERE e.ParentEnumTypeId = '93A5CEFA-CA02-BC2A-5C52-AD4C29267CAC'
Sign In or Register to comment.