Cascade Server Schema Diagram
I posted the following in regard to obtaining a CS schema diagram in March 2011 and never received any feedback. I'm going to proceed with creating my own diagram. We are currently at v6.8 in prod. If you would like a copy of the diagram when I'm done, just let me know and I'll post it.
March 2011:
Our users have a need to view users, groups, and roles data in
report format to assist with a rather large project they are
working on in Cascade Server. This data is not reported within the
tool in a format that is useful to the project team. We would like
to create the reports ourselves through queries against the Cascade
Server database. Two questions:
1) Are there plans to provide reporting for Cascade Server?
2) In the interim, can you provide us with a copy of the Cascade Server schema? We are currently at version 6.7.6.
Thank you.
Discussions are closed to public comments.
If you need help with Cascade CMS please
start a new discussion.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by Charlie Holder on 15 Mar, 2012 12:25 AM
I've been visiting some older posts and saw this one. I do apologize that it was overlooked.
You're looking for the database schema correct? Not a Cascade Entity Relationship diagram of some kind? There are some example reports in the Default Database. In the example.com Site there is a folder called
_reportsthat does some generic reporting for stale content and pages without certain fields filled in. Does that help at all?Integrating reports into Cascade Server is on our radar.
I will certainly ask.
2 Posted by Charlie Holder on 15 Mar, 2012 03:55 PM
Update:
We don't provide the schema or an explanation of it publicly.
I would always encourage you to use the Web Services API to programmatically access/manipulate data in Cascade. However, in this case, if you let me know what information you're interested in, it might be a few relatively simple SQL queries. It will probably easier to assist with that if possible then spend time spinning wheels.
3 Posted by Charlie Holder on 03 Apr, 2012 07:42 PM
Hi rvaldez --
Just wanted to check-in to see if you found my comments helpful.
Let me know!
Thanks.
Tim closed this discussion on 02 Oct, 2012 03:45 PM.