title: CakePHP URL - specify a named filed as "null"
body: <p>I am working on an app that connects to a 3rd party CakePHP API system.
  Here is a sample output of the url:</p>
  
  <pre><code>https://&lt;server&gt;/api/events.json
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>{"events":[{"Event":{"Id":"11902","MonitorId":"5","Name":"New Event","Cause":"Continuous","StartTime":"2016-08-15 17:10:00","EndTime":null,"Width":"2304","Height":"1296","Length":"319.81","Frames":"1600","AlarmFrames":"0","TotScore":"0","AvgScore":"0","MaxScore":"0","Archived":"0","Videoed":"0","Uploaded":"0","Emailed":"0","Messaged":"0","Executed":"0","Notes":""},"thumbData":""},{"Event":{"Id":"11903","MonitorId":"7","Name":"New Event","Cause":"Continuous","StartTime":"2016-08-15 17:10:00","EndTime":"2016-08-15 17:11:00" ,"Width":"1280","Height":"720","Length":"316.73","Frames":"1900","AlarmFrames":"0","TotScore":"0","AvgScore":"0","MaxScore":"0","Archived":"0","Videoed":"0","Uploaded":"0","Emailed":"0","Messaged":"0","Executed":"0","Notes":""},"thumbData":""}
  </code></pre>
  
  <p>Note that in some cases, <code>EndTime</code> field is null and in some cases it is not. I now want to craft a URL that only returns fields where EndTime is null.</p>
  
  <p>The API allows for named filters. For example:</p>
  
  <p><code>https://&lt;server&gt;/api/events/index/EndTime &gt;=: 2016-11-07 10:10:10.json</code></p>
  
  <p>Accurately returns all values with EndTime > the value specified.</p>
  
  <p>How does one ask for EndTime = null?</p>
  
  <p>I tried:</p>
  
  <p><code>https://&lt;server&gt;/api/events/index/EndTime =: null.json</code></p>
  
  <p>That doesn't work (also tried with quotes)</p>
  
  <p>thanks</p>