Database View report – Handling Short Description conditions across multiple sc_task records

[dd31]

Hi team,

Report on RITM where one task (Short Description starts with X) is Closed Complete and another task (Short Description starts with Y) is not Closed Complete

I have a requirement to create a report where:

• A RITM has one Catalog Task whose Short Description STARTS WITH "Core" and is Closed Complete

• And another Catalog Task whose Short Description STARTS WITH "Approval" and is NOT Closed Complete

Both tasks belong to the same RITM.

So far, I have created a Database View and joined:

• sc_req_item 

• sc_task

However, I’m not sure how to correctly handle the Short Description condition.

[Ankur Bawiskar]

@dd31 

you can configure the filter condition once the database view runs using Try it

what you tried?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[dd31]

@Ankur Bawiskar 

I did try applying the filter conditions using “Try It” on the Database View. However, since the view joins sc_req_item with sc_task only once, the filter evaluates per task row.

The requirement needs two different task records under the same RITM to satisfy different conditions, which cannot be achieved with a single join.