Field Map not loading layer with SQL statement

[ChetShuler]

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.. 😥

[ChristopherCounsell]

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...)

[ChetShuler]

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

[MitchellGrafstein]

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.

[ChetShuler]

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??

[MitchellGrafstein]

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.

[ChetShuler]

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

1

[MitchellGrafstein]

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.)

[ChetShuler]

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

[ChetShuler]

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..