topic QueryParameters with AND condition in ArcGIS Runtime SDK for Android Questions

QueryParameters with AND condition

AleksandrGorshkov — Wed, 16 Jun 2021 11:53:44 GMT

Hi! I tried to use query parameters for getting a feature list by query. In case if I use AND parameter is SQL, I get an inconsistent result.

Is AND condition works?

val visibleParams = QueryParameters()
visibleParams.whereClause = shortname IN ('short_test') AND subdivision IN ('division1', 'division2')

Re: QueryParameters with AND condition

RamaChintapalli — Thu, 17 Jun 2021 23:46:37 GMT

The AND operator should work and return consistent results. I tried modifying the below sample to use AND condition in query clause and it returned consistent result.

https://github.com/Esri/arcgis-runtime-samples-android/blob/main/java/feature-layer-query/src/main/java/com/esri/arcgisruntime/sample/featurelayerquery/MainActivity.java#L108

Changed above where condition as below,

query.setWhereClause("upper(STATE_NAME) LIKE '%" + searchString.toUpperCase() + "%' AND TOTPOP_CY > 1000000");

Could you repro the issue you are encountering using the service from above sample?

Thanks
Rama

Re: QueryParameters with AND condition

AleksandrGorshkov — Mon, 21 Jun 2021 08:16:03 GMT

@RamaChintapalli hello!

I found that NOT IN operator give me inconsistent result:

crop_shortname NOT IN ('short_name1') AND subdivision NOT IN ('sub1')

Are NOT IN should work properly?

Re: QueryParameters with AND condition

RamaChintapalli — Wed, 23 Jun 2021 22:52:30 GMT

Hi @AleksandrGorshkov

All SQL operations supported by service/local SQLite geodatabase are expected to work. I just tried NOT IN operator on another FeatureService which worked consistently.

You can also contact our support team and they will be able to debug through your data and see where the problem exactly is.

Thanks

Rama