Alisha Posted December 3, 2019 Posted December 3, 2019 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 Posted December 3, 2019 Posted December 3, 2019 @Alisha You should be able to use the h_sub_status column in the h_itsm_requests table. 1
Alisha Posted December 4, 2019 Author Posted December 4, 2019 @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 Posted December 5, 2019 Posted December 5, 2019 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 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now