Hi All,
I would like some help on interactive filters. Specifically, I'm trying to get a true/ false filter relating to a referenced field:
I have a report showing Vulnerable Items, I want to be able to filter these Items based on whether the CI is 'internet facing'. This is a checkbox filed in the cmdb_ci which is referenced on the sn_vul_vulnerable_item table.
I find it strange that for interactive filters based on 'boolean', I'm not able to create the 'Interactive Filter References' like with the other types of filters
Any Advice would be greatly appreciated!
Thanks in advance!
Greg
Hi,
The solution I found was to code the boolean field value, using sn utils.
By double clicking on the 'field' field I was able to insert the query manually, rather than having to select from the list:
Hi Greg,
Field internet_facing is not in cmdb_ci, but rather on the extension cmdb_ci_hardware, so make sure your interactive filter is using such extension.
I just tested it with extension cmdb_ci_server and it works well.
Here in a dashboard:
In testing this on my PDI, I found a small glitch in the content of the internet_facing field on my OOTB CIs. They are showing "false" but the internal value is Null, instead of 0. Make sure your CIs have a value of 0 for the false ones, else your interactive filter will return nothing for the false value.
Also, make sure your reports on the dashboard are set to react to interactive filter in editing the widget for:
but you may already know this.
Good luck.
Hi,
The solution I found was to code the boolean field value, using sn utils.
By double clicking on the 'field' field I was able to insert the query manually, rather than having to select from the list:
