Need a help in Database View to show only specific records in reporting

[Upender]

Hi,

I have created a Database View on CMDB CI table and custom table. When I am try to report on the DB View, I can able to see all the records.

My requirement is to show only Specific Class records while reporting on the DB View which I have created for that I have created Business Rule on the DB View.

Sample Code:

When to Run: Before and Query

current.addQuery('sys_class_name','cmdb_ci_cluster');

current.addActiveQuery();

But this is not working. Still I can see all classes in report.

Is there is anyway to show only specific Class records in report of the DB View

Thanks in advance

Upender

[Upender · Accepted solution]

This code worked.

var qc = current.addQuery('conf_sys_class_name','cmdb_ci_lb_ace');

qc.addOrCondition('conf_sys_class_name','cmdb_ci_lb_cisco_gss');