You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi Guys,
Just looking at the code for the first time! It looks great, easy to read and understand.
I did notice what looks like a bug in the crime_activity_intent. I'm not 100% sure but I don't think the "latest" crimes are being returned by the app.
I think adding an ORDER BY to the SQL query on crime_incidents_api_utils.py line 48 will fix this.
'''SELECT * FROM "{}" WHERE "Lat" LIKE '{}%' AND "Long" LIKE '{}%' ORDER BY "OCCURRED_ON_DATE" DESC LIMIT {}'''
The text was updated successfully, but these errors were encountered:
dphiggs01
changed the title
Order if returned Crimes
Order of returned Crimes on crime_activity_intent
Feb 7, 2020
Hi Guys,
Just looking at the code for the first time! It looks great, easy to read and understand.
I did notice what looks like a bug in the
crime_activity_intent
. I'm not 100% sure but I don't think the "latest" crimes are being returned by the app.I think adding an ORDER BY to the SQL query on crime_incidents_api_utils.py line 48 will fix this.
The text was updated successfully, but these errors were encountered: