In Dspace 1.5.2, anyway, the sql for listing communities is in the class 
org.dspace.content.Community; search for "ORDER BY". There are four pertinent 
sql statements, returning lists of all communities, top-level communities, 
sub-communities and collections within communities. There's a statement in 
org.dspace.content.Collection that returns a list of all collections. You 
should be able to do overlays of these classes that change the ordering; but I 
haven't tried it and don't know if there are any gotchas lurking in the wings. 



Bill Anderson 
Software Developer 
Digital Library Development 
Georgia Tech Library 

----- "Andrew Marlow" <[email protected]> wrote: 
| 
| On Fri, Jun 12, 2009 at 2:49 PM, gathub < [email protected] > wrote: 
| 


| Right now, all the communities and collections are listed alphabetically when 
| displayed. My managers are looking to give a specific order to the 
| collections; maybe ordering them by their ID number or time created. I have 
| not been able to find any way to modify the SQL statements, however. 
| 
| Does anyone know where I might be able to find the code containing the SQL 
| statements so I could make this change? Thanks 

| I don't know, but I would like to make a related comment. In another digital 
library system I am working on the ordering id comes across in the metadata. 
This is how we order the articles within an issue. So if you could add this to 
the metadata by extending your schema you might be able to do the sort yourself 
(I'm not sure how easy/difficult that would be to do). 
| -- 
| Regards, 
| 
| Andrew M. 
| http://www.andrewpetermarlow.co.uk 
| 
| 
| 
------------------------------------------------------------------------------ 
Crystal Reports - New Free Runtime and 30 Day Trial Check out the new 
simplified licensing option that enables unlimited royalty-free distribution of 
the report engine for externally facing server and web deployment. 
http://p.sf.net/sfu/businessobjects 
| _______________________________________________ DSpace-tech mailing list 
[email protected] 
https://lists.sourceforge.net/lists/listinfo/dspace-tech 
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to