Thanks. But unfortunately this is not the answer i am looking for. As i said if the sales order has two projects and one of them is open then that particular sales order shouldnt show up in the results. Its not about the project not showing up, but its about the sales order. Thanks.

@Dominica Sevilla-Oracle Thanks. But its not the answer i am looking for, i want the sales order search to return sales orders with only closed projects. For eg. sales order #SO1234 will have projects #PRO789 (status:open) and #PRO456(status:closed) sales order #SO4567 has projects #PRO345 (status:closed) and…