Build a query including the "Created on"-column?

Question

Hi,

I am using the StorageService to store some data. I am now building a "Custom code" server-side Java tool to modify this data. I'd like to build a query that returns all entries that are older than 48h. How can I access the "Created On"-column using a query (i.e. what is the column-key)?

 

I'm basically missing "CREATED_ON_KEY":

Query q1 = QueryBuilder.build(GAME_STATE_KEY, 1, Operator.EQUALS);
Query q2 = QueryBuilder.build(CREATED_ON_KEY, now - 48h, Operator.LESS_THAN);
Query query = QueryBuilder.compoundOperator(q1, Operator.AND, q2);         

Thanks!

Nick

Answer 1

Hi ,

You can make query on createdOn by using  CREATED_ON_KEY as  "_$createdAt"  . You can use code snippet given below to make query on created on .

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

Query q2 = QueryBuilder.build("_$createdAt", "2014-05-14", Operator.LESS_THAN);

You can use these two queries for all entries that are older than 48h.

Thank you!

Comments

This works perfectly, thank you very much :-)!