Query infostore to loop to thru folders

[alpha621]

Hi all,

I am querying infostore to loop through a main folder in which i have sub folders inside it i have the reports

SO in my jsp i want to have sub folder names as one drop down on selecting the sub folder name i want to create another drop down with list of reports for that folder

please help me with queries

 

[hilfy]

Try this:

Select SI_ID, SI_Name
from CI_INFOOBJECTS
where SI_PARENTID = <subfolder ID>
and SI_KIND <> 'Folder'

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.