Report on PRB with Related List for Open PTASK only
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2024 10:59 AM
Hi, I would like to search for PRB which have an open PTASK, how do I achieve the related list query? I tried a few things like the below, but am not getting the result.
Related List Conditions:
Problem Task-> Parent
or
Problem Task-> Problem
and then add a Condition like:
State is not Closed?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2024 11:23 AM
Hi @VL10,
Set Condition:
Add a condition: Problem Task.State is not Closed
This will filter Problems that have at least one related Problem Task that is not closed.
Thank you, please make helpful if you accept the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2024 12:06 PM
How do you get to the Problem Task.State if the report is running on the Problem Table?
Is it Parent.Problem Task.State, I tried that and got no results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2024 03:03 PM
Yes, your approach is correct. I managed to get it working in my instance. You can use either of the two related lists you mentioned in your initial post. The related list condition could be "State is not Closed". Another possibility is "Active is true".
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/