Bug #314193 “adding query syntax to check for existance of a val...” : Bugs : Open Library

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <base href="https://bugs.launchpad.net/openlibrary/+bug/314193/+index" /> <meta charset="UTF-8" /> <title>Bug #314193 “adding query syntax to check for existance of a val...” : Bugs : Open Library</title> <link rel="apple-touch-icon" sizes="180x180" href="/@@/apple-touch-icon.png?v=2022" /> <link rel="icon" type="image/png" sizes="32x32" href="/@@/favicon-32x32.png?v=2022" /> <link rel="icon" type="image/png" sizes="16x16" href="/@@/favicon-16x16.png?v=2022" /> <link rel="manifest" href="/@@/site.webmanifest?v=2022" /> <link rel="mask-icon" href="/@@/safari-pinned-tab.svg?v=2022" color="#e9531f" /> <link rel="shortcut icon" href="/@@/favicon.ico?v=2022" /> <meta name="msapplication-TileColor" content="#da532c" /> <meta name="msapplication-config" content="/@@/browserconfig.xml?v=2022" /> <meta name="theme-color" content="#ffffff" /> <link rel="canonical" href="https://bugs.launchpad.net/bugs/314193" /> <link rel="alternate" type="application/atom+xml" href="http://feeds.launchpad.net/bugs/314193/bug.atom" title="Bug 314193 Feed" /> <link type="text/css" rel="stylesheet" media="screen, print" href="/+icing/rev419ba3bacb6daab6277d21076d6369a2b1ffe680/combo.css" /> <meta name="description" content="It would be useful to be able to restrict searches to citations that have some value in a given field, especially the uri field. This would mimic SQL syntax that tests for NOT NULL values. Specifically it would be useful to focus searches for citations that have harvestable links to web resources, besides the fulltext subset in OL." /> <meta property="og:description" content="It would be useful to be able to restrict searches to citations that have some value in a given field, especially the uri field. This would mimic SQL syntax that tests for NOT NULL values. Specifically it would be useful to focus searches for citations that have harvestable links to web resources, besides the fulltext subset in OL." /> <meta property="og:title" content="Bug #314193 “adding query syntax to check for existance of a val...” : Bugs : Open Library" /> <meta property="og:type" content="website" /> <meta property="og:image" content="/@@/launchpad-og-image.png" /> <meta property="og:url" content="https://bugs.launchpad.net/bugs/314193" /> <meta property="og:site_name" content="Launchpad" /> <script type="text/javascript"> var LP = { cache: {}, links: {} }; </script> <script type="text/javascript">var cookie_scope = '; Path=/; Secure; Domain=.launchpad.net';</script> <script type="text/javascript" src="/+combo/rev419ba3bacb6daab6277d21076d6369a2b1ffe680/?yui/yui/yui-min.js&lp/meta.js&yui/loader/loader-min.js"></script> <script type="text/javascript"> var raw = null; if (LP.devmode) { raw = 'raw'; } YUI.GlobalConfig = { combine: true, comboBase: '/+combo/rev419ba3bacb6daab6277d21076d6369a2b1ffe680/?', root: 'yui/', filter: raw, debug: false, fetchCSS: false, maxURLLength: 2000, groups: { lp: { combine: true, base: '/+combo/rev419ba3bacb6daab6277d21076d6369a2b1ffe680/?lp/', comboBase: '/+combo/rev419ba3bacb6daab6277d21076d6369a2b1ffe680/?', root: 'lp/', // comes from including lp/meta.js modules: LP_MODULES, fetchCSS: false } } }</script> <script type="text/javascript"> // we need this to create a single YUI instance all events and code // talks across. All instances of YUI().use should be based off of // LPJS instead. var LPJS = new YUI(); </script> <script id="base-layout-load-scripts" type="text/javascript"> //<![CDATA[ LPJS.use('base', 'node', 'console', 'event', 'oop', 'lp', 'lp.app.foldables','lp.app.sorttable', 'lp.app.inlinehelp', 'lp.app.links', 'lp.bugs.bugtask_index', 'lp.bugs.subscribers', 'lp.app.ellipsis', 'lp.code.branchmergeproposal.diff', 'lp.views.global', function(Y) { Y.on("domready", function () { var global_view = new Y.lp.views.Global(); global_view.render(); Y.lp.app.sorttable.SortTable.init(); Y.lp.app.inlinehelp.init_help(); Y.lp.activate_collapsibles(); Y.lp.app.foldables.activate(); Y.lp.app.links.check_valid_lp_links(); }); Y.on('lp:context:web_link:changed', function(e) { window.location = e.new_value; }); }); //]]> </script> <script id="base-helper-functions" type="text/javascript"> //<![CDATA[ // This code is pulled from lp.js that needs to be available on every // request. Pulling here to get it outside the scope of the YUI block. function setFocusByName(name) { // Focus the first element matching the given name which can be focused. var nodes = document.getElementsByName(name); var i, node; for (i = 0; i < nodes.length; i++) { node = nodes[i]; if (node.focus) { try { // Trying to focus a hidden element throws an error in IE8. if (node.offsetHeight !== 0) { node.focus(); } } catch (e) { LPJS.use('console', function(Y) { Y.log('In setFocusByName(<' + node.tagName + ' type=' + node.type + '>): ' + e); }); } break; } } } function selectWidget(widget_name, event) { if (event && (event.keyCode === 9 || event.keyCode === 13)) { // Avoid firing if user is tabbing through or simply pressing // enter to submit the form. return; } document.getElementById(widget_name).checked = true; } //]]> </script> <script type="text/javascript" id="available-official-tags-js">var available_official_tags = ["api", "ariel", "covers", "i18n", "language", "lending", "marc", "rdf", "search", "types", "works"];</script> <script type="text/javascript"> LPJS.use('base', 'node', 'oop', 'event', 'lp.bugs.bugtask_index', 'lp.bugs.subscribers', 'lp.code.branchmergeproposal.diff', 'lp.app.comment', 'lp.services.messages.edit', function(Y) { Y.on('domready', function() { Y.lp.code.branchmergeproposal.diff.connect_diff_links(); Y.lp.bugs.bugtask_index.setup_bugtask_index(); Y.lp.bugs.bugtask_index.setup_bugtask_table(); LP.cache.comment_context = LP.cache.bug; var cl = new Y.lp.app.comment.CommentList(); cl.render(); var sl = new Y.lp.bugs.subscribers.createBugSubscribersLoader({ container_box: '#other-bug-subscribers', subscribers_details_view: '/+bug-portlet-subscribers-details', subscribe_someone_else_link: '.menu-link-addsubscriber' }, window); Y.lp.services.messages.edit.setup(); }); }); </script> <style type="text/css"> /* Align the 'add comment' link to the right of the comment box. */ #add-comment-form textarea { width: 100%; } #add-comment-form { max-width: 60em; padding-bottom: 4em; } #add-comment-form .actions {float: right;} .buglink-summary dd { font-size: 10px; } a#privacy-link:link:hover, a#privacy-link:visited:hover {text-decoration:none;} </style> <style type="text/css"> .yui3-overlay .value label { /* It normally makes sense for form labels to be bold, but since this form consists only of radio buttons, there's nothing but labels so we just get wall-to-wall bold. */ font-weight: normal !important; } </style> </head> <body id="document" itemscope="" itemtype="http://schema.org/WebPage" class="tab-bugs main_side public yui3-skin-sam"> <div class="yui-d0"> <div id="locationbar" class="login-logout"> <div id="logincontrol"><a href="https://bugs.launchpad.net/openlibrary/+bug/314193/+login">Log in / Register</a></div> </div> <div id="watermark" class="watermark-apps-portlet"> <div> <a href="https://launchpad.net/openlibrary"><img alt="" width="64" height="64" src="https://launchpadlibrarian.net/35799906/ol-launchpad.png" /></a> </div> <div class="wide"> <h2 id="watermark-heading"><a href="https://launchpad.net/openlibrary">Open Library</a></h2> </div>  <ul class="facetmenu"> <li class="overview"><a href="https://launchpad.net/openlibrary">Overview</a></li> <li class="branches"><a href="https://code.launchpad.net/openlibrary">Code</a></li> <li class="bugs active"><a href="https://bugs.launchpad.net/openlibrary">Bugs</a></li> <li class="specifications"><a href="https://blueprints.launchpad.net/openlibrary">Blueprints</a></li> <li class="translations"><a href="https://translations.launchpad.net/openlibrary">Translations</a></li> <li class="answers"><a href="https://answers.launchpad.net/openlibrary">Answers</a></li> </ul> </div> <div class="yui-t4"> <div id="maincontent" class="yui-main"> <div class="yui-b" dir="ltr"> <div class="context-publication"> <h1 id="edit-title"> <span class="yui3-editable_text-text ellipsis" style="max-width: 95%;"> adding query syntax to check for existance of a value in a field, especially uri field </span> </h1> <div id="registration" class="registering"> Bug #314193 reported by <a href="https://launchpad.net/~richard-aroksaar" class="sprite person">Richard Aroksaar</a> <time title="2009-01-05 22:48:04 UTC" datetime="2009-01-05T22:48:04.145697+00:00">on 2009-01-05</time> </div> </div> <div id="request-notifications"> </div> <div> <div id="bug-is-duplicate"> </div> <div style="float: right;"> <span><a href="/+help-bugs/bug-heat.html" target="help" class="sprite flame">2</a></span> </div> <table id="affected-software" class="listing"> <thead> <tr> <th colspan="2">Affects</th> <th>Status</th> <th>Importance</th> <th>Assigned to</th> <th>Milestone</th> </tr> </thead> <tbody> <tr class="highlight" id="tasksummary367210"> <td> </td> <td> <span id="bugtarget-picker-tasksummary367210"> <span class="yui3-activator-data-box"> <a class="sprite product" href="https://bugs.launchpad.net/openlibrary">Open Library</a> </span> <div class="yui3-activator-message-box yui3-activator-hidden"></div> </span> </td> <td style="width: 20%; vertical-align: middle"> <div class="status-content" style="width: 100%; float: left"> <span style="float: left" class="value statusCONFIRMED">Confirmed</span> </div> </td> <td style="width: 15em; vertical-align: middle"> <div class="importance-content" style="width: 100%; float: left"> <span style="float: left" class="value importanceHIGH">High</span> </div> </td> <td style="width:20%; margin: 0; padding: 0; vertical-align: middle; padding-left: 0.5em"> <span id="assignee-picker-tasksummary367210"> <span class="yui3-activator-data-box"> <a class="sprite person" href="https://launchpad.net/~anandology">Anand Chitipothu</a> </span> <div class="yui3-activator-message-box yui3-activator-hidden"></div> </span> </td> <td style="width: 20%; vertical-align: middle"> <div class="milestone-content" style="width: 100%; float: left"> <a class="value" href="https://launchpad.net/openlibrary/+milestone/bib">Open Library bib</a> </div> </td> </tr> </tbody> </table> <div id="maincontentsub"> <div class="top-portlet"> <div itemprop="mainContentOfPage" class="report"> <div> <div class="lazr-multiline-edit" id="edit-description"> <div class="clearfix"> <h3>Bug Description</h3> </div> <div class="yui3-editable_text-text"><p>It would be useful to be able to restrict searches to citations that have some value in a given field, especially the uri field. This would mimic SQL syntax that tests for NOT NULL values. Specifically it would be useful to focus searches for citations that have harvestable links to web resources, besides the fulltext subset in OL.</p></div> </div> </div> <div style="margin:-10px 0 20px 5px" class="clearfix"> </div> <div id="bug-tags"> <span id="tags-heading"> Tags: </span> <span id="tag-list"> <a class="official-tag" href="/openlibrary/+bugs?field.tag=api">api</a> </span> </div> <script type="text/javascript"> LPJS.use('event', 'node', 'lp.bugs.tags_entry', function(Y) { Y.on('domready', function(e) { Y.lp.bugs.tags_entry.setup_tag_entry( available_official_tags); }, window); }); </script> <div class="clearfix"></div> </div> <div id="branches-and-cves"> <div id="bug-branches-container" style="float: left"> </div> <div class="clearfix"></div> </div>  </div> <div> <div xmlns="http://www.w3.org/1999/xhtml" itemscope="" itemtype="http://schema.org/UserComments" class="boardComment editable-message " data-baseurl="/openlibrary/+bug/314193/comments/1" data-i-can-edit="False"> <div class="boardCommentDetails"> <div class="message-revision-container"> <div class="message-revision-container-header"> <span>Revision history for this message</span> <img src="/+icing/build/overlay/assets/skins/sam/images/close.gif" class="message-revision-close" /> </div> <script type="text/template"> <div class='message-revision-item'> <div class='message-revision-title'> <a class="sprite remove action-icon message-revision-del-btn"> Remove </a> <a class="js-action"> Revision #{revision}, created at {date_created_display} </a> </div> <div class='message-revision-body'>{content}</div> </div> </script> <div class="message-revision-list"></div> </div> <table> <tbody> <tr> <td> <a href="https://launchpad.net/~solrize" class="sprite person">solrize (solrize)</a> wrote <time itemprop="commentTime" datetime="2009-01-06T01:56:50.010662+00:00" title="2009-01-06 01:56:50 UTC">on 2009-01-06</time><span class="editable-message-last-edit-date">: </span> </td> <td> </td> <td> </td> <td class="bug-comment-index"> <a itemprop="url" href="/openlibrary/+bug/314193/comments/1"> #1</a> </td> </tr> </tbody> </table> </div> <div class="boardCommentBody"> <div class="editable-message-body"> <div class="comment-text editable-message-text" itemprop="commentText"><p>It may already be possible to do this with existing lucene syntax in a search query. I'll look at the docs and see if I can figure out a way. If not, it can be done by adding a new field to each record at search index time, containing the names of all nonempty field for that record.</p> <p>Books with uri's actually sounds useful enough that it may be worth adding as a search facet. Any thoughts?</p></div> </div> <div class="editable-message-form" style="display: none"> <textarea style="width: 100%" rows="10">It may already be possible to do this with existing lucene syntax in a search query. I'll look at the docs and see if I can figure out a way. If not, it can be done by adding a new field to each record at search index time, containing the names of all nonempty field for that record. Books with uri's actually sounds useful enough that it may be worth adding as a search facet. Any thoughts?</textarea> <input type="button" value="Update" class="editable-message-update-btn" /> <input type="button" value="Cancel" class="editable-message-cancel-btn" /> </div> </div> </div> <div xmlns="http://www.w3.org/1999/xhtml" itemscope="" itemtype="http://schema.org/UserComments" class="boardComment editable-message " data-baseurl="/openlibrary/+bug/314193/comments/2" data-i-can-edit="False"> <div class="boardCommentDetails"> <div class="message-revision-container"> <div class="message-revision-container-header"> <span>Revision history for this message</span> <img src="/+icing/build/overlay/assets/skins/sam/images/close.gif" class="message-revision-close" /> </div> <script type="text/template"> <div class='message-revision-item'> <div class='message-revision-title'> <a class="sprite remove action-icon message-revision-del-btn"> Remove </a> <a class="js-action"> Revision #{revision}, created at {date_created_display} </a> </div> <div class='message-revision-body'>{content}</div> </div> </script> <div class="message-revision-list"></div> </div> <table> <tbody> <tr> <td> <a href="https://launchpad.net/~richard-aroksaar" class="sprite person">Richard Aroksaar (richard-aroksaar)</a> wrote <time itemprop="commentTime" datetime="2009-01-06T20:22:34+00:00" title="2009-01-06 20:22:34 UTC">on 2009-01-06</time><span class="editable-message-last-edit-date">: </span> <a href="/openlibrary/+bug/314193/comments/2"> <strong>Re: [Bug 314193] Re: adding query syntax to check for existance of a value in a field, especially uri field</strong> </a> </td> <td> </td> <td> </td> <td class="bug-comment-index"> <a itemprop="url" href="/openlibrary/+bug/314193/comments/2"> #2</a> </td> </tr> </tbody> </table> </div> <div class="boardCommentBody"> <a href="https://bugs.launchpad.net/openlibrary/+bug/314193/comments/2/+download">Download full text</a> (3.3 KiB) <div class="editable-message-body"> <div class="comment-text editable-message-text" itemprop="commentText"><p>Thanks for the prompt reply.</p> <p>One idea that I've had since this morning is that since Open Library<br /> citations seem to become searchable as "Scanned books only" as soon as an<br /> "ocaid" has been added to the citation, it might be possible to mimic that<br /> functionality for the uri field.</p> <p> I've experimented with uploading a pdf to the Internet Archive into the<br /> Temp collection, using the IA "Upload" button. I added<br /> the ocaid value supplied by IA to the Open Library citation and now a "Read<br /> online" button displays and this citation shows up in<br /> the "Scanned books only" subset. Here it is:</p> <p><a rel="nofollow" href="http://openlibrary.org/b/OL344308M">http://<wbr />openlibrary.<wbr />org/b/OL344308M</a></p> <p>This case seems a bit buggy when I try to reach the pdf from the OL<br /> citation, perhaps because I chose the IA "Temp" collection for it. I don't<br /> think I made a mistake<br /> when I added the ocaid to the citation.</p> <p>"Lucene syntax" sounds interesting. I think I should try to learn more<br /> about it.</p> <p>Richard Aroksaar<br /> NPS Voyager System Administrator<br /> 206-220-4252<br /> 206-612-2006 (cell)</p> <p>       <wbr />      solrize<br />              <email address hidden><br />              Sent by: To<br />        <wbr />      bounces@<wbr />canonical <email address hidden><br />              .com cc</p> <p>       <wbr />       <wbr />       <wbr />       <wbr />       <wbr />       <wbr />       <wbr />       <wbr />       <wbr />    Subject<br />        <wbr />      01/<wbr />06/2009 01:56 [<a href="/bugs/314193" class="bug-link">Bug 314193</a>] Re: adding query<br />              AM GMT syntax to check for existance of a<br />        <wbr />       <wbr />       <wbr />       <wbr />       <wbr />    value in a field, especially uri<br />        <wbr />       <wbr />       <wbr />       <wbr />       <wbr />    field<br />              Please respond to<br />                 <a href="/bugs/314193" class="bug-link">Bug 314193</a><br />        <wbr />      <<wbr /><email address hidden><br />        <wbr />       <wbr />  chpad.<wbr />net></p> <p>It may already be possible to do this with existing lucene syntax in a<br /> search query. I'll look at the docs and see if I can figure out a way.<br /> If not, it can be done by adding a new field to each record at search<br /> index time, containing the names of all nonempty field for that record.</p> <p>Books with uri's actually sounds useful enough that it may be worth<br /> adding as a search facet. Any thoughts?</p> <p><span class="foldable">--<br /> adding query syntax to check for existance of a value in a field,<br /> especially uri field<br /> <a rel="nofollow" href="https://bugs.launchpad.net/bugs/314193">https:/<wbr />/bugs.launchpad<wbr />.net/bugs/<wbr />314193</a><br /> You received this bug notification because you are a direct subscriber<br /> of the bug. </span></p> <p>Status in Open Library: New</p> <p>Bug description:<br /> It would be useful to be able to restrict searches to citations that have<br /> some value in a given field, especially the uri field. This would mimic SQL<br /> syntax that tests for NOT ...</p></div> <p> <a href="/openlibrary/+bug/314193/comments/2">Read more...</a> </p> </div> <div class="editable-message-form" style="display: none"> <textarea style="width: 100%" rows="10">Thanks for the prompt reply. One idea that I've had since this morning is that since Open Library citations seem to become searchable as "Scanned books only" as soon as an "ocaid" has been added to the citation, it might be possible to mimic that functionality for the uri field. I've experimented with uploading a pdf to the Internet Archive into the Temp collection, using the IA "Upload" button. I added the ocaid value supplied by IA to the Open Library citation and now a "Read online" button displays and this citation shows up in the "Scanned books only" subset. Here it is: http://openlibrary.org/b/OL344308M This case seems a bit buggy when I try to reach the pdf from the OL citation, perhaps because I chose the IA "Temp" collection for it. I don't think I made a mistake when I added the ocaid to the citation. "Lucene syntax" sounds interesting. I think I should try to learn more about it. Richard Aroksaar NPS Voyager System Administrator 206-220-4252 206-612-2006 (cell) solrize <phr@archive.org> Sent by: To bounces@canonical richard_aroksaar@nps.gov .com cc Subject 01/06/2009 01:56 [Bug 314193] Re: adding query AM GMT syntax to check for existance of a value in a field, especially uri field Please respond to Bug 314193 <314193@bugs.laun chpad.net> It may already be possible to do this with existing lucene syntax in a search query. I'll look at the docs and see if I can figure out a way. If not, it can be done by adding a new field to each record at search index time, containing the names of all nonempty field for that record. Books with uri's actually sounds useful enough that it may be worth adding as a search facet. Any thoughts? -- adding query syntax to check for existance of a value in a field, especially uri field https://bugs.launchpad.net/bugs/314193 You received this bug notification because you are a direct subscriber of the bug. Status in Open Library: New Bug description: It would be useful to be able to restrict searches to citations that have some value in a given field, especially the uri field. This would mimic SQL syntax that tests for NOT NULL values. Specifically it would be useful to focus searches for citations that have harvestable links to web resources, besides the fulltext subset in OL. </textarea> <input type="button" value="Update" class="editable-message-update-btn" /> <input type="button" value="Cancel" class="editable-message-cancel-btn" /> </div> </div> </div> <div class="boardComment"> <div class="boardCommentDetails"> <a href="https://launchpad.net/~edwardbetts" class="sprite person">Edward Betts (edwardbetts)</a> <time title="2009-09-14 12:07:05 UTC" datetime="2009-09-14T12:07:05.568749+00:00">on 2009-09-14</time> </div> <div class="boardCommentActivity"> <table class="bug-activity"> <tr> <td colspan="2">Changed in openlibrary: </td> </tr> <tr> <td style="text-align: right;"> <b>assignee</b>: </td> <td> nobody → Anand Chitipothu (anandology) </td> </tr> <tr> <td style="text-align: right;"> <b>tags</b>: </td> <td> added: api </td> </tr> </table> </div> </div> <div class="boardComment"> <div class="boardCommentDetails"> <a href="https://launchpad.net/~edwardbetts" class="sprite person">Edward Betts (edwardbetts)</a> <time title="2010-07-28 21:29:39 UTC" datetime="2010-07-28T21:29:39.309725+00:00">on 2010-07-28</time> </div> <div class="boardCommentActivity"> <table class="bug-activity"> <tr> <td colspan="2">Changed in openlibrary: </td> </tr> <tr> <td style="text-align: right;"> <b>assignee</b>: </td> <td> Anand Chitipothu (anandology) → Edward Betts (edwardbetts) </td> </tr> <tr> <td style="text-align: right;"> <b>status</b>: </td> <td> New → Incomplete </td> </tr> <tr> <td style="text-align: right;"> <b>status</b>: </td> <td> Incomplete → Won't Fix </td> </tr> </table> </div> </div> <div class="boardComment"> <div class="boardCommentDetails"> <a href="https://launchpad.net/~edwardbetts" class="sprite person">Edward Betts (edwardbetts)</a> <time title="2010-08-03 21:47:49 UTC" datetime="2010-08-03T21:47:49.958538+00:00">on 2010-08-03</time> </div> <div class="boardCommentActivity"> <table class="bug-activity"> <tr> <td colspan="2">Changed in openlibrary: </td> </tr> <tr> <td style="text-align: right;"> <b>status</b>: </td> <td> Won't Fix → Confirmed </td> </tr> <tr> <td style="text-align: right;"> <b>assignee</b>: </td> <td> Edward Betts (edwardbetts) → Anand Chitipothu (anandology) </td> </tr> <tr> <td style="text-align: right;"> <b>importance</b>: </td> <td> Undecided → Low </td> </tr> </table> </div> </div> <div xmlns="http://www.w3.org/1999/xhtml" itemscope="" itemtype="http://schema.org/UserComments" class="boardComment editable-message " data-baseurl="/openlibrary/+bug/314193/comments/3" data-i-can-edit="False"> <div class="boardCommentDetails"> <div class="message-revision-container"> <div class="message-revision-container-header"> <span>Revision history for this message</span> <img src="/+icing/build/overlay/assets/skins/sam/images/close.gif" class="message-revision-close" /> </div> <script type="text/template"> <div class='message-revision-item'> <div class='message-revision-title'> <a class="sprite remove action-icon message-revision-del-btn"> Remove </a> <a class="js-action"> Revision #{revision}, created at {date_created_display} </a> </div> <div class='message-revision-body'>{content}</div> </div> </script> <div class="message-revision-list"></div> </div> <table> <tbody> <tr> <td> <a href="https://launchpad.net/~george-archive" class="sprite person">George (george-archive)</a> wrote <time itemprop="commentTime" datetime="2010-09-16T17:57:49.718683+00:00" title="2010-09-16 17:57:49 UTC">on 2010-09-16</time><span class="editable-message-last-edit-date">: </span> </td> <td> </td> <td> </td> <td class="bug-comment-index"> <a itemprop="url" href="/openlibrary/+bug/314193/comments/3"> #3</a> </td> </tr> </tbody> </table> </div> <div class="boardCommentBody"> <div class="editable-message-body"> <div class="comment-text editable-message-text" itemprop="commentText"><p>Anand - please fold this in to your API work. It's important that our API allow external devs to use any of the ID types we support to query the API.</p></div> </div> <div class="editable-message-form" style="display: none"> <textarea style="width: 100%" rows="10">Anand - please fold this in to your API work. It's important that our API allow external devs to use any of the ID types we support to query the API.</textarea> <input type="button" value="Update" class="editable-message-update-btn" /> <input type="button" value="Cancel" class="editable-message-cancel-btn" /> </div> </div> <div class="boardCommentActivity"> <table class="bug-activity"> <tr> <td colspan="2">Changed in openlibrary: </td> </tr> <tr> <td style="text-align: right;"> <b>importance</b>: </td> <td> Low → High </td> </tr> <tr> <td style="text-align: right;"> <b>milestone</b>: </td> <td> none → search-september-release </td> </tr> <tr> <td style="text-align: right;"> <b>milestone</b>: </td> <td> search-september-release → bib </td> </tr> </table> </div> </div> <div style="float: right;"> <a class="menu-link-activitylog" href="https://bugs.launchpad.net/openlibrary/+bug/314193/+activity">See full activity log</a> </div> <div class="clearfix"></div> <div align="center" id="add-comment-login-first"> To post a comment you must <a href="+login?comments=all">log in</a>. </div> </div> </div> <div> <div id="duplicate-form-container"></div> <div id="privacy-form-container"></div> </div> </div> </div> </div> <div id="side-portlets" class="yui-b side"> <div id="involvement" class="portlet"> <ul class="involvement"> <li class="single"> <a class="sprite bugs" href="/openlibrary/+filebug"> Report a bug </a> </li> </ul> </div> <div id="privacy" class="first portlet public"> <div id="privacy-text"> <span id="information-type-summary" class="sprite public">This report contains <strong id="information-type">Public</strong> information </span>  <div id="information-type-description" style="padding-top: 5px">Everyone can see this information. </div> </div> </div> <div id="portlet-actions" class="portlet vertical"> <ul id="duplicate-actions"> </ul> <ul id="lock-status-actions"> </ul> </div> <div class="portlet vertical" id="portlet-subscription"> <div class="section"> <div id="current_user_subscription" class="False"> <span>You are</span> <a class="menu-link-subscription sprite modify edit" href="/openlibrary/+bug/314193/+subscribe"> not directly subscribed to this bug's notifications. </a> </div> <div id="sub-unsub-spinner">Subscribing...</div> <ul> <li><a class="menu-link-editsubscriptions sprite modify edit" href="https://bugs.launchpad.net/openlibrary/+bug/314193/+subscriptions" title="View and change your subscriptions to this bug">Edit bug mail</a></li> </ul> </div> <script type="text/javascript"> LPJS.use('io-base', 'node', 'lp.bugs.bugtask_index.portlets.subscription', function(Y) { Y.on('domready', function() { Y.lp.bugs.bugtask_index.portlets.subscription.initialize(); }); }); </script> </div> <div class="portlet vertical" id="portlet-subscribers"> <h2>Other bug subscribers</h2> <div> <div><a class="menu-link-addsubscriber sprite add" href="https://bugs.launchpad.net/openlibrary/+bug/314193/+addsubscriber" title="Launchpad will email that person whenever this bugs changes">Subscribe someone else</a></div> </div> <div id="other-bug-subscribers"></div> </div> <div class="portlet" id="portlet-watches"> <h2>Remote bug watches</h2> <ul> </ul> <p>Bug watches keep track of this bug in other bug trackers.</p> </div> </div> </div> <div id="footer" class="footer"> <div class="lp-arcana"> <div class="lp-branding"> <a href="https://launchpad.net/"><img src="/@@/launchpad-footer-logo.svg" alt="Launchpad" width="65" height="18" /></a>  •  <a href="https://launchpad.net/+tour">Take the tour</a>  •  <a href="https://help.launchpad.net/">Read the guide</a>   <form id="globalsearch" method="get" accept-charset="UTF-8" action="https://launchpad.net/+search"> <input type="search" id="search-text" name="field.text" /> <input type="image" src="/@@/search" style="vertical-align:5%" alt="Search Launchpad" /> </form> </div> </div> <div class="colophon"> © 2004 <a href="http://canonical.com/">Canonical Ltd.</a>  •  <a href="https://launchpad.net/legal">Terms of use</a>  •  <a href="https://www.ubuntu.com/legal/dataprivacy">Data privacy</a>  •  <a href="/feedback">Contact Launchpad Support</a>  •  <a href="http://blog.launchpad.net/">Blog</a>  •  <a href="https://canonical.com/careers">Careers</a>  •  <a href="https://ubuntu.social/@launchpadstatus">System status</a> <span id="lp-version">  •  419ba3b (<a href="https://dev.launchpad.net/">Get the code!</a>) </span> </div> </div> </div> <script id="json-cache-script">LP.cache = {"related_features": {}, "bug": {"self_link": "https://bugs.launchpad.net/api/devel/bugs/314193", "web_link": "https://bugs.launchpad.net/bugs/314193", "resource_type_link": "https://bugs.launchpad.net/api/devel/#bug", "id": 314193, "private": false, "information_type": "Public", "name": null, "title": "adding query syntax to check for existance of a value in a field, especially uri field", "description": "It would be useful to be able to restrict searches to citations that have some value in a given field, especially the uri field. This would mimic SQL syntax that tests for NOT NULL values. Specifically it would be useful to focus searches for citations that have harvestable links to web resources, besides the fulltext subset in OL.", "owner_link": "https://bugs.launchpad.net/api/devel/~richard-aroksaar", "bug_tasks_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/bug_tasks", "duplicate_of_link": null, "date_created": "2009-01-05T22:48:04.145697+00:00", "activity_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/activity", "subscriptions_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/subscriptions", "date_last_updated": "2010-09-16T17:57:58.122632+00:00", "who_made_private_link": null, "date_made_private": null, "heat": 2, "bug_watches_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/bug_watches", "cves_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/cves", "vulnerabilities_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/vulnerabilities", "duplicates_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/duplicates", "attachments_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/attachments", "security_related": false, "latest_patch_uploaded": null, "tags": ["api"], "date_last_message": "2009-01-06T20:22:34+00:00", "number_of_duplicates": 0, "message_count": 4, "users_affected_count": 0, "users_unaffected_count": 0, "users_affected_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/users_affected", "users_unaffected_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/users_unaffected", "users_affected_count_with_dupes": 0, "other_users_affected_count_with_dupes": 0, "users_affected_with_dupes_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/users_affected_with_dupes", "messages_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/messages", "lock_status": "Unlocked", "lock_reason": null, "linked_branches_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/linked_branches", "linked_merge_proposals_collection_link": "https://bugs.launchpad.net/api/devel/bugs/314193/linked_merge_proposals", "http_etag": "\"e4fcbc2f506decddf67682a03c1e2090d6c631fb-82625caa91216682b64940063b2dc95cf2951657\""}, "subscribers_portlet_url_data": {"web_link": "https://bugs.launchpad.net/bugs/314193", "self_link": "https://bugs.launchpad.net/api/devel/bugs/314193"}, "total_comments_and_activity": 14, "initial_comment_batch_offset": 41, "first visible_recent_comment": -37, "bugtask_data": {"367210": {"id": 367210, "row_id": "tasksummary367210", "form_row_id": "task367210", "bugtask_path": "/openlibrary/+bug/314193", "prefix": "openlibrary", "targetname": "Open Library", "bug_title": "adding query syntax to check for existance of a value in a field, especially uri field", "assignee_value": "anandology", "assignee_is_team": false, "assignee_vocabulary": "AllUserTeamsParticipation", "assignee_vocabulary_filters": [], "hide_assignee_team_selection": true, "user_can_unassign": false, "user_can_delete": false, "delete_link": "https://bugs.launchpad.net/openlibrary/+bug/314193/+delete", "target_is_product": true, "status_widget_items": [{"name": "Confirmed", "value": "Confirmed", "description": "Verified by someone other than the reporter.\n", "description_css_class": "choice-description", "style": "", "help": "", "disabled": false, "css_class": "statusCONFIRMED"}], "status_value": "Confirmed", "importance_widget_items": "[]", "importance_value": "High", "milestone_widget_items": "[]", "milestone_value": "https://bugs.launchpad.net/api/devel/openlibrary/+milestone/bib", "user_can_edit_assignee": false, "user_can_edit_milestone": false, "user_can_edit_status": false, "user_can_edit_importance": false}}, "information_type_data": {"PUBLIC": {"value": "PUBLIC", "description": "Everyone can see this information.\n", "name": "Public", "order": 0, "is_private": false, "description_css_class": "choice-description"}, "PUBLICSECURITY": {"value": "PUBLICSECURITY", "description": "Everyone can see this security related information.\n", "name": "Public Security", "order": 1, "is_private": false, "description_css_class": "choice-description"}, "PRIVATESECURITY": {"value": "PRIVATESECURITY", "description": "Only the security group can see this information.\n ", "name": "Private Security", "order": 2, "is_private": true, "description_css_class": "choice-description"}, "USERDATA": {"value": "USERDATA", "description": "Only shared with users permitted to see private user information.\n", "name": "Private", "order": 3, "is_private": true, "description_css_class": "choice-description"}}, "bug_is_private": false, "context": {"self_link": "https://bugs.launchpad.net/api/devel/openlibrary/+bug/314193", "web_link": "https://bugs.launchpad.net/openlibrary/+bug/314193", "resource_type_link": "https://bugs.launchpad.net/api/devel/#bug_task", "bug_link": "https://bugs.launchpad.net/api/devel/bugs/314193", "milestone_link": "https://bugs.launchpad.net/api/devel/openlibrary/+milestone/bib", "status": "Confirmed", "status_explanation": null, "importance": "High", "importance_explanation": null, "assignee_link": "https://bugs.launchpad.net/api/devel/~anandology", "bug_target_display_name": "Open Library", "bug_target_name": "openlibrary", "bug_watch_link": null, "date_assigned": "2009-09-14T12:07:05.954083+00:00", "date_created": "2009-01-05T22:48:04.145697+00:00", "date_confirmed": "2010-08-03T21:47:50.587842+00:00", "date_incomplete": null, "date_in_progress": null, "date_closed": null, "date_left_new": "2010-07-28T21:31:14.351712+00:00", "date_triaged": null, "date_fix_committed": null, "date_fix_released": null, "date_left_closed": "2010-08-03T21:47:50.587842+00:00", "owner_link": "https://bugs.launchpad.net/api/devel/~richard-aroksaar", "target_link": "https://bugs.launchpad.net/api/devel/openlibrary", "title": "Bug #314193 in Open Library: \"adding query syntax to check for existance of a value in a field, especially uri field\"", "related_tasks_collection_link": "https://bugs.launchpad.net/api/devel/openlibrary/+bug/314193/related_tasks", "is_complete": false, "http_etag": "\"e6a8359ec036cffbb5fc419c5910729c7d760e44-2c40360ed36d8bea698868a89316f384fd18e6c3\""}};</script> </body>  </html>

CINXE.COM

Bug #314193 “adding query syntax to check for existance of a val...” : Bugs : Open Library