- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2024 05:28 AM
Hi,
Please assist to modify the reference qualifier for dictionary override for change_request table, on the cmdb_ci column.
- Change group is not empty and CI class is “DataBase” and install status = Installed and Operational status != retired
--- or ---
- Change group is not empty and CI class != “DataBase” and Operational status != retired
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2024 05:38 AM
Hello,
Include the query inside the reference qualifier, build the query with breadcrumbs. Try this:
assignment_groupISNOTEMPTY^sys_class_name=cmdb_ci_database^install_status=1^operational_status!=6^NQassignment_groupISNOTEMPTY^sys_class_name!=cmdb_ci_database^operational_status!=6
☆ Community Rising Star 22, 23 & 24 ☆
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2024 05:32 AM
(change_groupISNOTEMPTY^class.name=cmdb_ci_database^install_status=1^operational_status!=7)OR(change_groupISNOTEMPTY^class.name!=cmdb_ci_database^operational_status!=7)
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2024 05:38 AM
Hello,
Include the query inside the reference qualifier, build the query with breadcrumbs. Try this:
assignment_groupISNOTEMPTY^sys_class_name=cmdb_ci_database^install_status=1^operational_status!=6^NQassignment_groupISNOTEMPTY^sys_class_name!=cmdb_ci_database^operational_status!=6
☆ Community Rising Star 22, 23 & 24 ☆