Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Query to get all active level-1 WBS

Former Member

‎2017 Oct 06 8:57 PM

0 Kudos
360

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

Preview file
24 KB
Preview file
15 KB
Preview file
20 KB
1 REPLY 1
Read only

RaymondGiuseppi
Active Contributor

‎2017 Oct 09 2:26 PM

0 Kudos
275

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