http://localhost/ticket/187 <p> Standard search should search notes field in addition to name, title and tags (discussed in <a class="closed ticket" href="http://localhost/ticket/108" title="enhancement: Package search in the REST API (closed: fixed)">ticket:108</a> but not done). For this to work we need proper text search since o/w we get poor ordering and lots of bad results. </p> <p> If we do this we need: </p> <ol><li>To weight across fields in a sensible way </li><li>We can also use proper text search on title or ... </li></ol><p> Easiest way to do this is to use existing facilities in dbs e.g. postgres has full text support since 8.3: <a class="ext-link" href="http://www.postgresql.org/docs/8.3/static/textsearch.html"><span class="icon">​</span>http://www.postgresql.org/docs/8.3/static/textsearch.html</a> </p> <p> Using this with sqlalchemy: <a class="ext-link" href="http://lowmanio.co.uk/blog/entries/postgresql-full-text-search-and-sqlalchemy/"><span class="icon">​</span>http://lowmanio.co.uk/blog/entries/postgresql-full-text-search-and-sqlalchemy/</a> </p> en-us http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png http://localhost/ticket/187 Trac 0.12.3 dread Wed, 18 Nov 2009 15:52:46 GMT http://localhost/ticket/187#comment:1 http://localhost/ticket/187#comment:1 <ul> <li><strong>description</strong> modified (<a href="/ticket/187?action=diff&amp;version=1">diff</a>) </li> </ul> Ticket dread Mon, 23 Nov 2009 10:01:49 GMT http://localhost/ticket/187#comment:2 http://localhost/ticket/187#comment:2 <p> Done in cset:af3cbf266750 and e70af291455e. </p> <p> Issues addressed: </p> <ul><li>tags ARE indexed </li><li>if tags are converted into lexemes but we also search on exact match. </li><li>name is split on dash when indexed by postgres. </li><li>weight name and title higher than other fields. </li></ul><p> Remaining issues: </p> <ul><li>natural language search doesn't do partial words, so search for 'gov' doesn't bring up 'government'. </li><li>previous search system not yet usable with a config file switch (for if we install on a db aside from postgres) </li></ul> Ticket dread Mon, 23 Nov 2009 10:01:57 GMT http://localhost/ticket/187#comment:3 http://localhost/ticket/187#comment:3 <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> Ticket dread Mon, 23 Nov 2009 10:06:06 GMT http://localhost/ticket/187#comment:4 http://localhost/ticket/187#comment:4 <p> Cost: 16h </p> Ticket rgrp Thu, 11 Feb 2010 12:46:43 GMT http://localhost/ticket/187#comment:5 http://localhost/ticket/187#comment:5 <ul> <li><strong>milestone</strong> changed from <em>v1.0</em> to <em>v0.11</em> </li> </ul> Ticket