To which integration/function area is this feature request related? General Discussion
Summary: Implement “NOT Any” Style Group Comparator for Widget Filtering
Description: I would like to see a comparator that allows for group negation comparison. This can be done currently by subtracting the total of some dataset by the filtered ANY count, but this does not work for drilling down.
Given the following dataset, I would like to return only the device(s) that do NOT have an entry for BitDefender. In this case, I would expect a return of the columns for PC3 and PC4 only.
SELECT DISTINCT id, friendly_name, GROUP_CONCAT(software) AS SoftwareList FROM software_table GROUP BY id HAVING SoftwareList NOT LIKE '%BitDefender%'
Why: Being able to filter based on what is "missing" from a table should be just as important as what is not "missing".