Joyce Posted July 17, 2019 Share Posted July 17, 2019 Hi, I need to create a report for active, 'onhold' tickets, with the current 'onhold sub-status'. I have join Request table with h_buz_activities and h_sys_accounts ( As I also require customer account division which is recorded on customer profile). With the Buz activities table, as a ticket can be onhold multiple time, I am getting multiple details for one ticket. How can I filter to show distinct request ID details, with the last 'Onhold sub-status'? Thanks. Regards, Joyce Link to comment Share on other sites More sharing options...
Steve Giller Posted July 17, 2019 Share Posted July 17, 2019 The h_itsm_requests table stores the sub-status under h_sub_status. If that's all you need I don't think you need the h_buz_activities table to create this report. Link to comment Share on other sites More sharing options...
Joyce Posted July 18, 2019 Author Share Posted July 18, 2019 Hi Steve, Thank you for this. I saw the field as soon as i did this post. Regards, Joyce 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