Alisha Posted December 3, 2019 Share 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 Link to comment Share on other sites More sharing options...
Steve Giller Posted December 3, 2019 Share Posted December 3, 2019 @Alisha You should be able to use the h_sub_status column in the h_itsm_requests table. 1 Link to comment Share on other sites More sharing options...
Alisha Posted December 4, 2019 Author Share 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! Link to comment Share on other sites More sharing options...
Bob Dickinson Posted December 5, 2019 Share 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 Link to comment Share on other sites More sharing options...
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