Hi,
I have an ITQL issue that someone might be able to help me with. I'm running a
query like this:
select $obj $memberTitle $modified from <#ri>
where $obj <fedora-model:hasModel> <info:fedora/dris:folder=775>
and $obj <fedora-view:lastModifiedDate> $modified
and $obj <dc:title> $memberTitle
order by $obj
This returns results like this:
"obj","memberTitle","modified"
info:fedora/dris:OLS-CARI-ROB_0000,,2011-06-30T18:57:17.987Z
info:fedora/dris:OLS-CARI-ROB_0001,Reformation or the Wonderful Effects of
Proclamation!!!,2011-06-30T18:57:20.844Z
info:fedora/dris:OLS-CARI-ROB_0002,End of the Irish Invasion:_or_The
Destruction of the French Armada,2011-06-30T18:57:23.692Z
info:fedora/dris:OLS-CARI-ROB_0003,Revenue Officers nabbing a
smuggler,2011-06-30T18:57:26.596Z
info:fedora/dris:OLS-CARI-ROB_0004,Pity the Sorrows of a poor old
man,2011-06-30T18:57:29.536Z
info:fedora/dris:OLS-CARI-ROB_0005,The Irish Howl or the Catholics in
Fitz!,2011-06-30T18:57:32.4Z
....
....
However, I would like to get a counter to indicate the row number so that the
results would look something like this:
"obj","memberTitle","modified","rowcounter"
info:fedora/dris:OLS-CARI-ROB_0000,,2011-06-30T18:57:17.987Z, 0
info:fedora/dris:OLS-CARI-ROB_0001,Reformation or the Wonderful Effects of
Proclamation!!!,2011-06-30T18:57:20.844Z, 1
info:fedora/dris:OLS-CARI-ROB_0002,End of the Irish Invasion:_or_The
Destruction of the French Armada,2011-06-30T18:57:23.692Z, 2
info:fedora/dris:OLS-CARI-ROB_0003,Revenue Officers nabbing a
smuggler,2011-06-30T18:57:26.596Z, 3
info:fedora/dris:OLS-CARI-ROB_0004,Pity the Sorrows of a poor old
man,2011-06-30T18:57:29.536Z, 4
info:fedora/dris:OLS-CARI-ROB_0005,The Irish Howl or the Catholics in
Fitz!,2011-06-30T18:57:32.4Z, 5
Basically, I'd like to achieve something like this. Does anybody how this might
be done in ITQL? (or SparQL)
Stephen.
------------------------------------------------------------------------------
Got Input? Slashdot Needs You.
Take our quick survey online. Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Fedora-commons-users mailing list
Fedora-commons-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
