How to set a defintionExpression in JS

HeathAnderson

I am struggling getting my definition expression to work with a time aware field.  I believe I have narrowed down the problem to the layer.definitionExpression.  I have successfully made a definition expression for a text field:

layer.definitionExpression = "project_type = 'SUP'"

but I have been unsuccessful in writing one for a time aware field.  Should I be using the field name {project_date} or 'time'?

timeSlider<SPAN class="punctuation token">.</SPAN><SPAN class="token function">watch</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"timeExtent"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
          <SPAN class="comment token">// only show earthquakes happened up until the end of</SPAN>
          <SPAN class="comment token">// timeSlider's current time extent.</SPAN>
          <SPAN class="comment token">//defExp = layer.definitionExpression = "time = " + timeSlider.timeExtent.end.getTime();</SPAN>
          <SPAN class="comment token">//defExp = layer.definitionExpression = "project_type = 'SUP'";</SPAN>
          <SPAN class="comment token">//defExp = layer.definitionExpression = "time=1571202000000";</SPAN>
          defExp <SPAN class="operator token">=</SPAN> layer<SPAN class="punctuation token">.</SPAN>definitionExpression <SPAN class="operator token">=</SPAN> <SPAN class="string token">"time="</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">1571202000000</SPAN><SPAN class="punctuation token">;</SPAN>
          defExp2 <SPAN class="operator token">=</SPAN> layer<SPAN class="punctuation token">.</SPAN>definitionExpression <SPAN class="operator token">=</SPAN> <SPAN class="string token">"project_date="</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">1571202000000</SPAN><SPAN class="punctuation token">;</SPAN>
          <SPAN class="comment token">//checks definitonExpression </SPAN>
          console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>defExp<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
          console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>defExp2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I know that the epoch time 1571202000000 exists in my dataset because I can query it in the rest end point and the query yields 2 results, however that doesn't seem directly translate to JS.  Can some one please help me.

UndralBatsukh

Hi there, 

As Robert Scheitlin, GISP‌, you should use standard sql query to query dates. When you are setting FeatureLayer.definitionExpression you are making Rest API query call (search for where).  This blog talks about how to query date fields.  

With all of the above said, you should not have to set the layer's definitionExpression whenever the timeSlider's timeExtent changes. You can set the TimeSlider.view property and all time-aware layers will automatically update to conform to the view's timeExtent. Please look through the TimeSlider SDK doc (see Update the view's doc section).

I have updated your app to do that and here is the link. I noticed that your service's time interval units is set to unknown. So in the test app, I am setting TimeSlider's stop.interval to one day as shown below:

<SPAN class="keyword token">const</SPAN> timeSlider <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">TimeSlider</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">{</SPAN>
  container<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"timeSlider"</SPAN><SPAN class="punctuation token">,</SPAN>
    playRate<SPAN class="punctuation token">:</SPAN> <SPAN class="number token">300</SPAN><SPAN class="punctuation token">,</SPAN>
    view<SPAN class="punctuation token">:</SPAN> view<SPAN class="punctuation token">,</SPAN>
    stops<SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
      interval<SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
        value<SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>
        unit<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"days"</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>