topic Re: Unable to query - 10.2.2 in ArcGIS Viewer for Flex Questions

Unable to query - 10.2.2

SaurabhGupta5 — Wed, 13 May 2015 10:49:23 GMT

Hello Everyone,

I am unable to query my rest service on following where clause:

"CLEAR_STATUS <> 'P' AND MONTH(INSPECT_DATE)=5 AND YEAR(INSPECT_DATE)=2015"

Can able to use in ArcGIS 10 earlier, Please help how can i query month and year specifically on date column using ESRI server 10.2.2

Any help will be appreciated,

Thanks and Regards

Re: Unable to query - 10.2.2

RobertScheitlin__GISP — Wed, 13 May 2015 12:03:15 GMT

Saurabh,

When you go to your rest end point for this particular layer of your map service do it say:

Supports Advanced Queries: true

Re: Unable to query - 10.2.2

RobertScheitlin__GISP — Wed, 13 May 2015 12:53:53 GMT

Saurabh,

You may also wan tot try this SQL statement:

CLEAR_STATUS <> 'P' AND INSPECT_DATE BETWEEN '2015-5-01' AND '2015-05-31'

Re: Unable to query - 10.2.2

SaurabhGupta5 — Wed, 13 May 2015 13:11:36 GMT

Hi robert,

Thanks for your quick response. I will be trying advanced to true when tmrw i back to work.

Also, as per your second reply i cannot use between beacuse i want to query this column for month only and there is another column for year . Please check my query which i have posted.

Thanks and regards

Sent from my iPhone

Re: Unable to query - 10.2.2

RobertScheitlin__GISP — Wed, 13 May 2015 13:19:16 GMT

Saurabh,

Hmm... your query indicates that both the month and year are part of the same date field...

CLEAR_STATUS <> 'P' AND MONTH(INSPECT_DATE)=5 AND YEAR(INSPECT_DATE)=2015

i want to query this column for month only and there is another column for year

Re: Unable to query - 10.2.2

SaurabhGupta5 — Thu, 14 May 2015 03:51:16 GMT

Hi robert,

My bad , thanks for resolving this...

Regards

Saurabh