http://localhost/ticket/1546 <p> metadata_created seems to be returning the date of the earliest revision (for all packages), rather than the earliest revision for a specific package. </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/1546 Trac 0.12.3 johnglover Tue, 13 Dec 2011 11:23:44 GMT http://localhost/ticket/1546#comment:1 http://localhost/ticket/1546#comment:1 <ul> <li><strong>status</strong> changed from <em>new</em> to <em>closed</em> </li> <li><strong>resolution</strong> set to <em>fixed</em> </li> </ul> <p> Fixed: <a class="ext-link" href="https://github.com/okfn/ckan/commit/fbaf4459b7da95c1db0ade165ea09720539c2f80"><span class="icon">​</span>https://github.com/okfn/ckan/commit/fbaf4459b7da95c1db0ade165ea09720539c2f80</a> </p> Ticket dread Thu, 15 Dec 2011 15:24:49 GMT http://localhost/ticket/1546#comment:2 http://localhost/ticket/1546#comment:2 <p> It looks like Rufus forgot the second bit of the AND clause: </p> <pre class="wiki"> and_(model.revision_table.c.id==model.package_revision_table.c.revision_id, + model.package_revision_table.c.continuity_id==self.id) ) </pre><p> Unfortunately John's fix breaks the <a class="closed ticket" href="http://localhost/ticket/191" title="enhancement: Searching by modification date (closed: fixed)">#191</a> fix. I'm reopening that to fix it there. </p> Ticket dread Thu, 15 Dec 2011 17:26:54 GMT http://localhost/ticket/1546#comment:3 http://localhost/ticket/1546#comment:3 <p> The fix for the break related to 191 is checked in here: [release-v1.5.1c 2c595ae] and cherry picked to [origin/defect-191-modification-date f98a4b2] </p> Ticket dread Fri, 16 Dec 2011 11:19:56 GMT http://localhost/ticket/1546#comment:4 http://localhost/ticket/1546#comment:4 <p> Broken since introduction in CKAN 1.3. Fixed in CKAN 1.5.1. </p> Ticket