af query - cases with emails createdon > 15 mins after case createdon?

All replies

• 

  

  0

  Sign in to vote

  Hi,

  Create a workflow on creation of Case. Put a wait condition of 15 minutes and then update a temp hidden field on the form. On update of that temp field you can fire your AF query in the plugin.

  I hope it helps.

  ---

  Anubhav Bajpai

  Thursday, August 1, 2013 9:08 AM
• 

  

  0

  Sign in to vote

  @anubhav - This needs to be implemented as an AF query on existing data, without any code changes

  Thursday, August 1, 2013 9:10 AM
• 

  

  0

  Sign in to vote

  Or I could also support the business requirement by returning a list of cases having associated emails created > 15 minutes after the creation of the contact who the email is from.  This might be easier to do?

  Thursday, August 1, 2013 9:24 AM
• 

  

  0

  Sign in to vote

  Another option for my scenario would be to return all cases with emails having createdon > 15mins than the min email createdon for the case. Is this possible?

  Thursday, August 1, 2013 10:51 AM
• 

  

  0

  Sign in to vote

  You can meet your requirement by:-

  1. Create a custom report.

  2. First mark all emails created within 15 minutes after the creation of case. Add a bit field on email and set it to true if the email is created within 15 minutes of case creation using a workflow on create of email. First check that email is inbound. Than you will be able to find these emails using advanced find.

  3. Create a web service to run and find out all the require emails.

  I think option 2 don't require any coding.

  ---

  Regards Faisal

  Thursday, August 1, 2013 11:54 AM