Hi all.
First of all, thanks for your help and advice.
As Mark said, it would be helpful, in some cases, know the creation/update
data of a bitstream.
In our case, the goal was to know the order in which the bitstreams were
uploaded to the database.
To know the exact date of creation was not an imperative. So we used the
following SQL query:
SELECT bitstream_id, name, size_bytes, source FROM bitstream ORDER BY
bitstream_id ASC
Saludos cordiales,
Hernán Carvajal
Director de Tecnología, Prodigio Consultores
Oficina: 02-5549849 / Celular: 88370295
www.prodigioconsultores.com
2014-10-01 3:54 GMT-03:00 Hilton Gibson <hilton.gib...@gmail.com>:
> Hi Bender
>
> Perhaps this will help:
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips
>
> Cheers
>
> hg
>
>
> *Hilton Gibson*
> Ubuntu Linux Systems Administrator
> JS Gericke Library
> Room 1025C
> Stellenbosch University
> Private Bag X5036
> Stellenbosch
> 7599
> South Africa
>
> Tel: +27 21 808 4100 | Cell: +27 84 646 4758
>
> On 30 September 2014 23:33, Keir Vaughan-Taylor <kei...@optusnet.com.au>
> wrote:
>
>> If by bitstream you mean the actual data files e.g. "publication.pdf"
>> You can just use the Unix command find on the assetstore
>>
>> find ./assetstore -type f |xargs ls -ls
>>
>> Although the asset store has the actual files and the date of creation
>> the file name is an internal ID. Did you want filenames as well?
>>
>>
>>
>>
>> On Tue, 2014-09-30 at 10:17 -0300, bender wrote:
>> > Hi.
>> >
>> >
>> > We need to obtain a list of all bitstreams ordered by the date the
>> > were uploaded.
>> >
>> >
>> > Is it possible? Can anyone help me with the query?
>> >
>> >
>> > Thanks in advance
>> >
>> >
>> > bender
>> >
>> >
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>> > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
>> > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>> > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>> >
>> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
>> > _______________________________________________ DSpace-tech mailing
>> list DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette:
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
>> _______________________________________________
>> DSpace-tech mailing list
>> DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>> List Etiquette:
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
