Report on first and last email update on requests

[chriscorcoran]

@Victor thanks, I'm getting a SQL error but the syntax looks correct 

2531912019-02-06 10:47:28infogeneral8368Invocations (7f47861a-3c9c-4b36-b019-6e54b63e83ad): system/getLogFileRecords

2531902019-02-06 10:47:28errorperf2300

( SELECT sub_b.h_id FROM h_buz_activities sub_b LEFT JOIN h_msg_messages m ON m.h_msg_id = JSON_VALUE(sub_b.h_extra, '$._emailId') WHERE sub_b.h_target = s.h_id AND sub_b.h_type = 'Email' AND m.h_msg_to = 'support@resonate.tech' ORDER BY m.h_msg_date > '2018-01-01 00:00:00' )

 

[Victor]

@chriscorcoran this is how the msg_date needs to be added:

[Steve G]

  Hi @chriscorcoran,

As @Victor has mentioned, this will only return timeline updates against requests where the email was sent/received after that date/time stamp. Not sure how useful that would be though? Are you actually after requests that have been logged after that date/time stamp? If so then a filter configured as below, using the Start Of Last Year variable in the value, would work:

Cheers,

Steve

[chriscorcoran]

@Victor @Steve G Yes so the report you have given me is fine with email updates first and last. As you say I just want tickets logged form 01/01/2018 so I should use what you suggested? As the report you kindly did brings back everything.

 

[Steve G]

@chriscorcoran In that case, apply the filter as per my last comment, and that'll get you the data you need  

Cheers,

Steve

[chriscorcoran]

@Steve Gspot on thanks! @Victor thanks as well. That has been a big help publishing to my power bi report now.