...
ODBC-based reporting tools work by running one or more SQL query against the underlying DSpace database. You can find some examples in
Jira |
---|
server | DuraSpace JIRA |
---|
key | DS-1645 |
---|
|
which illustrate the kinds of SQL joins that you'll be looking at using. Note the use of item.in_archive = 't' and item.withdrawn = 'f' to check whether the item has been deleted or withdrawn respectively. A diagram of the DSpace database schema is included in the
Storage Layer section of the DSpace documentation.
The SQL itself is stored in database-specific subdirectories of https://github.com/DSpace/DSpace/tree/master/dspace/etcNote that some data (such as access stats) aren't held in the SQL database but in solr. Access details for these can be found at Solr#AccessingSolr.
...