How to create a report listing all Problem records without any Problem Tasks attached

[victor_b]

Like the title says. I'm a Problem Manager with access to the Problem table and the Problem Tasks table and such, and want to create a report Problem records without any problem Tasks attached.

Is this possible within reporting? I can't seem to find any flags within the Problem records themselves referencing the existence of Problem Tasks attached.

[Ulrich Jugl]

I think there is nothing OOTB which supports what you are searching for. I propose your admins create a new field on the Problem table called "Tasks related" and a Business Rule, which increases this counting field, whenever a new Problem task is added or removed (problem_task.problem changes()). You could even think of making this more broadly available to the general Task table, but then you have to remember how the different records are linked with each other (field Parent, or Problem, or ...)

[victor_b]

I don't really have any access to database reporting, only the built-in reporting in snow. Checking with the admins to add another field Might be possible, but not certain.

But from my experimentation, this, and the other answer I gather that it really isn't possible to do this?

[sushant007]

this can be done by creating a database view on problem and problem task table.

your query part in each table will play important role here:

you have to consider all problem tickets which are not present as parent for any problem task.

output will be a list and hope that will suffice else you can create report on the new database view.

[Ulrich Jugl]

Sushant, good idea, but both the database view and the field I have proposed require an admin to implement something. I see some advantage with both approaches, but like the fact to see a counter field on the problem for this scenario (e.g. if the question comes up if there are problems with > 10 problem tasks).