Hernan,
If ordering is of interest, that is certainly an acceptable solution.
Cheers,
Mark
On Tue, Oct 7, 2014 at 10:20 AM, Hernan Carvajal Briceño <
hernan.hcarva...@gmail.com> wrote:
> 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
>
--
[image: @mire Inc.]
*Mark Diggory*
*2888 Loker Avenue East, Suite 315, Carlsbad, CA. 92010*
*Esperantolaan 4, Heverlee 3001, Belgium*
http://www.atmire.com
------------------------------------------------------------------------------
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
