Dot walking in task_sla to filter based on the requested_for company

[mallyk]

I am trying to filter catalog task sla (task_sla) records related to the requested items (sc_req_item) based on the company of the requested_for using dot walking.

Following is the sample URL query:

https://demo.service-now.com/task_sla.do?XML&sysparm_query=task.request.requested_for.company.name=a...

It is not filtering the data as expected, instead it is bringing all the records from task_sla.

Can someone suggest what is not correct in the URL query? Your help is greatly appreciated!

Thanks in advance.

-- Mallik

[Jaspal Singh]

Hi Mallikarjuna,

Is this referring to catalog task record from SLA table.

If so, then query should be sysparam_query=task.requested_item.requested_for.company.name=abc.

[mallyk]

Thank you for the reply Jaspal!

I think I have created confusion between catalog task and task sla. I have corrected it my details.

I am trying to extract the sla records of requested item based on the company of requested_for of the request.

[Rajshekhar Pau1]

Hello Mallikarjuna,

You could use the below URL for querying:

https://YOUR_INSTANCE_NAME.service-now.com/task_sla_list.do?sysparm_query=task.ref_sc_req_item.u_req...

Hope this helps.

Please hit Like or mark Helpful or Correct based on the impact.

Thanks,

Rajshekhar Paul