title: Range date time query on embedded list in OrientDB
body: <p>I have a structure like this in OrientDB, where each node is a particular user represented by user_id and all their purchase information are kept in the embedded list as shown below.</p>
  
  <pre><code>[
   {
    "user_id": 1,
    "purchase_info": [ {
                        "product_id": 100,
                        "timestamp": "2016-04-26  01:50:00"
                     }, 
  
                     {
                        "product_id": 200,
                        "timestamp": "2016-04-26  10:50:00"
                     }
  
                     ]
   },
  
   {
    "user_id": 2,
    "purchase_info": [ {
                        "product_id": 100,
                        "timestamp": "2016-04-26  10:50:00"
                     }, 
  
                     {
                        "product_id": 300,
                        "timestamp": "2016-04-26  20:50:00"
                     }
                     ]
   },
   {
    "user_id": 3,
    "purchase_info": [ {
                        "product_id": 100,
                        "timestamp": "2016-04-26  04:50:00"
                     }
                     ]
   },
   {
    "user_id": 4,
    "purchase_info": [ {
                        "product_id": 300,
                        "timestamp": "2016-04-26  05:50:00"
                     }
                     ]
   }
  ]
  </code></pre>
  
  <p><strong>Now I want to find the users who purchased products within a particular date time range.</strong> </p>
  
  <p>For example, if the date time range is between 2016-04-26  01:00:00 and 2016-04-26  04:55:00 the returning result will be user_id 1 and 3.</p>
  
  <p>I know that to query an embedded list we need to use <code>WHERE &lt;value&gt; IN &lt;key name&gt;</code>. However, I couldn't find a way to use a range using that format.</p>
  
  <p>Also for non-range query on timestamp it was not possible to use <code>asDateTime()</code>.</p>
  
  <p>For instance this query does not return anything:</p>
  
  <pre><code>SELECT from V where "2016-04-26 01:50:00" in purchase_info.timestamp.asDateTime()
  </code></pre>