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')
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/j...
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
@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?
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