How do I query for the date a document is created

Question

I have documents stored using the storage service. Is it possible to create a query to retrieve records created on a particular date since the storage service always appends a createdAt attribute? How do we reference this attribute/key in a query? I have tried "createdAt", "_$createdAt" , "Created On" with no luck.

Comments

Hello James,

Could you please tell us that in which platform and SDK version you are working on?
Thanks.

---

I am using Java SDK

Answer 1

Hi,

 

You can make a query on ceatedOn by using CREATED_ON_KEY as "_$createdAt" .For this you need to follow the code snippet given below :-

 

Query q1 = QueryBuilder.build("_$createdAt", "2014-05-15", Operator.GREATER_THAN);

 

And if you are using the latest version of our java sdk then you can use the method setCreatedOn for searching document based upon createdOn. For this you need to follow the code snippet given below :-

 

Query q1 = QueryBuilder.setCreatedOn("2014-10-10", Operator.GREATER_THAN_EQUALTO);

 

Please let us know if this helps.

Comments

I have tried the first one and still did not get it to work. I may need to upgrade my SDK to use the setCreatedOn/

---

can you please share the query that you are applying and put App42Log.setDebug(true) in your code and send us the logs to assist your issue better.

---

Here is the result. I also upgraded to 2.4.1 java SDK.
Setting value :jsonQuery : [{"value":"2014-10-17T16:54:26.820Z","operator":"$lte","key":"_$createdAt"}]
 QueryString is ?jsonQuery=%5B%7B%22value%22%3A%222014-10-17T16%3A54%3A26.820Z%22%2C%22operator%22%3A%22%24lte%22%2C%22key%22%3A%22_%24createdAt%22%7D%5D&
 Requested URL is https://api.shephertz.com/cloud/1.0/storage/findDocsByQuery/dbName/ZC1/collectionName/Accident/0/100?jsonQuery=%5B%7B%22value%22%3A%222014-10-17T16%3A54%3A26.820Z%22%2C%22operator%22%3A%22%24lte%22%2C%22key%22%3A%22_%24createdAt%22%7D%5D&
 Setting Header value : signature : p58y71FuQplQD8iWKxhO9WJtKPE%3D
 Setting Header value : version : 1.0
 Setting Header value : SDKName : Java
 Setting Header value : timeStamp : 2014-10-17T16:54:26.823Z
 Setting Header value : apiKey : 4d1dbd8dbbeee0b9f10e654b426686ecabb6ec09206fc18d6d05b22880919c44
No Record Found {"app42Fault":{"httpErrorCode":404,"appErrorCode":2608,"message":"Not Found","details":"No document in the collection 'Accident' exists for given query"}}

---

Hi ,
By seeing your logs we had seen that  you are using findDocumentsByQueryWithPaging method and passing your max value as 0 and offset as 100. Please put value of max to greater than 0 and you should be able to fetch the result. please refer to this link (http://api.shephertz.com/app42-docs/nosql-storage-service/#find-document-by-query-paging ) for further info.