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]

Hi Laurent,

Thanks for your reply it worked.

Now I tried to add more classes' in Business Rule, its not working. I can see all classes' records in report.

var gr = new GlideRecord(u_cmdb_ci);     // DB View Name

var qc = gr.addQuery('conf_sys_class_name','cmdb_ci_cluster');

qc.addorcondition('conf_sys_class_name','cmdb_ci_esx_resource_pool');

qc.addorcondition('conf_sys_class_name','cmdb_ci_lb_ace');

gr.addActiveQuery();

Regards,

Upender

[LaurentChicoine]

The functions are case sensitive, you need to use "addOrCondition" and not "addorcondition"

[Upender]

I tried its not working.

[LaurentChicoine]

You can try to disable the query rule and open the database view without query rule. Then build the filter you want, test it and do a right click on the blue link filter and click on Copy query. You can then use that query in your script using current.addEncodedQuery('copied_query').

[Upender]

Hi Laurent,

It didn't worked.

Regards,
Upender