Skip to Content
avatar image
Former Member

Query to get all active level-1 WBS

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 09, 2017 at 01:26 PM

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

    Add comment
    10|10000 characters needed characters exceeded