Query ServiceFeatureTable with CreationDate in whereClause in ArcGIS java

Asked May 30 '18 at 11:56

Active May 30 '18 at 11:56

Viewed 228 times

I am trying to query the ServiceFeatureTable using ArcGIS java. If we use REST service to query we can query based on the CreationDate. I am trying to do the same thing using ArcGIS java. runtime SDK as below

 ServiceFeatureTable featureTable = new ServiceFeatureTable(url);
 QueryParameters query = new QueryParameters();
 query.setWhereClause("CreationDate >= '1527671854180'");
 query.setReturnGeometry(true);
 ListenableFuture<FeatureQueryResult> queryFeaturesAsync = featureTable.queryFeaturesAsync(query);

But it is giving com.esri.arcgisruntime.io.JsonEmbeddedException: Cannot perform query. Invalid query parameters.

Is it possible to query ServiceFeatureTable based on the CreationDate?emphasized text

asked May 30 '18 at 11:56

Naveen Kumar H S

1,304
16
30

What is the field type for `CreationDate` in the feature service? You'll find it in the REST endpoint. It should be something like `esriFieldTypeInteger` or `esriFieldTypeDate`. – Gary Sheppard May 30 '18 at 13:22
type is `esriFieldTypeDate` and sqlType is `sqlTypeOther` – Naveen Kumar H S May 30 '18 at 13:36
Have you tried without the single quotes? "CreationDate >= 1527671854180"? – Nixta May 31 '18 at 13:54

Query ServiceFeatureTable with CreationDate in whereClause in ArcGIS java

0 Answers0