Is it possible to list Problem records where any attached Problem Tasks are overdue using the URL

[victor_b]

What I'm trying to do is to list Problem records where any attached Problem Tasks are overdue using only the URL. Is this possible?

This would be a very useful thing to do since it can also be applied for other kind of cross-table queries.

From what I can tell this isn't possible to do in the regular reporting section without further access and setup?

What I want would be something similar to http://MyInstance.service-now.com/nav_to.do?uri=/problem_list.do?sysparm_query=problem_task.opened_a...

[larstange · Accepted solution]

Hi

Yes you can do a query on the problem task table for overdue tasks. Once you have the tasks you also know which problem they are related to.

As an alternative you can make a database view to join the problem and the problem task tables.

But you cannot do this sort of query directly from the problem table as it is a one to many relationship.

[victor_b]

Right, thanks. I've been trying to figure out if that was possible since other things I'd want to do was to list all Problem records which doesn't have any Problem Tasks attached, for example.

[larstange]

If you make a database view between problem and problem task, and make it a "Left join" you should get a list of all problems - also the once without problem tasks. But you an still use it to find problems with overdue tasks.

[victor_b]

The problem there is that I'm just a regular user and don't have that kind of access that I know of. But then I've got it confirmed at least, thanks.