Creating Custom Reports

From ResourceSpace Documentation Wiki

New reports can be created in System Setup. The report is simply a SQL query - those with knowledge of SQL should be able to write new reports given an understanding of the ResourceSpace database.

Example: Create report for pending submissions

To create a report for pending submission you need:

select * from resource where archive=-2;