Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Incident Updatetime format in ConnectPHP — Cloud Customer Connect
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

Incident Updatetime format in ConnectPHP

Received Response
edited Jun 8, 2022 12:02PM in General Technical Discussions 2 comments



I am using ROQL query to get incident record. As per business requirement, I need to save incident updated time in separate text file (.txt) and when I try to upload all incidents which are updated since last 15 minutes with their customer entries only.  Here is the ROQL query

$incident_query = RNCPHP\ROQL::query( "SELECT ID,UpdatedTime,ReferenceNumber,Threads.EntryType.LookupName as seller_entry,
                                    StatusWithType.StatusType.LookupName as status,
                                    Threads.Text as Comment,Source.LookupName as Channel
                      FROM Incident I
                      WHERE UpdatedTime > '2015-08-21T10:11:29Z' AND Threads.EntryType.ID =  3
                      ORDER BY Threads.ID DESC" )->next();

Howdy, Stranger!

Log In

To view full details, sign in.


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