Use queries with relative dates

tomschenkjr commented 8 years ago

Especially for saved queries, it's helpful for users to be able to type-in relative dates (e.g., today, yesterday, last week) in queries. Thus, can save queries using time-spans that are not "baked-in" and require constant updating.

PriyaDoIT commented 8 years ago

Similar to WG issue #60106

PriyaDoIT commented 8 years ago

Reopennig this issue--since this code was not deployed to chicago.opengrid.io

tomschenkjr commented 8 years ago

It seemed to work for me in testing. Which queries didn't work for you?

On Thu, Jul 21, 2016 at 9:39 AM -0500, "PriyaDoIT" notifications@github.com<mailto:notifications@github.com> wrote:

Reopennig this issue--since this code was not deployed to chicago.opengrid.io

You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Chicago/opengrid/issues/147#issuecomment-234274475, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABkC0ZPTeY6XpQ_S6PEEvhKIQYDpv7c0ks5qX4SvgaJpZM4HRCvi.

This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.

PriyaDoIT commented 8 years ago

Yes, I saw that it works working during testing too. However, this didn’t make it to live (see image).

tomschenkjr commented 8 years ago

I think something else is happening. The code is there, but being misapplied. That is, the date filter is not being correctly interpreted and applied to the query.

Otherwise, a syntax error would appear because OG would not know how to interpreted the command "2 weeks ago"

On Thu, Jul 21, 2016 at 9:47 AM -0500, "PriyaDoIT" notifications@github.com<mailto:notifications@github.com> wrote:

Yes, I saw that it works working during testing too. However, this didn't make it to live (see image). [cid:image001.png@01D1E334.DBCE9B10]

From: Tom Schenk Jr [mailto:notifications@github.com] Sent: Thursday, July 21, 2016 9:43 AM To: Chicago/opengrid Cc: Shah, Priya; State change Subject: Re: [Chicago/opengrid] Use queries with relative dates (#147)

It seemed to work for me in testing. Which queries didn't work for you?

_ Tom Schenk Jr. Chief Data Officer Department of Innovation and Technology City of Chicago (312) 744-2770 tom.schenk@cityofchicago.orgmailto:tom.schenk@cityofchicago.org | @ChicagoCDO data.cityofchicago.org | opengrid.io | digital.cityofchicago.org | chicago.github.io | dev.cityofchicago.org

On Thu, Jul 21, 2016 at 9:39 AM -0500, "PriyaDoIT" notifications@github.com<mailto:notifications@github.com<mailto:notifications@github.com%3cmailto:notifications@github.com>> wrote:

Reopennig this issue--since this code was not deployed to chicago.opengrid.io

You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Chicago/opengrid/issues/147#issuecomment-234274475, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABkC0ZPTeY6XpQ_S6PEEvhKIQYDpv7c0ks5qX4SvgaJpZM4HRCvi.

This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.

You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/Chicago/opengrid/issues/147#issuecomment-234275347, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ARnU4Y_CPh7T13oFT7wXbvPEKpM4aupnks5qX4VagaJpZM4HRCvi.

This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.

You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/Chicago/opengrid/issues/147#issuecomment-234276970, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ABkC0cPpf1YQG9PzwTuC0Ki2TXRCQX6jks5qX4aBgaJpZM4HRCvi.

This e-mail, and any attachments thereto, is intended only for use by the addressee(s) named herein and may contain legally privileged and/or confidential information. If you are not the intended recipient of this e-mail (or the person responsible for delivering this document to the intended recipient), you are hereby notified that any dissemination, distribution, printing or copying of this e-mail, and any attachment thereto, is strictly prohibited. If you have received this e-mail in error, please respond to the individual sending the message, and permanently delete the original and any copy of any e-mail and printout thereof.

PriyaDoIT commented 8 years ago

This will be handled in #226 . Closing issue

Chicago / opengrid

Use queries with relative dates #147