Hi again!
Few additions to my previous message:
1) Vezhdin first name is not Vehzdin.
2) In the DDL, I forgot the SQL for the DSpace database VIEWS:
CREATE OR REPLACE VIEW community2item AS
SELECT community2collection.community_id, collection2item.item_id
FROM community2collection, collection2item
WHERE collection2item.collection_id = community2collection.collection_id;
CREATE OR REPLACE VIEW collectionitemsbydateaccession AS
SELECT collection2item.collection_id,
itemsbydateaccessioned.items_by_date_accessioned_id,
itemsbydateaccessioned.item_id, itemsbydateaccessioned.date_accessioned
FROM itemsbydateaccessioned, collection2item
WHERE itemsbydateaccessioned.item_id = collection2item.item_id;
CREATE OR REPLACE VIEW communityitemsbydateaccession AS
SELECT communities2item.community_id,
itemsbydateaccessioned.items_by_date_accessioned_id,
itemsbydateaccessioned.item_id, itemsbydateaccessioned.date_accessioned
FROM itemsbydateaccessioned, communities2item
WHERE itemsbydateaccessioned.item_id = communities2item.item_id;
Have a nice day!
Christophe
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
