Third party widget

[Alisha]

Hello,

I'd like to create a widget that displays how many requests we have with the sub-status 'Third Party'. Which table holds the sub-status information please?

Many thanks,
Alisha

[Steve Giller]

@Alisha You should be able to use the h_sub_status column in the h_itsm_requests table.

[Alisha]

@Steve Giller Thank you. Sorry, I couldn't find it on https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table so thought it wasn't on that table and didn't think to check the same table on the Entity Viewer!
 

[Bob Dickinson]

Hi @Alisha

I've just noticed this wiki page doesn't contain a number of our newer attributes. I have added Sub Status, and will have a run through to see if there are any other common ones that are missing. Thanks for bringing this to our attention. 

Kind Regards

Bob