View on GitHub

openEQUELLA

A digital repository providing a single platform to house your teaching and learning, research, media, and library content.

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

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