How the portal populate custom field data for workitem ?

Ben_TeyBen_Tey Premier Partner IT Monkey ✭
Checked the dbo.workitem and can't find any custom field data are stored in this table. Wondering which table does it store the data or Portal will direct query the custom field data from SCSM DB ?

Please enlighten me as i need the custom field to further customize the Change Calendar. 

Tagged:

Comments

  • Konstantin_Slavin-BoKonstantin_Slavin-Bo Customer Advanced IT Monkey ✭✭✭
    Custom classes are stored in their own tables in the ServiceManager DB as [dbo].[MT_YOUR$CLASS$NAME], where you also find the custom fields you have created. As the portal does not show custom fields OotB, I don't think they're stored anywhere in the ServiceManagement DB.
  • Geoff_RossGeoff_Ross Cireson Consultant Super IT Monkey ✭✭✭✭✭
    Indeed, these are not cached into the ServiceManagement DB. You will have to join your SQL query to tables in this DB. As above, they will be in a table of the class extension name or all extensions of a class are available from a view with the name of the base class.

    EG

    SELECT WorkItemId, Extended.CustomField1_75DF0BE8_3446_F616_6AC0_8510B74838AF
    FROM WorkItem
    JOIN ServiceManager.dbo.MTV_System$WorkItem$Incident Extended
    ON WorkItem.Id = Extended.BaseManagedEntityId
Sign In or Register to comment.