Martyn Houghton Posted August 1, 2018 Share Posted August 1, 2018 I have been tasked with reporting on the number of types of updates on certain requests, so need to report on the timeline entries for certain request and break them down by Type and Source. Can some one point me in the right direction of the table name. I thought something like activity stream but not been able to pin it down yet. Cheers Martyn Link to comment Share on other sites More sharing options...
TrevorKillick Posted August 1, 2018 Share Posted August 1, 2018 @Martyn Houghton The table is h_buz_activities and you can join on h_target where its equal to the activity stream id stored against the request, h_itsm_requests.h_activity_stream_id. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Martyn Houghton Posted August 1, 2018 Author Share Posted August 1, 2018 @TrevorKillick Thanks for the quick response. I can see 'Type of activity' and 'Activity visibility', but is there a way to determine which are email sent from the request and those which are 'Applied to the Request'? Cheers Martyn Link to comment Share on other sites More sharing options...
TrevorKillick Posted August 1, 2018 Share Posted August 1, 2018 @Martyn Houghton Yes h_type = 'Email' should give you any emails applied to a request, your right there is no distinction between in and outbound email, I have raised the requestion with our development team to see if they have any ideas. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
TrevorKillick Posted August 1, 2018 Share Posted August 1, 2018 @Martyn Houghton The team have advised that the following while not very efficient would give you emails sent from a request: h_content LIKE 'Email To: %' Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Martyn Houghton Posted August 1, 2018 Author Share Posted August 1, 2018 @TrevorKillick Thanks, we sort got there at the same time, with the addition of 'An email has been sent to' for email sent by the BPM. Cheers Martyn 1 Link to comment Share on other sites More sharing options...
Martyn Houghton Posted August 1, 2018 Author Share Posted August 1, 2018 @TrevorKillick I am trying to work out the different values of 'activity_visibility' in the h_buz_activities. We have 1,10,30. I am presuming that 10 is Customer and 30 is Team, but I am not sure what 1 is. Cheers Martyn Link to comment Share on other sites More sharing options...
TrevorKillick Posted August 1, 2018 Share Posted August 1, 2018 @Martyn Houghton Visibility levels are described here: https://api.hornbill.com/_types/activityVisibilityType Kind Regards Trevor Killick 1 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