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

0 votes


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 =, 1, Operator.EQUALS);
Query q2 =, now - 48h, Operator.LESS_THAN);
Query query = QueryBuilder.compoundOperator(q1, Operator.AND, q2);         

asked May 13, 2014 in App42PaaS & BPaaS by support (29 points)
edited May 13, 2014 by support

1 Answer

+1 vote
Best answer

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 ="_$createdAt", "2014-05-12", Operator.GREATER_THAN);

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

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

Thank you!

answered May 14, 2014 by SACHIN25 (190 points)
selected May 14, 2014 by support
This works perfectly, thank you very much :-)!
Download Widgets
Welcome to ShepHertz Product line forum, where you can ask questions and receive answers from the community. You can also reach out to us on