Custom Fields DB location

[Kelvin]

Sorry for posting this as I am sure it has been asked before however I cant find it.

Where are the custom fields (from the details tab on a request) stored in the DB.

[Martyn Houghton]

@Kelvin

The table used is dependent on the request type and is linked back by foreign key h_fk_reference.

Incidents - h_itsm_incidents

Service Request - h_itsm_servicerequests

Problems - h_itsm_problems

Change Requests - h_itsm_changerequests

 

Cheers

Martyn

[Kelvin]

@Martyn Houghton Great thank you

[Kelvin]

Next question would be do you know if you can update a custom field through a BPM Automated task

[samwoo]

10 minutes ago, Kelvin said:

Next question would be do you know if you can update a custom field through a BPM Automated task

As far as I know it cannot be done via BPM (yet). It has been raised a few times in the past so probably on the list of things for Hornbill to look at.

You can however update custom fields via the Progressive Capture  - Custom Forms (if this helps in any way). Open the wiki:
https://wiki.hornbill.com/index.php/Progressive_Capture_Workflow

Scroll down to where it says Mapping Fields from Customised Forms and click Read More next to it

Thanks,

Samuel

[Kelvin]

@samwooThank you