- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 06:50 AM
I want to modify the dictionary override for the cmdb_ci to not include retired CI's.
OOTB SNOW has the reference qualifier which I don't want to completely overwrite: sys_class_name!=cmdb_ci_service
To filter out retired CI's I'm using the following: javascript: 'operational_status!=6'
How can I combine these so both work effectively?
I tried javascript: 'operational_status!=6'+'sys_class_name!=cmdb_ci_service' which ended up hiding all CI's
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 06:56 AM - edited 09-10-2024 06:57 AM
You need to join them with an AND which is ^ in encoded queries like this, and you don't need to concatenate the string since you aren't breaking it for a dynamic field or variable name from the current record.
javascript: 'operational_status!=6^sys_class_name!=cmdb_ci_service'
You can test this by manually filtering a list view by these criteria then right-clicking on the last breadcrumb to copy the query, then paste it into the qualifier. You might not even need the javascript prefix in this case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 06:56 AM - edited 09-10-2024 06:57 AM
You need to join them with an AND which is ^ in encoded queries like this, and you don't need to concatenate the string since you aren't breaking it for a dynamic field or variable name from the current record.
javascript: 'operational_status!=6^sys_class_name!=cmdb_ci_service'
You can test this by manually filtering a list view by these criteria then right-clicking on the last breadcrumb to copy the query, then paste it into the qualifier. You might not even need the javascript prefix in this case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 07:07 AM
Thank you @Brad Bowman I knew I was making a simple mistake. Totally escaped my mind to just build it out with the filter conditioner. I also removed the javascript prefix as that wasn't required. Much appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-10-2024 08:21 AM
You are welcome!