topic Re: Field Map not loading layer with SQL statement in ArcGIS Field Maps Questions

Field Map not loading layer with SQL statement

ChetShuler — Mon, 16 Sep 2024 13:18:42 GMT

I created an outfalls inspection app for our crews to manage daily inspections. The previous ArcMap service works just fine. However after moving the app to Pro and a creating a Hosted Feature Service I had to rewrite the statement. It works fine within the Pro as well as the New Viewer on AGOL. But when I load the map into Field Maps the layer containing the SQL statement will not load. I created a couple of views and added the statement with no progress. The images below shows the statement and the points are filtering correctly.

Statement

New Viewer Perfect!!

Perfect! Magenta are due

The magenta points are past due which is exactly what I need. My problem is the layer containing the statement will not show or load into Field Maps. I'm finding the Hosted Feature Services have quite few limitations.. 😥

Re: Field Map not loading layer with SQL statement

ChristopherCounsell — Tue, 17 Sep 2024 06:48:52 GMT

Can you publish the layer without the definition query, then apply it as a View filter?

You could also apply it as a Web Map filter but this can cause issues with offline and I don't recommend sharing the original Feature Layer (always use Views to share your data...)

Re: Field Map not loading layer with SQL statement

ChetShuler — Wed, 25 Sep 2024 14:19:44 GMT

I tried that.. Its works in everything but field maps..

Re: Field Map not loading layer with SQL statement

MitchellGrafstein — Wed, 25 Sep 2024 14:55:35 GMT

I know we had an issue with being able to take down offline areas in ArcGIS Field Maps when a date filter was being used. This issue persisted even into recent AGOL versions, and I believe that still will not work. (I think there may be a post specifically on that in the forum now and it is in the queue to be fixed I believe.)

I do believe those queries worked online for us. Probably have to see what the viewDefinitionQuery is within the service. Is this in ArcGIS Enterprise or ArcGIS Online?

For ours, this syntax being used within the viewDefinitionQuery was this:

inspection_date BETWEEN CURRENT_TIMESTAMP- INTERVAL '30' DAY AND CURRENT_TIMESTAMP

The above did work online in Field Maps, but offline areas would end up timing out. We ended up using a special field to calculate whether we wanted data to be visible based on similar criteria and used that separate field's values instead as a workaround.

The above would work online but fail when creating an offline area.

I hope some of the above helps.

Re: Field Map not loading layer with SQL statement

ChetShuler — Wed, 25 Sep 2024 16:08:24 GMT

ArcGIS Online. I having the crew input the date.. So I have a date field to query from.. I have the definition query shown in my image screenshots. I didn't see any way to enter custom queries from the service.. I didn't see any way adding to the date inspection in the built in pulldown query statements. I wrote the query in PRO. So I might be missing something??

Re: Field Map not loading layer with SQL statement

MitchellGrafstein — Wed, 25 Sep 2024 17:17:50 GMT

It's a bit hidden to see what the actual definition query is in ArcGIS Online. (Adding some screenshots to help guide you along the way.)

If you go to the item page in ArcGIS Online and find the service page (REST endpoint) link near the bottom right of the page. (Click "View.")

On the service page, click on the link for the layer in the question.

Click on the "JSON" link at the top of the page.

Search for "definitionquery" on that page and you should see entries there. Let us know what it says if you can get that far along.

There are ways to update these directly, but it gets a bit complicated from here. Just curious what it currently says and if it matches what you wrote in ArcGIS Pro or if AGOL updated it to something else.

Re: Field Map not loading layer with SQL statement

ChetShuler — Wed, 25 Sep 2024 17:50:44 GMT

You will have to excuse my ignorance. I looked at both services no ViewDefinitionQuery found. 3 shots..123

Re: Field Map not loading layer with SQL statement

MitchellGrafstein — Wed, 25 Sep 2024 18:05:21 GMT

No worries, I'm happy to assist.

If you go back a step and find the layer in question and click on that before you click on the JSON link, that should get us to where we need to go. It looks like the layer in question is "Outfall Inspections", so we would want to click on the link with that name, then click on the JSON link. You may only see "definitionQuery" if it is not a view. Also, if you don't drill down to the layer level, the viewer for the JSON may not show the part of the JSON we need. (ArcGIS Online hides a bit here without you getting into it a bit, but if you drill down to the layer, it will expose the part of the JSON we need.)

Re: Field Map not loading layer with SQL statement

ChetShuler — Wed, 25 Sep 2024 18:19:01 GMT

Still do not see it..

  "currentVersion" : 11.2, 
  "id" : 0, 
  "name" : "Outfall Inspections", 
  "type" : "Feature Layer", 
  "serviceItemId" : "fb20ecec2e72404c939c5a5095731bde", 
  "cacheMaxAge" : 30, 
  "isView" : true, 
  "isUpdatableView" : true, 
  "sourceSchemaChangesAllowed" : true, 
  "displayField" : "created_user", 
  "description" : "", 
  "copyrightText" : "", 
  "defaultVisibility" : true, 
  "editFieldsInfo" : {
    "creationDateField" : "created_date", 
    "creatorField" : "created_user", 
    "editDateField" : "last_edited_date", 
    "editorField" : "last_edited_user"
  }, 
  "editingInfo" : {
    "lastEditDate" : 1726168925928, 
    "schemaLastEditDate" : 1726168925928, 
    "dataLastEditDate" : 1726162294420
  }, 
  "relationships" : [], 
  "isDataVersioned" : false, 
  "hasContingentValuesDefinition" : false, 
  "supportsAppend" : true, 
  "supportsCalculate" : true, 
  "supportsASyncCalculate" : true, 
  "supportsTruncate" : false, 
  "supportsAttachmentsByUploadId" : true, 
  "supportsAttachmentsResizing" : true, 
  "supportsRollbackOnFailureParameter" : true, 
  "supportsStatistics" : true, 
  "supportsExceedsLimitStatistics" : true, 
  "supportsAdvancedQueries" : true, 
  "supportsValidateSql" : true, 
  "supportsCoordinatesQuantization" : true, 
  "supportsLayerOverrides" : true, 
  "supportsTilesAndBasicQueriesMode" : true, 
  "supportsFieldDescriptionProperty" : true, 
  "supportsQuantizationEditMode" : true, 
  "supportsApplyEditsWithGlobalIds" : true, 
  "supportsReturningQueryGeometry" : true, 
  "advancedQueryCapabilities" : {
    "supportsPagination" : true, 
    "supportsQueryAttachmentsCountOnly" : true, 
    "supportsPaginationOnAggregatedQueries" : true, 
    "supportsQueryRelatedPagination" : true, 
    "supportsQueryWithDistance" : true, 
    "supportsReturningQueryExtent" : true, 
    "supportsStatistics" : true, 
    "supportsOrderBy" : true, 
    "supportsDistinct" : true, 
    "supportsQueryWithResultType" : true, 
    "supportsSqlExpression" : true, 
    "supportsAdvancedQueryRelated" : true, 
    "supportsCountDistinct" : true, 
    "supportsPercentileStatistics" : true, 
    "supportsSpatialAggregationStatistics" : true, 
    "supportedSpatialAggregationStatistics" : [
      "EnvelopeAggregate", 
      "CentroidAggregate", 
      "ConvexHullAggregate"
    ], 
    "supportsLod" : true, 
    "supportsQueryWithLodSR" : false, 
    "supportedLodTypes" : [
      "geohash"
    ], 
    "supportsReturningGeometryCentroid" : false, 
    "supportsReturningGeometryEnvelope" : true, 
    "supportsQueryWithDatumTransformation" : true, 
    "supportsCurrentUserQueries" : true, 
    "supportsHavingClause" : true, 
    "supportsOutFieldSQLExpression" : true, 
    "supportsMaxRecordCountFactor" : true, 
    "supportsTopFeaturesQuery" : true, 
    "supportsDisjointSpatialRel" : true, 
    "supportsQueryWithCacheHint" : true, 
    "supportedOperationsWithCacheHint" : [
      "query", 
      "queryTopFilter", 
      "queryAnalytics", 
      "queryAttachments", 
      "queryRelated", 
      "queryBins"
    ], 
    "supportsQueryAnalytic" : true, 
    "supportsQueryBins" : true, 
    "supportsDefaultSR" : true, 
    "supportsFullTextSearch" : true
  }, 
  "advancedQueryAnalyticCapabilities" : {
    "supportsLinearRegression" : true, 
    "supportsAsync" : true, 
    "supportsPercentileAnalytic" : true
  }, 
  "queryBinsCapabilities" : {
    "supportsAsync" : true, 
    "supportsAutoIntervalBin" : true, 
    "supportsFixedIntervalBin" : true, 
    "supportsFixedBoundariesBin" : true, 
    "supportsDateBin" : true, 
    "supportedStatisticTypes" : [
      "COUNT", 
      "SUM", 
      "AVG", 
      "VAR", 
      "STDDEV", 
      "MIN", 
      "MAX", 
      "PERCENTILE_CONT", 
      "PERCENTILE_DISC", 
      "CentroidAggregate", 
      "EnvelopeAggregate", 
      "ConvexHullAggregate"
    ]
  }, 
  "advancedEditingCapabilities" : {
    "supportedSqlFormatsInCalculate" : [
      "standard"
    ], 
    "supportsAsyncApplyEdits" : true, 
    "supportsReturnEditResults" : true, 
    "supportsApplyEditsbyUploadID" : true, 
    "supportedApplyEditsUploadIDFormats" : "JSON"
  }, 
  "infoInEstimates" : [
    "extent", 
    "count"
  ], 
  "useStandardizedQueries" : true, 
  "geometryType" : "esriGeometryPoint", 
  "minScale" : 0, 
  "maxScale" : 0, 
  "extent" : {
    "xmin" : 1424296.03360489, 
    "ymin" : 533078.84971806407, 
    "xmax" : 1460225.401706636, 
    "ymax" : 568494.88715356588, 
    "spatialReference" : {
      "wkid" : 102723, 
      "latestWkid" : 3735
    }
  }, 
  "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"b1d1618cf0b6242e4a59579073aabe9a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAQCAYAAADJViUEAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAnUlEQVQokcWT4Q3CIBSEv4csUR2jjuEiOoVTtOkejlHGKF1C8wxEE0ASq/3R+8fxjnuXHJYVsDVy6rkCbUK5wzly38VBKMLpfVD9wXkp7Gqx77J8YGhIVhVDU87sLzgbScOYicuM+jnjO44bZ/4XNgQP+2fsjiHmfEGVm2hekvuDOTqHB9KLqWcWyV3KGbYvSQUu7bMIfrG49oNqeALFKylwMWkz3AAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":12,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, 
  "allowGeometryUpdates" : true, 
  "hasAttachments" : false, 
  "viewSourceHasAttachments" : false, 
  "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", 
  "hasMetadata" : true, 
  "hasM" : false, 
  "hasZ" : false, 
  "objectIdField" : "OBJECTID", 
  "uniqueIdField" : 
  {
    "name" : "OBJECTID", 
    "isSystemMaintained" : true
  }, 
  "globalIdField" : "GlobalID", 
  "typeIdField" : "", 
  "fields" : [
    {
      "name" : "OBJECTID", 
      "type" : "esriFieldTypeOID", 
      "alias" : "OBJECTID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Element_ID", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "Element_ID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "IsAbandon", 
      "type" : "esriFieldTypeSmallInteger", 
      "alias" : "IsAbandon", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : 0
    }, 
    {
      "name" : "created_user", 
      "type" : "esriFieldTypeString", 
      "alias" : "created_user", 
      "sqlType" : "sqlTypeOther", 
      "length" : 255, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "created_date", 
      "type" : "esriFieldTypeDate", 
      "alias" : "created_date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "last_edited_user", 
      "type" : "esriFieldTypeString", 
      "alias" : "last_edited_user", 
      "sqlType" : "sqlTypeOther", 
      "length" : 255, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "last_edited_date", 
      "type" : "esriFieldTypeDate", 
      "alias" : "last_edited_date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "Inspector", 
      "type" : "esriFieldTypeString", 
      "alias" : "Inspector", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Date", 
      "type" : "esriFieldTypeDate", 
      "alias" : "Date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "Time", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "Time", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Weather", 
      "type" : "esriFieldTypeString", 
      "alias" : "Weather", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Weather", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Weater Condition", 
        "codedValues" : [
          {
            "name" : "Sunny", 
            "code" : "Sunny"
          }, 
          {
            "name" : "Cloudy", 
            "code" : "Cloudy"
          }, 
          {
            "name" : "Rainy", 
            "code" : "Rainy"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Prec3Day", 
      "type" : "esriFieldTypeString", 
      "alias" : "Prec3Day", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "YesNo", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Yes No Statement", 
        "codedValues" : [
          {
            "name" : "Yes", 
            "code" : "Yes"
          }, 
          {
            "name" : "No", 
            "code" : "No"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Source", 
      "type" : "esriFieldTypeString", 
      "alias" : "Source", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Source", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Water source", 
        "codedValues" : [
          {
            "name" : "Groundwater", 
            "code" : "Groundwater"
          }, 
          {
            "name" : "Irrigation", 
            "code" : "Irrigation"
          }, 
          {
            "name" : "Condensate", 
            "code" : "Condensate"
          }, 
          {
            "name" : "Residual", 
            "code" : "Residual"
          }, 
          {
            "name" : "Unknown", 
            "code" : "Unknown"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Mouth", 
      "type" : "esriFieldTypeString", 
      "alias" : "Mouth", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Mouth", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Receiving waterbody", 
        "codedValues" : [
          {
            "name" : "Creek", 
            "code" : "Creek"
          }, 
          {
            "name" : "Ditch", 
            "code" : "Ditch"
          }, 
          {
            "name" : "Basin", 
            "code" : "Basin"
          }, 
          {
            "name" : "River", 
            "code" : "River"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Flow", 
      "type" : "esriFieldTypeString", 
      "alias" : "Flow", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Flow", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Flow amount", 
        "codedValues" : [
          {
            "name" : "None", 
            "code" : "None"
          }, 
          {
            "name" : "Trickle", 
            "code" : "Trickle"
          }, 
          {
            "name" : "Steady", 
            "code" : "Steady"
          }, 
          {
            "name" : "High", 
            "code" : "High"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "StrctType", 
      "type" : "esriFieldTypeString", 
      "alias" : "StrctType", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "StrctType", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Type of headwall", 
        "codedValues" : [
          {
            "name" : "Full", 
            "code" : "Full"
          }, 
          {
            "name" : "Half", 
            "code" : "Half"
          }, 
          {
            "name" : "None", 
            "code" : "None"
          }, 
          {
            "name" : "Other", 
            "code" : "Other"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "PipeShape", 
      "type" : "esriFieldTypeString", 
      "alias" : "PipeShape", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "PipeShape", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Shape of pipe", 
        "codedValues" : [
          {
            "name" : "Round", 
            "code" : "Round"
          }, 
          {
            "name" : "Oval", 
            "code" : "Oval"
          }, 
          {
            "name" : "Square", 
            "code" : "Square"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "PipeMaterial", 
      "type" : "esriFieldTypeString", 
      "alias" : "PipeMaterial", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "PipeMaterial", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Pipe material", 
        "codedValues" : [
          {
            "name" : "CMP", 
            "code" : "CMP"
          }, 
          {
            "name" : "Concrete", 
            "code" : "Concrete"
          }, 
          {
            "name" : "Plastic", 
            "code" : "Plastic"
          }, 
          {
            "name" : "SDR 20", 
            "code" : "SDR 20"
          }, 
          {
            "name" : "Steel", 
            "code" : "Steel"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "DebrisPoll", 
      "type" : "esriFieldTypeString", 
      "alias" : "DebrisPoll", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Debris", 
        "codedValues" : [
          {
            "name" : "None", 
            "code" : "None"
          }, 
          {
            "name" : "Brownish Foam", 
            "code" : "Brownish Foam"
          }, 
          {
            "name" : "Floating Green Scum", 
            "code" : "Floating Green Scum"
          }, 
          {
            "name" : "Oil Film or Sheen", 
            "code" : "Oil Film or Sheen"
          }, 
          {
            "name" : "Organic Material", 
            "code" : "Organic Material"
          }, 
          {
            "name" : "Foam", 
            "code" : "Foam"
          }, 
          {
            "name" : "Sewage", 
            "code" : "Sewage"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Odor", 
      "type" : "esriFieldTypeString", 
      "alias" : "Odor", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Odor", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Odor or smell", 
        "codedValues" : [
          {
            "name" : "None/Natural", 
            "code" : "None/Natural"
          }, 
          {
            "name" : "Musty", 
            "code" : "Musty"
          }, 
          {
            "name" : "Sewage/Septic", 
            "code" : "Sewage/Septic"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Clarity", 
      "type" : "esriFieldTypeString", 
      "alias" : "Clarity", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Clarity", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Clarity of water", 
        "codedValues" : [
          {
            "name" : "Clear", 
            "code" : "Clear"
          }, 
          {
            "name" : "Cloudy", 
            "code" : "Cloudy"
          }, 
          {
            "name" : "Opaque", 
            "code" : "Opaque"
          }, 
          {
            "name" : "Muddy", 
            "code" : "Muddy"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Sediment", 
      "type" : "esriFieldTypeString", 
      "alias" : "Sediment", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Sediment", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Sediment in structure or channel", 
        "codedValues" : [
          {
            "name" : "Open", 
            "code" : "Open"
          }, 
          {
            "name" : "1/4 Full", 
            "code" : "1/4 Full"
          }, 
          {
            "name" : "1/2 Full", 
            "code" : "1/2 Full"
          }, 
          {
            "name" : "3/4 Full", 
            "code" : "3/4 Full"
          }, 
          {
            "name" : "Plugged", 
            "code" : "Plugged"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "StrctCond", 
      "type" : "esriFieldTypeString", 
      "alias" : "StrctCond", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "OutCond", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Condition of outfall", 
        "codedValues" : [
          {
            "name" : "Excellent", 
            "code" : "Excellent"
          }, 
          {
            "name" : "Good", 
            "code" : "Good"
          }, 
          {
            "name" : "Fair", 
            "code" : "Fair"
          }, 
          {
            "name" : "Poor", 
            "code" : "Poor"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Litter", 
      "type" : "esriFieldTypeString", 
      "alias" : "Litter", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "YesNo", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Yes No Statement", 
        "codedValues" : [
          {
            "name" : "Yes", 
            "code" : "Yes"
          }, 
          {
            "name" : "No", 
            "code" : "No"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Erosion", 
      "type" : "esriFieldTypeString", 
      "alias" : "Erosion", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "YesNo", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Yes No Statement", 
        "codedValues" : [
          {
            "name" : "Yes", 
            "code" : "Yes"
          }, 
          {
            "name" : "No", 
            "code" : "No"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "NearAct", 
      "type" : "esriFieldTypeString", 
      "alias" : "NearAct", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "YesNo", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Yes No Statement", 
        "codedValues" : [
          {
            "name" : "Yes", 
            "code" : "Yes"
          }, 
          {
            "name" : "No", 
            "code" : "No"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "NearDesc", 
      "type" : "esriFieldTypeString", 
      "alias" : "NearDesc", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Comments", 
      "type" : "esriFieldTypeString", 
      "alias" : "Comments", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "GlobalID", 
      "type" : "esriFieldTypeGlobalID", 
      "alias" : "GlobalID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 38, 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "SearchID", 
      "type" : "esriFieldTypeString", 
      "alias" : "SearchID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 20, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }
  ], 
  "indexes" : [
    {
      "name" : "PK__OUTFALL___F4B70D8525957B88", 
      "fields" : "OBJECTID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "user_40662.OUTFALL_INSPECTIONS_OUTFALL_INSPECTIONS_Shape_sidx", 
      "fields" : "Shape", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Spatial"
    }, 
    {
      "name" : "FDO_GlobalID", 
      "fields" : "GlobalID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "created_dateIndex", 
      "fields" : "created_date", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "created_date Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "created_userIndex", 
      "fields" : "created_user", 
      "isAscending" : false, 
      "isUnique" : false, 
      "description" : "created_user Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "last_edited_dateIndex", 
      "fields" : "last_edited_date", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "last_edited_date Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "last_edited_userIndex", 
      "fields" : "last_edited_user", 
      "isAscending" : false, 
      "isUnique" : false, 
      "description" : "last_edited_user Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "Date_Index", 
      "fields" : "Date", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "Date_Index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "IsAbandon_Index", 
      "fields" : "IsAbandon", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "IsAbandon_Index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "IX_OUTFALL_INSPECTIONS_OUTFALL_INSPECTIONS_SearchID_ASC", 
      "fields" : "SearchID", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "web map settings", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "FT_OUTFALL_INSPECTIONS_OUTFALL_INSPECTIONS_SearchID", 
      "fields" : "SearchID", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "web map settings", 
      "indexType" : "FullText"
    }
  ], 
  "dateFieldsTimeReference" : {
    "timeZone" : "UTC", 
    "respectsDaylightSaving" : false
  }, 
  "preferredTimeReference" : {
    "timeZone" : "Eastern Standard Time", 
    "respectsDaylightSaving" : true
  }, 
  "types" : [], 
  "templates" : [
    {
      "name" : "Outfall Inspections", 
      "description" : "", 
      "drawingTool" : "esriFeatureEditToolPoint", 
      "prototype" : {
        "attributes" : {
          "SearchID" : null, 
          "Comments" : null, 
          "Element_ID" : null, 
          "IsAbandon" : 0, 
          "NearDesc" : null, 
          "NearAct" : null, 
          "Erosion" : null, 
          "Litter" : null, 
          "Inspector" : null, 
          "Date" : null, 
          "Time" : null, 
          "Weather" : null, 
          "Prec3Day" : null, 
          "Source" : null, 
          "Mouth" : null, 
          "Flow" : null, 
          "StrctType" : null, 
          "PipeShape" : null, 
          "PipeMaterial" : null, 
          "DebrisPoll" : null, 
          "Odor" : null, 
          "Clarity" : null, 
          "Sediment" : null, 
          "StrctCond" : null
        }
      }
    }
  ], 
  "supportedQueryFormats" : "JSON, geoJSON, PBF", 
  "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", 
  "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", 
  "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", 
  "supportedConvertFileFormats" : "JSON,PBF", 
  "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", 
  "supportedSpatialRelationships" : [
    "esriSpatialRelIntersects", 
    "esriSpatialRelContains", 
    "esriSpatialRelCrosses", 
    "esriSpatialRelEnvelopeIntersects", 
    "esriSpatialRelIndexIntersects", 
    "esriSpatialRelOverlaps", 
    "esriSpatialRelTouches", 
    "esriSpatialRelWithin", 
    "esriSpatialRelDisjoint", 
    "esriSpatialRelRelation"
  ], 
  "supportedContingentValuesFormats" : "JSON, PBF", 
  "supportedSyncDataOptions" : 260, 
  "hasStaticData" : true, 
  "maxRecordCount" : 2000, 
  "standardMaxRecordCount" : 32000, 
  "standardMaxRecordCountNoGeometry" : 32000, 
  "tileMaxRecordCount" : 8000, 
  "maxRecordCountFactor" : 1, 
  "capabilities" : "Query,Extract"
}

Re: Field Map not loading layer with SQL statement

ChetShuler — Wed, 25 Sep 2024 18:31:56 GMT

I did click on the right view.. I went to the filter tool and got this.. I leave the view and reopened and my map is correct.. I'm in uncharted territory.. lol. the move has been quite the adventure.. Query language has changed. Where the older version worked quite well and much easier.. SMH..

Re: Field Map not loading layer with SQL statement

MitchellGrafstein — Wed, 25 Sep 2024 18:55:03 GMT

Seems the query may not be saving at the layer level, and it very may might matter how it is being constructed then.

Edit - Also, unfortunately, complex filters at the layer level will not show up as it suggests. Are you trying to filter the layer itself? Or are you trying to filter just at the map level? Or both?

I'm off for the day, but I can take another look here tomorrow.

Re: Field Map not loading layer with SQL statement

ChetShuler — Wed, 25 Sep 2024 18:55:11 GMT

Thank and no hurry.. I been told to start migrating over to the Cloud. I saved all the original apps.. Still a lot of short coming with Hosted Feature Services.