jpeterson/arcgis-filter

ArcGIS Filter

arcgis-filter's Issues

Support relative date filters

Support filters like the following:

startDate is in the last 1 day

startDate BETWEEN CURRENT_TIMESTAMP - 1 AND CURRENT_TIMESTAMP

Support IN statements

Support filters like the following:

First Name is one of the following: Josh, Jake, Joe.

FirstName IN ('Josh', 'Jake', 'Joe')

Allow filter to be pre-populated via props

In order to support a workflow where users persist their filter outside of this component and need to be able to reopen the component with the same filter options applied, it needs to support a prop that can hydrate all the various components.

Support nested Sets

Sets are only supported one level deep. More complex queries would be possible if it were possible to nest sets within sets.

Support BETWEEN date filters

Support filters like the following:

startDate is between 5/15/18 and 5/20/18

ContainmentDateTime BETWEEN '2018-05-15 06:00:00' AND '2018-05-21 05:59:59'

Dates are initially "Invalid Date"

When first picking a date field, the sql string reports the date as "Invalid Date" - it should instead default to the same as the default date in the form control.

moment dependency?

@jpeterson how is this moment dependency possible if it isn't part of the listed package.json dependencies? I see that date-fns is used elsewhere throughout the source code. I can change this to date-fns while I am making other enhancements for relative date pickers.

https://github.com/jpeterson/arcgis-filter/blob/master/src/ArcgisFilter/components/ValueInput.js#L2

Layout with calcite-react

Implement a layout using calcite-react

Support "unique values"

Support displaying unique values for non-domain fields.

ValueTypeChooser has already been started for this purpose, but isn't fully implemented.

props.selectedValueType can be supplied as 'value' or 'unique' to change the value input being displayed.

Screenshot from ArcGIS Online

Sample query to get unique values (with count for each, for ordering):

https://services1.arcgis.com/BteRGjYsGtVEXzaX/arcgis/rest/services/LA_Bay_2017/FeatureServer/0/query?f=json&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&groupByFieldsForStatistics=lat&outStatistics=%5B%7B%22statisticType%22%3A%22count%22%2C%22onStatisticField%22%3A%22lat%22%2C%22outStatisticFieldName%22%3A%22countOFlat%22%7D%5D&outSR=102100