Hi,
I need to obtain report with a complete list of the Communities with their
respective Handle number, and for each Community I need a list of their
Collections, with their respective Handle number, and for each Collection I
need a list of their Items, with their respective Handle number.
Ej:
Community 1, 123456789/1
- Collection 1, 123456789/3
- Item 1, 123456789/40
- Item 2, 123456789/41
- ...
- Collection 2, 123456789/4
- Item 3, 123456789/43
- Item 4, 123456789/44
- ...
- ....
Community 2, 123456789/2
- Collection 1, 123456789/10
- Item 5, 123456789/45
- Item 6, 123456789/46
- ...
- Collection 2, 123456789/11
- Item 1, 123456789/47
- Item 2, 123456789/48
- ...
- ....
I understand this is only possible with a direct Query to the database.
I've reviewed the ER database model, but I've difficulties to figure out
how to design the query. I'm not an expert and need to get this report as
soon as possible.
Can anyone help me?
Thanks in advance.
Bender
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
