We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL to fetch incident created between specific time

Accepted answer
8
Views
4
Comments
edited Feb 27, 2017 7:54AM in Integrations and APIs 4 comments

Content

Hi all,
How can i get all the incidents created between a particular time using Roql
example start Time 22-Feb-2017 :00:00 and end time 22-Feb-2017 :24:00
I tried the below query and i am not getting the response as expected 

SELECT * FROM Incident WHERE Incident.FileAttachments.FileAttachmentList.FileName IS NOT NULL AND CreatedTime >= '2017-02-22T00:00:00Z' AND CreatedTime <= '2017-02-22T24:00:00Z'

Thanks
Tony

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!