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; } } }

Unable to query - 10.2.2

SaurabhDestiny18

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

Encuentra más publicaciones etiquetadas con

Accepted answers

RobertScheitlin__GISP

Saurabh,

You may also wan tot try this SQL statement:

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

All comments

SaurabhDestiny18

Hi robert,

My bad , thanks for resolving this...

Regards

Saurabh

RobertScheitlin__GISP

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

SaurabhDestiny18

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

RobertScheitlin__GISP

Saurabh,

You may also wan tot try this SQL statement:

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

RobertScheitlin__GISP

Saurabh,

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

Supports Advanced Queries: true

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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