Skip to Content
0
Former Member
May 10, 2010 at 05:51 PM

query builder

116 Views

I want to add the folders each of these reports live it. for this query. Anyone have any ideas?

SELECT top 20000 SI_NAME, SI_WEBI

FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS

Where PARENTS("SI_NAME='Webi-Universe'","SI_NAME ='Data Warehouse Universe'")

and SI_NAME Not like '%_20%'