https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/definition-query-in-arcgis-api-for-javascript-3-36/m-p/1219962#M78937 <P>I cannot get the definition queries to work using dates in ArcGIS API for JavaScript 3.36 when using a map service that was published from ArcGIS Pro 2.8.3.&nbsp; I am using ArcGISDynamicMapServiceLayer.</P><LI-CODE lang="c"> //********************************************* // Build Definition Expression //********************************************* function buildDefExpr(paramOnDate, paramOffDate, paramSearchType, paramSpecial) { if (paramSearchType == "Today") { var dateExpr1 = "DisplayOnDate &lt;= '" + paramOnDate + "' AND DisplayOffDate &gt;= '" + paramOffDate + "'"; var dateExpr2 = ""; var dateAltExpr1 = "AlteranteRouteStartDate &lt;= '" + paramOnDate + "' AND (AlternateRouteEndDate &gt;= '" + paramOffDate + "')"; var dateAltExpr2 = ""; if (paramSpecial == "Trucks") { dateExpr1 += " AND TravelImpact = 'No Truck Traffic'"; } } else { var dateExpr1 = "((DisplayOnDate &gt;= '" + paramOnDate + "' AND DisplayOnDate &lt;= '" + paramOffDate + "') OR DisplayOnDate &lt;= '" + paramOnDate + "') AND "; var dateExpr2 = "((DisplayOffDate &gt;= '" + paramOnDate + "' AND DisplayOffDate &lt;= '" + paramOffDate + "') OR DisplayOffDate &gt;= '" + paramOffDate + "')"; var dateAltExpr1 = "((AlteranteRouteStartDate &gt;= '" + paramOnDate + "' AND AlteranteRouteStartDate &lt;= '" + paramOffDate + "') OR AlteranteRouteStartDate &lt;= '" + paramOnDate + "') AND "; var dateAltExpr2 = "((AlternateRouteEndDate &gt;= '" + paramOnDate + "' AND AlternateRouteEndDate &lt;= '" + paramOffDate + "') OR AlternateRouteEndDate &gt;= '" + paramOffDate + "')"; if (paramSpecial == "Trucks") { dateExpr2 += " AND TravelImpact = 'No Truck Traffic'"; } } // set layer definitions for site and route var defExpr_1_2 = "", defAltExpr = ""; defExpr_1_2 = dateExpr1 + dateExpr2; layerDefinitions[travelImpactSiteIndex] = defExpr_1_2; layerDefinitions[travelImpactRouteIndex] = defExpr_1_2; // set layer definition for alternate route defAltExpr = dateAltExpr1 + dateAltExpr2; layerDefinitions[altRouteIndex] = defAltExpr; // set layer definitions allTravelImpactsLayer.setLayerDefinitions(layerDefinitions); // set identify-layer definitions identifyLayerDefinitions[travelImpactRouteIndex] = defExpr_1_2; identifyLayerDefinitions[altRouteIndex] = defAltExpr; identifyParams.layerDefinitions = identifyLayerDefinitions; } // end function buildDefExpr()</LI-CODE><P>Is there a 3.x version that will work?&nbsp; Do I need to convert to 4.x?</P><P>Note:&nbsp; Definition queries using dates failed in ArcGIS Pro 2.8.3 when I used Make Route Event layer from a view.&nbsp; I had to import my map from ArcMap to get the definition queries to work.</P> Fri, 07 Oct 2022 17:04:09 GMT LoriMcCormack1 2022-10-07T17:04:09Z https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/definition-query-in-arcgis-api-for-javascript-3-36/m-p/1219962#M78937 <P>I cannot get the definition queries to work using dates in ArcGIS API for JavaScript 3.36 when using a map service that was published from ArcGIS Pro 2.8.3.&nbsp; I am using ArcGISDynamicMapServiceLayer.</P><LI-CODE lang="c"> //********************************************* // Build Definition Expression //********************************************* function buildDefExpr(paramOnDate, paramOffDate, paramSearchType, paramSpecial) { if (paramSearchType == "Today") { var dateExpr1 = "DisplayOnDate &lt;= '" + paramOnDate + "' AND DisplayOffDate &gt;= '" + paramOffDate + "'"; var dateExpr2 = ""; var dateAltExpr1 = "AlteranteRouteStartDate &lt;= '" + paramOnDate + "' AND (AlternateRouteEndDate &gt;= '" + paramOffDate + "')"; var dateAltExpr2 = ""; if (paramSpecial == "Trucks") { dateExpr1 += " AND TravelImpact = 'No Truck Traffic'"; } } else { var dateExpr1 = "((DisplayOnDate &gt;= '" + paramOnDate + "' AND DisplayOnDate &lt;= '" + paramOffDate + "') OR DisplayOnDate &lt;= '" + paramOnDate + "') AND "; var dateExpr2 = "((DisplayOffDate &gt;= '" + paramOnDate + "' AND DisplayOffDate &lt;= '" + paramOffDate + "') OR DisplayOffDate &gt;= '" + paramOffDate + "')"; var dateAltExpr1 = "((AlteranteRouteStartDate &gt;= '" + paramOnDate + "' AND AlteranteRouteStartDate &lt;= '" + paramOffDate + "') OR AlteranteRouteStartDate &lt;= '" + paramOnDate + "') AND "; var dateAltExpr2 = "((AlternateRouteEndDate &gt;= '" + paramOnDate + "' AND AlternateRouteEndDate &lt;= '" + paramOffDate + "') OR AlternateRouteEndDate &gt;= '" + paramOffDate + "')"; if (paramSpecial == "Trucks") { dateExpr2 += " AND TravelImpact = 'No Truck Traffic'"; } } // set layer definitions for site and route var defExpr_1_2 = "", defAltExpr = ""; defExpr_1_2 = dateExpr1 + dateExpr2; layerDefinitions[travelImpactSiteIndex] = defExpr_1_2; layerDefinitions[travelImpactRouteIndex] = defExpr_1_2; // set layer definition for alternate route defAltExpr = dateAltExpr1 + dateAltExpr2; layerDefinitions[altRouteIndex] = defAltExpr; // set layer definitions allTravelImpactsLayer.setLayerDefinitions(layerDefinitions); // set identify-layer definitions identifyLayerDefinitions[travelImpactRouteIndex] = defExpr_1_2; identifyLayerDefinitions[altRouteIndex] = defAltExpr; identifyParams.layerDefinitions = identifyLayerDefinitions; } // end function buildDefExpr()</LI-CODE><P>Is there a 3.x version that will work?&nbsp; Do I need to convert to 4.x?</P><P>Note:&nbsp; Definition queries using dates failed in ArcGIS Pro 2.8.3 when I used Make Route Event layer from a view.&nbsp; I had to import my map from ArcMap to get the definition queries to work.</P> Fri, 07 Oct 2022 17:04:09 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/definition-query-in-arcgis-api-for-javascript-3-36/m-p/1219962#M78937 LoriMcCormack1 2022-10-07T17:04:09Z