Hi all, In my brief look at the Matterhorn db schema, both 1.3.x and trunk, it seems there's no way to associate a mediapackage ID with a series.
For example, I would like to be able to answer the question: "how many different series have been accessed (i.e. videos from those series have been played) in the last 24 hours", and it seems there is no way to do that in SQL. If I'm correct (and the mediapackage:series mapping is only accessible via the solr index), is there a plan to add a mediapackage:series table in the db, or should user_action contain a seriesid field as well as a mediapackageid field? Related question: is it possible to change the series of a mediapackage after it's been published? Regards Stephen Stephen Marquard, Learning Technologies Co-ordinator Centre for Educational Technology, University of Cape Town http://www.cet.uct.ac.za Email/IM/XMPP: [email protected] Phone: +27-21-650-5037 Cell: +27-83-500-5290 ### UNIVERSITY OF CAPE TOWN This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity. ### _______________________________________________ Matterhorn mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn To unsubscribe please email [email protected] _______________________________________________
