How the portal populate custom field data for workitem ?

Ben_Tey

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. 

Konstantin_Slavin-Bo

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_Ross

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