Accepted Solutions
Thanks Daniel, that pretty much sums it up, (included a picture of the checkboxes I'm using to drive the filter) three categories across the top and 100 or so different indications. When you check/uncheck one of the 3 boxes across the top I filter the sites shown using Layer.definitionExpression. All this works well, but I'm trying to get a new count of how many sites perform that "Indication" to update the labels, for example: as you can see in the image there is 1 site that does "Acute Kidney Injury", if that site only happens to be "Pre-Clinical" and I deselect "Pre-Clinical" then after the filter runs I want to show (0) next to the label instead of (1)
As I said, normally I'd just query the database directly and build an array of these to easily change the values as checkboxes are changed, no way to do this in ArcGIS that I have found (I could definitely be missing something though)
SELECT COUNT(column_name)
FROM table_name
WHERE condition;
Here is the uniqueValues code used to build the checkboxes and initially come up with the total.
uniqueValues({
layer: conditionLayer,
field: "Indication",
view: map
}).then(function (response) {
// prints each unique value and the count of features containing that value
this.infos = response.uniqueValueInfos;
$.each(this.infos, function () {
var currentValue = this.value;
$("#feature-node").append('<input type="checkbox" id="' + currentValue +'" name="checkbox" checked="true" value="'+ currentValue + '" onClick="filter()">').append('<label for="' + currentValue +'"">' + currentValue + ' (' + this.count + ')</label></div><BR>');
});
});