Reporting wiki space

This is a space dedicated to helping you get the most out of the data contained in your openEQUELLA institution(s).

It is intended to be the place to go to for:

• Tutorials for writing a particular query
• Help writing the most efficient query for your database and openEQUELLA instance
• Understanding the intricacies of the openEQUELLA SQL schema -  Why does the openEQUELLA schema make no sense?!
• Learn about reports that other users  have created
• Picking the right dataset type for the job

Tutorials

These tutorials are designed to be followed in order but more advanced report writers might like to skip ahead.

For simplicity all items being reported on with these tutorials will use a common reporting tutorial schema.

Querying using SQL

The SQL demonstrated in these tutorials can be used with reporting tools other than BIRT. We do specific datasource integration with BIRT but see here for alternatives to those integrations.

You can see the results of the tutorials in action on the betadev reporting institution which contains example BIRT reports containing the queries discussed in these tutorials.

Cross platform SQL

1. The basics - primary keys and UUIDs
2. Querying strings

Database specific guides

Postgres:

1. Querying with the native XML type
2. Querying repeated metadata

SQLServer:

1. Querying with the native XML type
2. Querying repeated metadata

Oracle:

1. Querying with the native XML type
2. Querying repeated metadata