import { Where } from "https://deno.land/x/rdw_data@0.7.0/src/providers/mod.ts";
Static Methods
between(): Where
field: ,
| string
| FieldObject<DataType.Number>
| FieldObject<DataType.FloatingTimestamp>
| FieldObject<DataType.FixedTimestamp>
| FieldObject<DataType.Text>
startValue: any,
endValue: any,
Select records where the value of a field is between two values
Works with the following datatypes:
- Number
- Floating timestamp
- Fixed timestamp
- Text
field(name: string | FieldImpl)
intersects(field: , value: string): Where
| string
| FieldObject<DataType.Point>
| FieldObject<DataType.Polygon>
| FieldObject<DataType.Line>
| FieldObject<DataType.MultiPoint>
| FieldObject<DataType.MultiLine>
| FieldObject<DataType.MultiPolygon>
Allows you to compare two geospatial types to see if they intersect or overlap each other
Note: This function is only available on the 2.1 endpoint
notBetween(): Where
field: ,
| string
| FieldObject<DataType.Number>
| FieldObject<DataType.FloatingTimestamp>
| FieldObject<DataType.FixedTimestamp>
| FieldObject<DataType.Text>
startValue: any,
endValue: any,
startsWith(field: string | FieldObject<DataType.Text>, value: string): Where
This function is used on fields of type Text
to find records that start with a given string
withinBox(): Where
field: string | FieldObject<DataType.Location>,
latNW: number,
lonNW: number,
latSE: number,
lonSE: number,
This function is used on fields of type Location
to find records within a given box. This takes the form of a rectangle, with the northwest corner and southeast corner specified by latitude and longitude.
withinCircle(): Where
field: string | FieldObject<DataType.Location>,
lat: number,
lon: number,
radius: number,
This function is used on fields of type Location
to find records within a given circle