Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Query to get all active level-1 WBS

Former Member
0 Kudos
123

Hi,

I need to get all active level-1 WBS. do we have any std code/program?

i have query but that doesn't get me what i want. can somebody help me with this thx!

this is my query

but doesn't get me correct WBS.

i have below requirement. one WBS should satisfy all below condition to qualify as ACT WBS.

Thx!

Prema

1 REPLY 1

raymond_giuseppi
Active Contributor
0 Kudos
38

Use some subquery: In a WHERE NOT EXISTS clause select invalid records, records for your status values list where INACT = space