I am saving records with datetime stamp in aerospike in the format :
2015-03-31T11:24:22Z. I want to filter records based on requests like 4h, 1d etc. If I receive request for last 4h and suppose current date is 31 March 2015 and time is 11:24, then I need to filter records in a range from
2015-03-31T11:24:22Z. How is it possible through Aerospike filter? I know about filter range in NodeJS client i.e:
aerospike.filter.range but I am not clear how to perfectly use it for my purpose. I had tried the following:
I made a secondary key on datetime bin and tried the following query
select * from test.myRecords where dateOfRecords between 2015-03-31T07:24:22Z and 2015-03-31T11:24:22Z I know it is not sensible but I want something in a way that not disturbed current format of datetime stamp and I fulfill my purpose with the same format.
2.Tried to save datetime stamp by giving as int and the query as suggested in How to store/retrieve date in Aerospike database?
Kindly help me, solution with NodeJS client will be highly appreciated but other solutions and suggestions are also welcomed. If aerospike is listening only one specific datetime stamp format so kindly inform me and working examples will be greatly helpful for me.