tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/15106-create-a-report-what-groups-have-access-to-each-folder-in-a-site-recursivelyCascade CMS: Discussion 2018-10-18T20:37:23Ztag:help-archives.hannonhill.com,2010-02-09:Comment/353552232014-11-22T18:01:18Z2014-11-22T18:01:18ZCreate a report: What groups have access to each folder in a site, recursively<div><p>Hi Mark,</p>
<p>I can think of two, maybe three, different ways to do this:</p>
<ol>
<li>
<p>I built a PHP web service code library. I can use this library,
specially <code>AssetTree::traverse</code>, to visit a site and get
the access information. The <code>traverse</code> method is
recursive.</p>
</li>
<li>
<p>Lately, I have developed a way to use Velocity to query the
Cascade database directly. Since any data can be pulled out from
the database, I just need to figure out which tables contain the
information I want. I must build Java classes to do this.</p>
</li>
<li>
<p>Similar to the second way, I can write a program, using PHP or
Java, to query the database directly.</p>
</li>
</ol>
<p>For more information:</p>
<ol>
<li>
<p><a href=
"http://www.upstate.edu/cascade-admin/projects/web-services/oop/classes/asset-tree/index.php">
AssetTree</a></p>
</li>
<li>
<p><a href=
"http://www.upstate.edu/cascade-admin/projects/web-services/oop/classes/property-classes/access-rights-information.php">
AccessRightsInformation</a></p>
</li>
<li>
<p><a href=
"http://www.upstate.edu/cascade-admin/projects/web-services/oop/generating-reports/index.php">
Generating Reports</a></p>
</li>
<li>
<p><a href=
"http://www.upstate.edu/cascade-admin/programming-formats/velocity/java-programming/index.php">
Java Programming in Velocity</a></p>
</li>
</ol>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/353552232014-11-26T22:49:30Z2014-11-26T22:49:30ZCreate a report: What groups have access to each folder in a site, recursively<div><p>Thanks a bunch, Wing -- I used your excellent code library to
produce the report I needed.</p></div>markv