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.
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.
Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.
|?||Show this help|
|ESC||Blurs the current field|
|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
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!
Tim closed this discussion on 02 Oct, 2012 03:45 PM.