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
