related list not filtering

[El Cuchi]

Hi All,

I hope everything is ok at your end.

Situation

I created a related list between "business application" and "Catalog Tasks" (dont want to use the OOB one).

Relationship details:

Applies to table = cmdb_ci_business_app

Queries from: sc_task

Query:  "current.addQuery('cmdb_ci', parent.sys_id);

this works fine. However, i would like to add one more filter and i dont know how to do it.

I would like to also filter where the catalog task is for a specific "item" (service catalog item)/

how do i do that?

regards

[Dr Atul G- LNG]

Hi @El Cuchi 

Try this way

var orQuery = glideRecord.addQuery('risk', 1);
orQuery.addOrCondition('risk', 2);

https://www.servicenow.com/community/itsm-forum/finding-union-of-two-queries-query-business-rule/m-p...

[KrishnaKamal]

Hey! Try this. 

You can add multiple filters using 'addQuery' or 'addOrCondition'

var getTasks  = current.addQuery('cmdb_ci', parent.sys_id);
getTasks.addQuery('request_item.cat_item', 'SYSID_OF_YOUR_ITEM'); //catalog item name is on the request_item table

//if you want to use OR condition
var getTasks  = current.addQuery('cmdb_ci', parent.sys_id);
getTasks.addOrCondition('request_item.cat_item', 'SYSID_OF_YOUR_ITEM'); 

[-O-]

current.addQuery (assuming current is an instance of GlideRecord) returns an object of "type" GlideQueryCondition.

So variable getTasks is an instance of GlideQueryCondition.

But instances of GlideQueryCondition have no addQuery method.

Instances of GlideQueryCondition have only two methods: addCondition and addOrCondition (as @Dr Atul G- LNG too suggested).

But no addQuery.

Thus your suggestion:

getTasks.addQuery('request_item.cat_item', 'SYSID_OF_YOUR_ITEM');

will not work.

[-O-]

You can call current's addQuery method multiple time:

current.addQuery('cmdb_ci', parent.sys_id);
current.addQuery('request_item.cat_item', '<sys_id of the desired Catalog Item>');