- URL:
- https://<Dashboard-url>/reviewerResultsBy:<FieldName>/filter
- Methods:
GET
- Required Capability:
- Data Reviewer Server
- Version Introduced:
- 10.1
Description
Use the Filter operation to limit, or more precisely, specify aggregations returned by a Dashboard request. Filters are expressions that apply conditions to a query. These conditions can be spatial or attribute-based.
Filters apply to fields in the reviewerResultsBy Dashboard collection. Filters are similar to a SQL WHERE clause in that you apply a condition to a query. For example, you can create a filters that have the following conditions:
- FEATUREOBJECTCLASSES that have a SEVERITY of 2.
- SEVERITY values within a list (2,3,5) or range (1-3).
- BATCHJOBDATETIME that occurred between specific dates.
- CHECKNAME used in validation within a spatial extent.
You can filter reviewer
by fields, excluding REVCHECKRUNTABLE.CHECKRUNPROPERTIES, from the Reviewer workspace's REVTABLEMAIN and REVCHECKRUNTABLE tables.
Request parameters
Parameter | Details |
---|---|
| An array of filters. A filter is a
filters |
| The response format. The default response format is Values: |
Example usage
Example 1: Filter reviewer
dashboard results to show total counts where SEVERITY values = 1.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/SEVERITY/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"severity",fieldValue:1}]}]}&f=json
JSON Response example
{
"fieldName": "SEVERITY",
"dashboardResults": [
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "severity",
"fieldValue": 1
}
]
}
]
}
Example 2: Filter reviewer
dashboard results to show total counts for FEATUREOBJECTCLASS equal to 'OpenWaterA'.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/FEATUREOBJECTCLASS/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"FeatureObjectClass",fieldValue:"OpenWaterA"}]}]}&f=json
JSON Response example
{
"fieldName": "FEATUREOBJECTCLASS",
"dashboardResults": [
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "FeatureObjectClass",
"fieldValue": "OpenWaterA"
}
]
}
]
}
Example 3: Filter reviewer
dashboard results to show total counts for the Cemetery SUBTYPE.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/SUBTYPE/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"SubType",fieldValue:"Cemetery"}]}]}&f=pjson
JSON Response example
{
"fieldName": "SUBTYPE",
"dashboardResults": [
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "SubType",
"fieldValue": "Cemetery"
}
]
}
]
}
Example 4: Filter reviewer
dashboard results to show total counts of BATCHJOBCHECKGROUPs that have a severity of 4. This example demonstrates filtering one result value type, BATCHJOBCHECKGROUP, by another (SEVERITY).
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/BATCHJOBCHECKGROUP/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"severity",fieldValue:4}]}]}&f=json
JSON Response example
{
"fieldName": "BATCHJOBCHECKGROUP",
"dashboardResults": [
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "severity",
"fieldValue": 4
}
]
}
]
}
Example 5: Use a list
to filter SEVERITY values by building and tower subtypes. This example shows filtering one results value type, SEVERITY, by another (SUBTYPE).
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/SEVERITY/filter?filtersArray={filtersArray:[{listAttributeFilter:[{fieldName:"subType",fieldValue:["Building","Tower"]}]}]}&f=json
JSON Response example
{
"fieldName": "SEVERITY",
"dashboardResults": [
{
"fieldValue": "2",
"count": 268
}
],
"filters": [
{
"listAttributeFilter": [
{
"fieldName": "subType",
"fieldValue": [
"Building",
"Tower"
]
}
]
}
]
}
Example 6: Use a range
to filter FEATUREOBJECTCLASS by severity 1-3. This example shows filtering one result value type, FEATUREOBJECTCLASS, by another (SEVERITY).
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/FEATUREOBJECTCLASS/filter?filtersArray={filtersArray:[{rangeAttributeFilter:[{fieldName:"severity",fieldValue:{minFieldValue:1,maxFieldValue:3}}]}]}&f=json
JSON Response example
{
"fieldName": "FEATUREOBJECTCLASS",
"dashboardResults": [
{
"fieldValue": "BuiltupA",
"count": 266
},
{
"fieldValue": "BuiltupP",
"count": 2
}
],
"filters": [
{
"rangeAttributeFilter": [
{
"fieldName": "severity",
"fieldValue": {
"minFieldValue": 1,
"maxFieldValue": 3
}
}
]
}
]
}
Example 7: Use a spatial
to find SUBTYPE Reviewer results within a JSON
polygon.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/SUBTYPE/filter?filtersArray={filtersArray:[{spatialFilter:[{"rings":[[[-97.7300477260853,30.297977761151],[-97.6975021395297,30.297977761151],[-97.6975021395297,30.2593722255952],[-97.7300477260853,30.2593722255952],[-97.7300477260853,30.297977761151]]],"spatialReference":{"wkid":4326}}]}]}&f=json
JSON Response example
{
"fieldName": "SUBTYPE",
"dashboardResults": [
{
"fieldValue": "Building",
"count": 42
},
{
"fieldValue": "Cemetery",
"count": 1
},
{
"fieldValue": "County",
"count": 1
},
{
"fieldValue": "County Boundary",
"count": 10
},
{
"fieldValue": "Gate",
"count": 1
},
{
"fieldValue": "Lake/Pond",
"count": 2
},
{
"fieldValue": "Minor Civil Division",
"count": 3
},
{
"fieldValue": "Mobile Home Park",
"count": 7
},
{
"fieldValue": "Nation",
"count": 1
},
{
"fieldValue": "Park Boundary",
"count": 2
},
{
"fieldValue": "PopulatedPlace",
"count": 2
},
{
"fieldValue": "Tower",
"count": 1
}
],
"filters": [
{
"spatialFilter":
{
"rings": [[
[-97.7300477260853,30.297977761151],[-97.6975021395297,30.297977761151],
[-97.6975021395297,30.2593722255952],[-97.7300477260853,30.2593722255952],
[-97.7300477260853,30.297977761151]
]],
"spatialReference": {"wkid": 4326}
}
}
]
}
Example 8: Use multiple filters in the filters array to return total counts of Building Subtypes with a severity of 5 or 2.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/SUBTYPE/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"SubType",fieldValue:"Building"}]},{listAttributeFilter:[{fieldName:"severity","fieldValue":[5,2]}]}]}&f=json
JSON Response example
{
"fieldName": "SUBTYPE",
"dashboardResults": [
{
"fieldValue": "Building",
"count": 266
}
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "SubType",
"fieldValue": "Building"
}
]
},
{
"listAttributeFilter": [
{
"fieldName": "severity",
"fieldValue": [
5,
2
]
}
]
}
]
}
Example 9: Use multiple filters to limit dashboard results to FEATUREOBJECTCLASS with a severity between 1 and 3 and Building SUBTYPE.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/FEATUREOBJECTCLASS/filter?filtersArray={filtersArray:[{rangeAttributeFilter:[{fieldName:"severity",fieldValue:{minFieldValue:1,maxFieldValue:3}}]},{singleAttributeFilter:[{fieldName:"subType",fieldValue:"Building"}]}]}&f=json
JSON Response example
{
"fieldName": "FEATUREOBJECTCLASS",
"dashboardResults": [
{
"fieldValue": "BuildingA",
"count": 40
}
],
"filters": [
{
"rangeAttributeFilter": [
{
"fieldName": "severity",
"fieldValue": {
"minFieldValue": 1,
"maxFieldValue": 3
}
}
]
},
{
"singleAttributeFilter": [
{
"fieldName": "subType",
"fieldValue": "Building"
}
]
}
]
}
Example 10: Use multiple filters to limit dashboard results to FEATUREOBJECTCLASS with a severity between 1 and 3 and Populated
and Mobile Home Park SUBTYPE.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/FEATUREOBJECTCLASS/filter?filtersArray={filtersArray:[{rangeAttributeFilter:[{fieldName:"severity",fieldValue:{minFieldValue:1,maxFieldValue:3}}]},{listAttributeFilter:[{fieldName:"subType",fieldValue:["PopulatedPlace","Mobile Home Park"]}]}]}&f=json
JSON Response example
{
"fieldName": "FEATUREOBJECTCLASS",
"dashboardResults": [
{
"fieldValue": "BuildingA",
"count": 40
}
],
"filters": [
{
"rangeAttributeFilter": [
{
"fieldName": "severity",
"fieldValue": {
"minFieldValue": 1,
"maxFieldValue": 3
}
}
]
},
{
"singleAttributeFilter": [
{
"fieldName": "subType",
"fieldValue": "Building"
}
]
}
]
}
Example 11: Filter reviewer
by REVIEWERCODE, a field in the REVTABLEMAIN. REVIEWERCODE is not included in the list of fields displayed by a dashboard resource.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/FEATUREOBJECTCLASS/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"REVIEWERCODE",fieldValue:3}]}]}&f=pjson
JSON Response example
{
"fieldName": "FEATUREOBJECTCLASS",
"dashboardResults": [
{
"fieldValue": "BuiltupP",
"count": 2
}
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "REVIEWERCODE",
"fieldValue": 3
}
]
}
]
}
Example 12: Filter reviewer
(BATCHJOBCHECKGROUP) by CHECKNAME, a field in the REVCHECKRUNTABLE. CHECKNAME is not included in the list of fields displayed by a dashboard resource.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/BATCHJOBCHECKGROUP/filter?filtersArray={filtersArray:[{singleAttributeFilter:[{fieldName:"CHECKNAME",fieldValue:"Unique ID Check"}]}]}&f=pjson
JSON Response example
{
"fieldName": "BATCHJOBCHECKGROUP",
"dashboardResults": [{
"fieldValue": "Attribution (Storm Sewer)",
"count": 23
}, {
"fieldValue": "Attribution (Stormwater)",
"count": 532
}, {
"fieldValue": "Attribution (Water Distribution)",
"count": 75
}],
"filters": [{
"singleAttributeFilter": [{
"fieldName": "CHECKNAME",
"fieldValue": "Unique ID Check"
}]
}]
}
Example 13: Filter reviewerResultsBy (Severity) by Review lifecycle phase.
https://localhost:6443/arcgis/rest/services/reviewer/MapServer/exts/DataReviewerServer/Dashboard/reviewerResultsBy/SEVERITY/filter?filtersArray=%7BfiltersArray%3A%5B%7BsingleAttributeFilter%3A%5B%7BfieldName%3A%22lifecyclephase%22%2CfieldValue%3A2%7D%5D%7D%5D%7D&f=pjson
JSON Response example
{
"fieldName": "SEVERITY",
"dashboardResults": [
{
"fieldValue": "1",
"count": 189
},
{
"fieldValue": "3",
"count": 200
},
{
"fieldValue": "4",
"count": 160
}
],
"filters": [
{
"singleAttributeFilter": [
{
"fieldName": "lifecyclephase",
"fieldValue": 2
}
]
}
]
}