topic Re: Is it possible to apply a spatial filter AND a where clause against a Feature Layer? in ArcGIS JavaScript Maps SDK Questions

Is it possible to apply a spatial filter AND a where clause against a Feature Layer?

LeeTaEthni — Wed, 22 Jun 2022 18:27:29 GMT

I get type errors if I put in anything other than '1=1' in the where clause when using geometry input on a query. Is it supported to do both a SQL filter and spatial filter on a Feature Layer query?

Re: Is it possible to apply a spatial filter AND a where clause against a Feature Layer?

KenBuja — Wed, 22 Jun 2022 21:00:19 GMT

Can you post your code?

Re: Is it possible to apply a spatial filter AND a where clause against a Feature Layer?

LeeTaEthni — Thu, 23 Jun 2022 16:12:59 GMT

public query(value: string, point?: { latitude: number; longitude: number }): Observable<PeopleInCountry[]> {
value = value.toLowerCase();
const query = {
outFields: ['PEID', 'NmDisp', 'GENC0'],
orderByFields: ['NmDisp'],
where: `status=1`,
geometry: {
type: 'point',
latitude: point!.latitude,
longitude: point!.longitude,
} as any,
} as any;
if (value) {
query.where = `LOWER(NmDisp) LIKE '%${value}%' OR LOWER(PEID) LIKE '%${value}%' AND status = 1`;
}
return new Observable((observer) => {
this.featureLayer
.queryFeatures(query)
.then((result) => {
observer.next(result);
observer.complete();
})
.catch((e) => {
observer.error(e);
observer.complete();
});
});
}

Re: Is it possible to apply a spatial filter AND a where clause against a Feature Layer?

KenBuja — Thu, 23 Jun 2022 16:48:21 GMT

When you're working with TypeScript, you can't use autocasting.

Due to limitations in TypeScript, autocasting works best in non-TypeScript applications. Autocasting casts JavaScript objects as ArcGIS API for JavaScript class types without the need for these classes to be explicitly imported. No changes are required if you are already using the API without any TypeScript build errors.

You won't be able to use

geometry: { type: 'point', latitude: point!.latitude, longitude: point!.longitude, } as any,

but have to create a new Point and use that in the geometry property

geometry: new Point({ latitude: point!.latitude, longitude: point!.longitude });