Select next record data to current record data

[Pugazharasan Thirumalai]

If i execute the query, "select from custom_offer" then am getting the out like this,

PROPERTIES
rid	class	version	offer_text	offer_code	created_date
#265:2869	custom_offer	5	Promotional Offer	BFXVI3EY	2017-01-25 00:00:00
#265:2871	custom_offer	5	test	L81KSPBZ	2017-03-22 00:00:00
#265:2870	custom_offer	5	test		2017-04-12 00:00:00
#265:2868	custom_offer	5	Test	JHZZTNO4	2017-05-25 00:00:00

From the above result,

   Consider as 'created_date' as my offer start date,

   and we want the query for offer end date ie next record created_date is my offer end date of my first record.

For example,

   #265:2869 record offer Start date is 2017-01-25 00:00:00 and end date should be 2017-03-22 00:00:00.

So i want the query for getting next record value to first record data by select query.

Thanks and Regards,

T.Pugazharasan.

[Ivan Mainetti]

so, just to clarify, you want something like this?

[Ivan Mainetti]

you will need a javascript function (screenshots attached):

----

Ivan

[Pugazharasan Thirumalai]

Hai Ivan,

      As you mentioned above first of all we have to write java script code, their i have run the query "select from custom_offer" after that we have to write some logic and the again we have to sun the query "select *,next_offer(@this.@rid).created_date as end_date from custom_offer".

    We are having thousands of data if we run  like that performance  will affect, But output what you got is correct. Kindly give query on single select query. 

[Ivan Mainetti]

I'm sorry, I understand that this method lacks in performance, but I'm afraid it's the only way. You can't do it with a single select query.