QueryParameters with AND condition

Question

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')

RChintapalli · Answer

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

AleksandrGorshkov · Answer

@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?

RChintapalli · Answer

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