{"action":"created","issue":{"url":"https://api.github.com/repos/publiclab/plots2/issues/3490","repository_url":"https://api.github.com/repos/publiclab/plots2","labels_url":"https://api.github.com/repos/publiclab/plots2/issues/3490/labels{/name}","comments_url":"https://api.github.com/repos/publiclab/plots2/issues/3490/comments","events_url":"https://api.github.com/repos/publiclab/plots2/issues/3490/events","html_url":"https://github.com/publiclab/plots2/issues/3490","id":363838021,"node_id":"MDU6SXNzdWUzNjM4MzgwMjE=","number":3490,"title":"Boolean Full-Text Searches - remove asterisk","user":{"login":"milaaraujo","id":4355017,"node_id":"MDQ6VXNlcjQzNTUwMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/4355017?v=4","gravatar_id":"","url":"https://api.github.com/users/milaaraujo","html_url":"https://github.com/milaaraujo","followers_url":"https://api.github.com/users/milaaraujo/followers","following_url":"https://api.github.com/users/milaaraujo/following{/other_user}","gists_url":"https://api.github.com/users/milaaraujo/gists{/gist_id}","starred_url":"https://api.github.com/users/milaaraujo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/milaaraujo/subscriptions","organizations_url":"https://api.github.com/users/milaaraujo/orgs","repos_url":"https://api.github.com/users/milaaraujo/repos","events_url":"https://api.github.com/users/milaaraujo/events{/privacy}","received_events_url":"https://api.github.com/users/milaaraujo/received_events","type":"User","site_admin":false},"labels":[{"id":343384842,"node_id":"MDU6TGFiZWwzNDMzODQ4NDI=","url":"https://api.github.com/repos/publiclab/plots2/labels/Ruby","name":"Ruby","color":"006b75","default":false},{"id":1054549385,"node_id":"MDU6TGFiZWwxMDU0NTQ5Mzg1","url":"https://api.github.com/repos/publiclab/plots2/labels/gci-candidate","name":"gci-candidate","color":"16ba8b","default":false},{"id":173349489,"node_id":"MDU6TGFiZWwxNzMzNDk0ODk=","url":"https://api.github.com/repos/publiclab/plots2/labels/help-wanted","name":"help-wanted","color":"0e8a16","default":false},{"id":1069526275,"node_id":"MDU6TGFiZWwxMDY5NTI2Mjc1","url":"https://api.github.com/repos/publiclab/plots2/labels/search","name":"search","color":"e3f70c","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2018-09-26T02:51:35Z","updated_at":"2018-11-13T17:19:39Z","closed_at":null,"author_association":"COLLABORATOR","body":"The boolean full-text search has the capability to support operators such as **+**, **-** and **\\***. We are using the boolean full-text search [here](https://github.com/publiclab/plots2/blob/master/app/models/node.rb#L39-L44), but with an auto-added asterisk:\r\n```\r\n        if type == :boolean\r\n          query = connection.quote(query.to_s + \"*\")\r\n          nids = Revision.select(\"node_revisions.nid, node_revisions.body, node_revisions.title, MATCH(node_revisions.body, node_revisions.title) AGAINST(#{query} IN BOOLEAN MODE) AS score\")\r\n            .where(\"MATCH(node_revisions.body, node_revisions.title) AGAINST(#{query} IN BOOLEAN MODE)\")\r\n            .limit(limit)\r\n            .distinct\r\n            .collect(&:nid)\r\n```\r\nSo we need help to:\r\n* [ ] remove the auto-added asterisk on this line, and treat \"boolean search\" as an \r\nexpert search type.\r\n* [ ] add a link to more info on boolean searches: https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html\r\n\r\n----------------------------\r\n\r\nWe are preparing to participate in Google Code-in, and have reserved this issue for participants in GCI - but we'd love to have your help with another one! Please check out https://code.publiclab.org to see more."},"comment":{"url":"https://api.github.com/repos/publiclab/plots2/issues/comments/438356594","html_url":"https://github.com/publiclab/plots2/issues/3490#issuecomment-438356594","issue_url":"https://api.github.com/repos/publiclab/plots2/issues/3490","id":438356594,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODM1NjU5NA==","user":{"login":"rohancl","id":29266591,"node_id":"MDQ6VXNlcjI5MjY2NTkx","avatar_url":"https://avatars1.githubusercontent.com/u/29266591?v=4","gravatar_id":"","url":"https://api.github.com/users/rohancl","html_url":"https://github.com/rohancl","followers_url":"https://api.github.com/users/rohancl/followers","following_url":"https://api.github.com/users/rohancl/following{/other_user}","gists_url":"https://api.github.com/users/rohancl/gists{/gist_id}","starred_url":"https://api.github.com/users/rohancl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rohancl/subscriptions","organizations_url":"https://api.github.com/users/rohancl/orgs","repos_url":"https://api.github.com/users/rohancl/repos","events_url":"https://api.github.com/users/rohancl/events{/privacy}","received_events_url":"https://api.github.com/users/rohancl/received_events","type":"User","site_admin":false},"created_at":"2018-11-13T17:19:39Z","updated_at":"2018-11-13T17:19:39Z","author_association":"NONE","body":"@SidharthBansal  @jywarren can you elaborate a bit about adding a link to the more info part of this task, Thanks !\r\n"}}
{"actor":{"display_login":"rohancl"}}