How to use the Query in the Reporting in the servicenow

[kirankumarboyin]

Hi Team,

             I am trying to build the report on incident metric table by including the query option as follows.

1. I want to execute query1 includes having some filters.

2. With the response of the query1, I want to execute the query 2 .

My question is can we use the queries like some thing as below.

query 1 as below

Var test=new GlideRecord('incident_metric');

test.addQuery('');test.addQuery('');test.query('');

query 2 as below.

Take the inputs from the above

Var test1=new GlideRecord('incident_metric');

test1.addQuery('abc', test.field_value);test1.addQuery('');test1.query('');

Regards,

Kiran

[Alberto Consonn]

Hi,

check here:

https://community.servicenow.com/community?id=community_blog&sys_id=bd0eaa2ddbd0dbc01dcaf3231f96199e

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Alberto Consonn]

Any update on this?

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto