nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

'where' parameter is invalid on query on feature layer

PeterHudson

Hi everyone,
it has been a week that I have this problem.
I haven't changed anything on my code but 1 week ago I received a "'where' parameter is invalid" error when this query is executed on a feature service (hosted on Arcgis online):

var statDef = new StatisticDefinition();
  statDef.statisticType = "sum";
  statDef.onStatisticField = "Area";
  statDef.outStatisticFieldName = "Tot Area";
  
  var query = new Query();
  query.returnGeometry = false;
  query.where = "Area>0";
  query.outFields = ["Area"];
  query.outStatistics = [ statDef ];
  query.groupByFieldsForStatistics = ["YearEstabl", "TypeName"];
  query.orderByFields = ["YearEstabl", "TypeName"];
  
  var qt = new QueryTask("http://services1.arcgis.com/Mpa25zPNMAT08GQg/ArcGIS/rest/services/AllPropertiesEstablished/FeatureServer/0");
  qt.execute(query, function(result){
                   ...
  }
  });

I am referencing to //js.arcgis.com/3.6/

Any ideas?

Thanks in advance!

Vind meer berichten getagd met

Accepted answers

All comments

VinayBansal

You can try by accessing the mapservice as MapServer instead of FeatureServer.....

PeterHudson

Yes Jason, not seeing any other difference, other than Supports statistics......
So rokitmaps, atleast you can give it a try by setting SupportsStatistics true for the layer.....

From here I can see that "supportsStatistics" : true. In fact it worked before.

The query works without the StatisticDefinition. Anyway, I had to rewrite my code and do the group by manually... 😞

VinayBansal

Interesting. This sample does use where clause for the statistical calculation, and it works. The main difference I can tell is the sample uses a feature layer that supports statistics, while rokitmaps uses a feature service.

Yes Jason, not seeing any other difference, other than Supports statistics......
So rokitmaps, atleast you can give it a try by setting SupportsStatistics true for the layer.....

JasonZou

Interesting. This sample does use where clause for the statistical calculation, and it works. The main difference I can tell is the sample uses a feature layer that supports statistics, while rokitmaps uses a feature service.

JasonZou

It seems like spaces are not welcomed for outStatisticFieldName.

Try to change:

statDef.outStatisticFieldName = "Tot Area";

To:

statDef.outStatisticFieldName = "TotArea";

VinayBansal

Hi Jason,

But the statistics is working on this layer......if we run query without passing the where clause......
Check the attachment.......

image.png

ADF3EEB2-EC9F-4071-BC4D-FD3BC6CE7B1B.png

JasonZou

To use outStatistics, the layer has to support Statistics. The layer you are querying does not support it. Here is one feature layer that supports it. Look for Supports Statistics: entry.

VinayBansal

Hi,

I tried running the query using Rest API interface using
http://services1.arcgis.com/Mpa25zPNMAT08GQg/ArcGIS/rest/services/AllPropertiesEstablished/FeatureServer/0/query in browser.
Even there where parameter is giving same error you are getting in your code when using with outStatistics

Don't know why it is not accepting the where clause, as Rest API documentation http://resources.arcgis.com/en/help/rest/apiref/ says that

When using outStatistics the only other parameters that will be used are groupByFieldsForStatistics, orderByFields, text, time, and where.

ColinMcNamara_1-1646422043515.png

textbook-adoption-2022-1200x1200-d.jpg

MackenzieCollins_0-1646422543476.png

Capture.PNG

MackenzieCollins_2-1646422931835.png

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.