Definition expression Date Field Query Issue with Map Service Sublayers in ArcGIS API JS

MahmoudAdel1 — Tue, 18 Feb 2025 12:17:07 GMT

I have a strange issue related to set a complex definition expression with date field queries to mapservice subLayer the issue was introduced with me in arcgis sdk with ios and with kotlin as well

and then I have made sure this is not related to the sdk itself so I have tried with arcgis js api and I found out this:

- for setting the expression that includes date time queries to feature layer it works well as expected

-for setting the expression that includes date time queries to map service sublayer it doesn't work as expected at all and it returns all features in layer

var dynamicMapServiceLayer = new FeatureLayer({
url: "https://myhost/server/rest/services/App/app/MapServer/1",
id: 'baseMap',
definitionExpression: "USER_NAME = 'test' AND (SIGHTING_DATE >= DATE '2025-02-17' AND SIGHTING_DATE < DATE '2025-02-18')"
});
var dynamicMapServiceLayer = new MapImageLayer({
url: "https://myhost/server/rest/services/App/app/MapServer",
id: 'baseMap',
sublayers: [
{
id: 1,
visible: true,
definitionExpression: "USER_NAME = 'test' AND (SIGHTING_DATE >= DATE '2025-02-17' AND SIGHTING_DATE < DATE '2025-02-18')"
}
]
});

I guess it is an issue with server of how to process definition expression for both
I hope to resolve this issue soon

Re: Definition expression Date Field Query Issue with Map Service Sublayers in ArcGIS API JS

MahmoudAdel1 — Tue, 18 Feb 2025 13:36:19 GMT

I found a solution for this. The reason why this issue is our used database is SQL Server so the syntax for definition expression [for date time] is not proper for SQL Server in export map service request so when I use this:
"USER_NAME = 'test' AND SIGHTING_DATE BETWEEN CAST('2025-02-17' AS DATE ) AND CAST('2025-02-18' AS DATE))"

topic Re: Definition expression Date Field Query Issue with Map Service Sublayers in ArcGIS API JS in ArcGIS JavaScript Maps SDK Questions

Definition expression Date Field Query Issue with Map Service Sublayers in ArcGIS API JS

Re: Definition expression Date Field Query Issue with Map Service Sublayers in ArcGIS API JS