http://localhost/ticket/2877 <p> In progress </p> <ol><li><del>[major] q does not seem to work reliably. e.g. using the setup from this gist <a class="ext-link" href="https://gist.github.com/1930806"><span class="icon">​</span>https://gist.github.com/1930806</a> and doing a ?q=DE yields no results (does not work with "q=de" either)</del> <ul><li><del>q=second does work ...</del> </li></ul></li><li>[major] q does not work with 2 values (see below) </li><li>Query on search with limit 0 results in total of 0 (should either be null or correct total). Queries with other limits yield correct total AFAICT <ul><li>Also weird fact that limit is returned but as as as string - should it not be an integer </li></ul></li><li>Types on fields: could these not be canonical and as per recline (or is it important to allow exact sql types ...) </li></ol><h3 id="Multiplequeryvalues">Multiple query values</h3> <p> Try a query such as: "second UK" and you will get 500 error: </p> <p> <a class="ext-link" href="http://localhost:5000/api/3/action/datastore_search?resource_id=4f1299ab-a100-4e5f-ba81-e6d234a2f3bd&amp;q=second%20UK"><span class="icon">​</span>http://localhost:5000/api/3/action/datastore_search?resource_id=4f1299ab-a100-4e5f-ba81-e6d234a2f3bd&amp;q=second%20UK</a> </p> <pre class="wiki">ProgrammingError: (ProgrammingError) syntax error in tsquery: "second UK" 'select "_id", "id", "date", "x", "y", "z", "country", "title", "lat", "lon", count(*) over() as "_full_count"\n from "4f1299ab-a100-4e5f-ba81-e6d234a2f3bd" where _full_text @@ to_tsquery(%s) limit 100 offset 0' (u'second UK',) </pre><h3 id="Suggestions">Suggestions</h3> <p> Filter support: should think in more detail about this (may want to follow recline style) </p> <p> Simple filters in query parameters would be nice too ... </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/2877 Trac 0.12.3 rgrp Sat, 18 Aug 2012 01:09:32 GMT http://localhost/ticket/2877#comment:1 http://localhost/ticket/2877#comment:1 <ul> <li><strong>description</strong> modified (<a href="/ticket/2877?action=diff&amp;version=1">diff</a>) </li> </ul> Ticket kindly Wed, 22 Aug 2012 01:26:24 GMT http://localhost/ticket/2877#comment:2 http://localhost/ticket/2877#comment:2 <ul> <li><strong>description</strong> modified (<a href="/ticket/2877?action=diff&amp;version=2">diff</a>) </li> </ul> Ticket kindly Wed, 22 Aug 2012 01:27:13 GMT http://localhost/ticket/2877#comment:3 http://localhost/ticket/2877#comment:3 <ul> <li><strong>description</strong> modified (<a href="/ticket/2877?action=diff&amp;version=3">diff</a>) </li> </ul> Ticket kindly Wed, 22 Aug 2012 01:53:50 GMT http://localhost/ticket/2877#comment:4 http://localhost/ticket/2877#comment:4 <ul> <li><strong>description</strong> modified (<a href="/ticket/2877?action=diff&amp;version=4">diff</a>) </li> </ul> <p> 1. This is fixed need to reload data to test though. </p> <p> 2. Fixed as far as I am concerned, limit 0 now returns correct total. If there are no results in filter return total of 0. </p> <p> 3. Want to keep postgres types. This will stop the need for mappings in both directions and makes everything simpler. We are currently not storing any metadata on tables and would like it to stay that way. </p> Ticket rgrp Wed, 22 Aug 2012 09:01:27 GMT http://localhost/ticket/2877#comment:5 http://localhost/ticket/2877#comment:5 <ul> <li><strong>owner</strong> set to <em>kindly</em> </li> <li><strong>status</strong> changed from <em>new</em> to <em>assigned</em> </li> </ul> Ticket rgrp Thu, 30 Aug 2012 09:53:15 GMT http://localhost/ticket/2877#comment:6 http://localhost/ticket/2877#comment:6 <ul> <li><strong>description</strong> modified (<a href="/ticket/2877?action=diff&amp;version=6">diff</a>) </li> </ul> Ticket