Find file path name from InfoObject

[sasa888]

Hi all, need your helps. I need to see all of the folders that is being set up in the CE using the Query Builder. I tried to do 'select * from ci_infoobjects where si_progid = 'CrystalEnterprise.Folder'' but it didn't return all of the folders that I have in CE. Please help.

 

[mdwyer]

Try WHERE SI_PROGID in ('CrystalEnterprise.FavoritesFolder', 'CrystalEnterprise.Folder')

 

[sasa888]

Thanks mdwyer. I ran the query again using the where clause you provided above, but the missing folders are still out there. Please help.

 

[mdwyer]

I'm using CE9, so your mileage may vary if you have CE10. It may be overkill, but try this query:

SELECT si_progid FROM CI_INFOOBJECTS where si_progid not in ('CrystalEnterprise.Report', 'CrystalEnterprise.Folder', 'CrystalEnterprise.FavoritesFolder')

This should give you any other progid's I'm not familiar with.

Here's another thought: Are you running the query as a user who has access to those folders? Without the right privileges, you may not be able to see them. I always run the query builder as Administrator.