Egbert, Thanks. I rebuilt resource index and now those records are shown once in iTQL as it should be. Will work with foxml of objects directly to get audit.
Serhiy On Thu, Jun 30, 2011 at 4:44 AM, Egbert Gramsbergen <e.f.gramsber...@tudelft.nl> wrote: > Hello, > > The RI index does not keep information from old versions of objects so I > would expect each object once in your iTQL result regardless the number of > audits. That is, unless there are accidentally two titles in the DC > datastream after the first correction. To do it right, you would have to do > an iTQL query to find all pid's and then extract the audit records and > datastream versions from the object xml (foxml) of each object separately. > > Egbert Gramsbergen > -----Original Message----- > From: Serhiy Polyakov [mailto:sp0...@gmail.com] > Sent: donderdag 30 juni 2011 10:04 > To: fedora-commons-users@lists.sourceforge.net > Subject: [fcrepo-user] Extracting all audit records with iTQL > > Hello, > > I am extracting basic medtadata from fedora repository with iTQL using > myhost:8080/fedora/risearch > > Here is query: > > select $identifier $title > from <#ri> > where > $obj <dc:identifier> $identifier and > $obj <dc:title> $title > > Query returns various results depending of the number of object audits. > > 1) If an object has one audit record (only ingest happened) that original > metadata version 1 is retrieved. > > 2) If an object has second audit (like title correction) that corrected > metadata version 2 is retrieved. > > 3) If an object has third audit (like title correction again) metadata > version 2 and 3 is retrieved - object is shown twice in iTQL results. > > 4) If an object has forth audit (like title correction again) metadata > version 2 and 4 is retrieved - object is shown twice in iTQL results. > > > I want to extract all history of metadata (all versions) and additionally > audit:responsibility and audit:date values. So each object would be shown as > many times as it was ingested plus modified. > > Any suggestions about to how construct the iTQL would be helpful. > > Thanks, > Serhiy > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > _______________________________________________ > Fedora-commons-users mailing list > Fedora-commons-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > _______________________________________________ > Fedora-commons-users mailing list > Fedora-commons-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/fedora-commons-users > ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Fedora-commons-users mailing list Fedora-commons-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
