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 query - issue

Received Response
14
Views
1
Comments
edited Oct 5, 2017 1:50PM in Integrations and APIs 1 comment

Content

Hi All,

i want to pull id of last **** reservation records of a custom reservation object that i created. The code i am using is custom process model to pull last 6 records.

$maxbookingtime = RNCPHP\ROQL::query("select id  from CO.Reservation order by BookingTime desc limit 6;" )->next();

   $maxbookingtimeRes =$maxbookingtime->next();
 
The above query returns only one id and how i can modify the query to get last 6 values.

Version

Service cloud

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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