Search
for approved and in progress work orders
for an individual by labor |
istask = 0 and ((status in (select value from synonymdomain where
(domainid='WOSTATUS') and maxvalue in('APPR','INPRG')) and (exists
(select 1 from assignment where (laborcode = :USER) and (exists
(select 1 from workorder yy where ((yy.istask = 1 and yy.parent =
workorder.wonum) or (istask = 0 and yy.wonum = workorder.wonum))
and assignment.wonum = yy.wonum and yy.siteid = workorder.siteid)
and siteid = workorder.siteid)))))
|
Search for approved and in progress work orders
for an individual by crew |
istask = 0 and ((status in (select value from synonymdomain where
(domainid='WOSTATUS') and maxvalue in('APPR','INPRG')) and (exists
(select 1 from assignment where (amcrew in (select amcrew from
amcrewlabor where laborcode= :USER)) and (exists (select 1 from
workorder yy where ((yy.istask = 1 and yy.parent = workorder.wonum )
or (istask = 0 and yy.wonum = workorder.wonum)) and assignment.wonum
= yy.wonum and yy.siteid = workorder.siteid) and siteid =
workorder.siteid)))))
|
Search
for approved and in progress work orders
for an individual by labor or crew |
istask = 0 and ((status in (select value from synonymdomain where
(domainid='WOSTATUS') and maxvalue in('APPR','INPRG')) and (exists
(select 1 from assignment where ((amcrew in (select amcrew from
amcrewlabor where laborcode= :USER)) or (laborcode = :USER)) and
(exists (select 1 from workorder yy where ((yy.istask = 1 and
yy.parent = workorder.wonum ) or (istask = 0 and yy.wonum =
workorder.wonum)) and assignment.wonum = yy.wonum and yy.siteid =
workorder.siteid) and siteid = workorder.siteid)))))
|
Search for approved, in progress,
and complete
work orders for a supervisor by labor |
istask = 0 and ((status in (select value from synonymdomain where
(domainid='WOSTATUS') and maxvalue in ('APPR','INPRG',’COMP’)) and
(exists (select 1 from assignment where (laborcode in(select
personid from personancestor where hierarchylevels>0 and ancestor =
:USER ) and (exists (select 1 from workorder yy where ((yy.istask =
1 and yy.parent = workorder.wonum ) or (istask = 0 and yy.wonum =
workorder.wonum)) and assignment.wonum = yy.wonum and yy.siteid =
workorder.siteid) and siteid = workorder.siteid))))))
|
Search for approved and in progress
work orders
for a supervisor by crew |
istask = 0 and ((status in (select value from synonymdomain where
(domainid='WOSTATUS') and maxvalue in ('APPR','INPRG')) and (exists
(select 1 from assignment where (amcrew in (select amcrew from
amcrewlabor where laborcode in(select personid from personancestor
where hierarchylevels>0 and ancestor = :USER )) and (exists (select
1 from workorder yy where ((yy.istask = 1 and yy.parent =
workorder.wonum ) or (istask = 0 and yy.wonum = workorder.wonum))
and assignment.wonum = yy.wonum and yy.siteid = workorder.siteid)
and siteid = workorder.siteid))))))
|
Search for approved and in progress work orders
for a supervisor by labor or crew |
istask = 0 and ((status in (select value from synonymdomain where
(domainid='WOSTATUS') and maxvalue in ('APPR','INPRG')) and (exists
(select 1 from assignment where ((amcrew in (select amcrew from
amcrewlabor where laborcode in(select personid from personancestor
where hierarchylevels>0 and ancestor = :USER )) or laborcode in
(select personid from personancestor where hierarchylevels>0 and
ancestor = :USER )) and (exists (select 1 from workorder yy where
((yy.istask = 1 and yy.parent = workorder.wonum ) or (istask = 0
and yy.wonum = workorder.wonum)) and assignment.wonum = yy.wonum
and yy.siteid = workorder.siteid) and siteid = workorder.siteid))))))
|