How to modify reference qualifier for dictionary override

BanuMahalakshmi
Tera Contributor

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.

1 ACCEPTED SOLUTION

Adrian Ubeda
Mega Sage
Mega Sage

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
If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

View solution in original post

2 REPLIES 2

Mark Manders
Mega Patron

(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

Adrian Ubeda
Mega Sage
Mega Sage

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
If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆