MAM 7.6.1.2:
Scenario:
A user has filtered for some WOs in the WOTRACK list view. Some of the WOs are parent WOs, so the user wants to select any children of the WOs too.
I don't think there is an OOB way to "select the child WOs too" in WOTRACK. Would it be possible to add a YORN field or a button to the Advanced Search to "Include children of selected WOs" ?
The SQL behind the functionality could look like this:
exists (select wonum from woancestor where ancestor in (select wonum from workorder where
classstructureid = '60720'
and status = 'APPR'
) and wonum=workorder.wonum)
That SQL works, but only admins would be proficient enough with SQL to include that outer query around the base query in the WHERE clause. It wouldn't be realistic to get regular users to do that. And saving queries or reports isn't what we want. We want users to be able to perform ad-hoc filtering via the Advanced Search, using whatever logic they need, and then be able to query for "child WOs too".
Is it possible to do that in the Advanced Search? In other words, can we automatically wrap the Advanced Search query in an outer query?
Thanks.
#Administration------------------------------
User 1972
------------------------------