Databases
StackOverflow2013
Postsdbo
POEvent search returns event outside date range
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEvent search returns event outside date range
    text
    copied!<p>I have been noticing that sometimes the response to an event search returns an event that is outside of the date range in the que3. Here is an example (with my key removed):</p> <p><a href="http://www.eventbrite.com/json/event_search?app_key=mykey&amp;keywords=Photography&amp;max=10&amp;latitude=34.19751&amp;longitude=-119.1771&amp;within=50&amp;within_unit=K&amp;date=2012-07-20%202012-07-22" rel="nofollow">http://www.eventbrite.com/json/event_search?app_key=mykey&amp;keywords=Photography&amp;max=10&amp;latitude=34.19751&amp;longitude=-119.1771&amp;within=50&amp;within_unit=K&amp;date=2012-07-20%202012-07-22</a></p> <p>Here are the parameters, one per line:</p> <pre><code>http://www.eventbrite.com/json/event_search ?app_key=mykey &amp;keywords=Photography &amp;max=10 &amp;latitude=34.19751 &amp;longitude=-119.1771 &amp;within=50 &amp;within_unit=K &amp;date=2012-07-20%202012-07-22 </code></pre> <p>If I run this query, I get 3 events, one of which looks like this (with some items shortened for brevity):</p> <pre><code> "event": { "box_header_text_color": "005580", "link_color": "EE6600", "box_background_color": "FFFFFF", "timezone": "US/Pacific", "box_border_color": "D5D5D3", "logo": "http://...", "organizer": { "url": "http://..., "id": 1066754373, "name": "Red Brick Gallery" }, "background_color": "FFFFFF", "id": 2667310999, "category": "seminars,entertainment", "box_header_background_color": "EFEFEF", "capacity": 8, "num_attendee_rows": 9, "title": "Copy of Watercolor Workshops with Joe Cibere", "start_date": "2011-07-23 14:00:00", "status": "Started", "description": "...", "end_date": "2012-06-16 17:00:00", "tags": "...", "text_color": "005580", "repeat_schedule": "custom-2659333", "title_text_color": "", ... </code></pre> <p>I use the keys (under "event") "start_date" and "end_date" to identify the event dates, which spans from 2011-07-23 to 2012-06-16.</p> <p>The query spans from 2012-07-20 to 2012-07-22.</p> <p>The date span of the event and the date span of the query don't overlap.</p> <p>Am I doing something wrong with my query, or is the response incorrect?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload