Skip to Content
0

Query to get all active level-1 WBS

Oct 06, 2017 at 07:57 PM

44

avatar image
Former Member

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

my-query.jpg (24.0 kB)
i-nedd-this.jpg (14.7 kB)
i-nedd-this-1.jpg (19.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Raymond Giuseppi
Oct 09, 2017 at 01:26 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded