Boolean Full-Text Searches - add a link to more info on boolean searches

[milaaraujo]

The boolean full-text search has the capability to support operators such as +, - and *. We are using the boolean full-text search here, but with an auto-added asterisk:

        if type == :boolean
          query = connection.quote(query.to_s + "*")
          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")
            .where("MATCH(node_revisions.body, node_revisions.title) AGAINST(#{query} IN BOOLEAN MODE)")
            .limit(limit)
            .distinct
            .collect(&:nid)

So we need help to:

• remove the auto-added asterisk on this line, and treat "boolean search" as an
  expert search type. - Done (removed auto-added aesterisk in boolean search #4022)
• add a link to more info on boolean searches: https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html - TODO

---

We 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.

[jywarren]

This could be broken into 2 first-timers-only issues! The one with the "more info link" may need a link to a line of code, however. 👍

Thanks!!!

This has been marked as a good candidate for becoming a first-timers-only issue like these, meaning that it's simple, self-contained, and with some extra formatting, could be a great entry point for a new contributor. If you're familiar enough with this code, please consider reformatting or reposting it as a first-timers-only issue, and then ping @publiclab/reviewers to get it labelled. Or, if this is not your first time, try to solve it yourself!

---

[milaaraujo]

Hey @jywarren, can we keep this as a single issue and maybe use it as a help wanted issue for GCI?

[jywarren]

Sure!!

…

On Mon, Oct 15, 2018, 2:50 PM Camila Araújo ***@***.***> wrote: Hey @jywarren <https://github.com/jywarren>, can we keep this as a single issue and maybe use it as a help wanted issue for GCI? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#3490 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJ6Jwv8VDIAjAQxq4G7nSDoltPujRks5ulDACgaJpZM4W5zur> .

[SidharthBansal]

This task is published on GCI dashboard. Thanks all.

[angeryrohan]

@SidharthBansal @jywarren can you elaborate a bit about adding a link to the more info part of this task, Thanks !

[milaaraujo]

Hey @rohancl, this issue has two parts. First, the auto-added asterisk on this part of the code (https://github.com/publiclab/plots2/blob/master/app/models/node.rb#L39-L44) should be removed. Then we need to add a link add to give more info on boolean searches and help users to understand how to use the boolean search. This link is a good one to use: https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

[angeryrohan]

@milaaraujo Hey thanks for replying,One more doubt, I wanted to know whether I can make my own tutorial of Boolean searches in MySQL to complete the second objective of this task. Thanks !

[jywarren]

you could do that, although it's quite ambitious! Perhaps we could start by linking to an existing one, but then changing the link to yours if you complete one!

…

On Tue, Nov 13, 2018 at 11:56 PM Rohan Singh ***@***.***> wrote: @milaaraujo <https://github.com/milaaraujo> Hey thanks for replying,One more doubt, I wanted to know whether I can make my own tutorial of Boolean searches in MySQL to complete the second objective of this task. Thanks ! — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#3490 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJ4G5la_5xPhnJKsI0OPY8EcLqjw7ks5uu6JRgaJpZM4W5zur> .

[angeryrohan]

@jywarren Yeah sure, don't get me wrong, by tutorial I meant How I did the steps to solve the this task and all.

[jonxuxu]

Hi, I'd like to work on this issue. Is anyone still working on this issue? Sorry it's getting hard to know if available tasks on GCI are taken/in progress.

[milaaraujo]

@rohancl is working on this one!

[angeryrohan]

Actually, I've encountered my exams, they're like a bunch of storms coming to my face. I am really sorry, I cannot proceed any further contributing in this organisation. @JonathanXu1 feel free to continue with this task. I am really sorry @milaaraujo

[jonxuxu]

Best of luck on your exams @rohancl . Here's my pull request: #4019

[oorjitchowdhary]

This task is completed right?
I can still see it on the gci platform..

[jonxuxu]

I'm waiting for my submission to be accepted. Thanks!

[milaaraujo]

@JonathanXu1 you should claim the GCI tasks before you start to work on them! 😉

[milaaraujo]

Reopening this because we still need to add a link add to give more info on boolean searches and help users to understand how to use the boolean search. This link is a good one to use: https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

[jonxuxu]

I added the link as a comment in line 40, is that sufficient?

[milaaraujo]

@JonathanXu1, no... We need to add the link for the publiclab users on the website! ;)

[jonxuxu]

Oh sorry I misunderstood that. Could I get a pointer to the page in the website where boolean searches are made? Thanks!

[milaaraujo]

Sure!

• https://github.com/publiclab/plots2/blob/master/app/views/search/notes.html.erb
• https://github.com/publiclab/plots2/blob/master/app/views/search/wikis.html.erb

[CodeSarthak]

Is this still open? Can I work on it if @JonathanXu1 is not working on it?

[CodeSarthak]

Hi @milaaraujo Where is boolean search being implemented on the webpage, in the front end?

[jonxuxu]

I'd like to continue working on it but the task was not available when I tried to claim it. @milaaraujo here's the solution with a screenshot of a link in the frontend. Sorry I misunderstood the second requirement for the task.

Edit: The task is made available again. I claimed it and submitted it.

[milaaraujo]

Hey @CodeSarthak, @JonathanXu1 is already working on it. But we have a lot of available tasks!

@JonathanXu1, I will review it tomorrow. Thanks!

[CodeSarthak]

Ok @milaaraujo, but I think we are not so high on tasks right now. We have about 6-7 open tasks on GCI right now.

[jonxuxu]

Yeah if we could work on more tasks that would be great!

[milaaraujo]

We are working on open new tasks/issues! :)

[jywarren]

Hi, Jonathan - a bunch recently opened on Image Sequencer -- not sure if they have corresponding tasks in GCI yet, but we're def interested in help over there too! Thanks!!

…

On Mon, Nov 26, 2018 at 4:01 PM Camila Araújo ***@***.***> wrote: We are working on open new tasks/issues! :) — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#3490 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABfJ1yM1l0Q0exjsHog50rXCLaEkTwbks5uzFZ5gaJpZM4W5zur> .

[jonxuxu]

@jywarren I'd be glad to help! Perhaps we can open gci issues as we work on them haha