[Dspace-general] Order of files

[Claudia Jürgen]

Hi Richard,

if you want the bitstreams to be listed ordered by e.g. filename, you 
can change:

org.dspace.content.Bundle.java (DSpace Version 1.5.1)

replace:
// Get bitstreams
TableRowIterator tri = DatabaseManager.queryTable(
            ourContext, "bitstream",
            "SELECT bitstream.* FROM bitstream, bundle2bitstream WHERE "
            + "bundle2bitstream.bitstream_id=bitstream.bitstream_id AND "
            + "bundle2bitstream.bundle_id= ? ",
            bundleRow.getIntColumn("bundle_id"));


with
// Get bitstreams
TableRowIterator tri = DatabaseManager.queryTable(
            ourContext, "bitstream",
            "SELECT bitstream.* FROM bitstream, bundle2bitstream WHERE "
            + "bundle2bitstream.bitstream_id=bitstream.bitstream_id AND "
            + "bundle2bitstream.bundle_id= ? "
            + "ORDER BY bitstream.name ",
            bundleRow.getIntColumn("bundle_id"));

hope that helps

Claudia Jürgen

r.milne at rgu.ac.uk schrieb:
> Hello all,
> 
>  
> 
> Apologies if this question has already been asked/discussed.  When
> uploading items with multiple files (theses with pdfs as individual
> chapters, for example) we've been surprised to find that there appears
> to be no obvious logic to the order in which DSpace displays those
> files.  It doesn't quite seem to be sorted by filename, or in the
> sequence they're loaded, or anything else obvious.  This becomes
> problematic when we want to display the files in a certain order such as
> in chapter order (in the thesis example).  Am I just missing something?
> We are currently on v1.4, is this situation improved in v1.5?
> 
>  
> 
> Any advice much appreciated.
> 
>  
> 
> Best regards,
> 
>  
> 
> Richard Milne
> 
>  
> 
> Richard Milne 
> 
> E-Systems Librarian 
> 
> The Georgina Scott Sutherland Library 
> 
> The Robert Gordon University 
> 
> Garthdee Road 
> 
> Aberdeen 
> 
> Scotland 
> 
> AB10 7PA 
> 
>  
> 
> E : r.milne at rgu.ac.uk 
> 
> T : +44 (0) 1224 263656
> 
> 
> The Robert Gordon University is the best modern university in the UK
> (The Times Good University Guide 2009)
> 
> The Robert Gordon University, a Scottish charity registered under
> charity number SCO 13781.
> 
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be
> copied, disclosed to, retained or used by, any other party. If you are
> not an intended recipient then please promptly delete this e-mail and
> any attachment and all copies and inform the sender. Thank you.
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general