tag:help-archives.hannonhill.com,2010-02-09:/discussions/how-do-i/18904-access-content-ownershipCascade CMS: Discussion 2018-10-18T20:37:38Ztag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-04T18:11:59Z2015-08-10T14:33:24Zaccess content ownership<div><p>Hi Rob,</p>
<p>You can use a format (Velocity or XSLT) to access the database
and pull out the information from cxml_foldercontent. This does
require Java programming. Let me know if you are interested.</p>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-04T18:14:14Z2015-08-10T14:33:24Zaccess content ownership<div><p>Thanks Wing,</p>
<p>Yes, if you have an example line of code in either (or both),
that would be great. I have a few subsites that still use XSLT
formats.</p>
<p>Rob</p></div>Robtag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-04T18:21:26Z2015-08-10T14:33:24Zaccess content ownership<div><p>Rob,</p>
<p>Please check <a href="http://www.upstate.edu/cascade-admin/java/java-formats/index.php">Java
and Formats</a> and see if the discussion makes sense to you.</p>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-04T19:21:38Z2015-08-10T14:33:24Zaccess content ownership<div><p>Hi Rob,</p>
<p>In addition to Wing's suggestion, I went ahead and created a
feature request on our Idea Exchange that I encourage you to vote
on <a href="http://ideas.hannonhill.com/forums/52559-cascade-cms-ideas/suggestions/9169457-make-content-ownership-data-available-outside-of-t">
here</a>. I sent you an invite to that forum so let me know if you
have any trouble logging in.</p>
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-04T21:19:22Z2015-08-10T14:33:23Zaccess content ownership<div><p>Thanks Tim and Wing for the help.</p>
<p>I was hoping that this could be accessed in the same way that
other system metadata is.</p>
<p>Velocity example:<br>
$currentPage.metadata.author</p>
<p>XSLT example:<br></p>
<p>The above will return the author fields, but I can't see a
similar field for the new content owner. I've used web services to
spit out all the data (and metadata) associated with a Page and
Folder, but there isn't an object for this new field.</p>
<p>Wing, I had a look through your extensive documentation (good
job). I'm not sure it'll be useful to me as the direct database
queries are reliant on your local java classes. Thanks though for
the info.</p></div>Robtag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-05T14:41:12Z2015-08-10T14:33:23Zaccess content ownership<div><p>Rob,</p>
<p>Yes, this approach requires local Java classes, as I pointed
out. But these classes are extremely simple and easy to handle.
Starting something like this for a single table will be an
overkill. But once a database connection has been established, you
can retrieve anything you want. Besides data retrieval, I can also
use formats to modify assets, to invoke web service scripts, and to
send emails.</p>
<p>Last year I built a very powerful PHP web service API. But the
owner information is not available to web services, as you pointed
out. I see the Java component as an important complement to web
services; that is, to do what web services cannot. And direct
access to the database is a lot faster than web services.</p>
<p>Wing</p></div>Wing Ming Chantag:help-archives.hannonhill.com,2010-02-09:Comment/375650632015-08-07T22:08:41Z2015-08-10T14:33:23Zaccess content ownership<div><p>Thanks again Wing. I’m not an administrator of our cascade
implementation so won’t be leading a home build API, but
I’m grateful for your thoughts (and incredible
documentation).</p>
<p>Robert Blizzard<br>
Web Designer/Analyst<br>
SOS - Student and Enrolment Services Division<br>
University of Saskatchewan<br>
Ph: (306) 966.7595</p></div>Blizzard, Robert