search reviewer by interests

[MarieNyst]

Hi,

when I'm looking for a reviewer for an article, I would like to search by several review interests. But the search function seems to look for the exact term and don't cut the terms on several words to search.

Problem is :
if I have a reviewer with interests : word 1, word 2, word 3, word 4
I look for : word 2, word 1
this reviewer don't appear...
and if I look for word 1, word 2
this reviewer appear.

Is there any way to do this ?

[MarieNyst]

Well, I looked at source code and find how to fix it.
If ojs developpers see this (or if someone tell me who I have to join to suggest it to be changed on the official version) it's just a little detail :

in file \classes\submission\sectionEditor\SectionEditorSubmissionDAO.inc.php
line 767

replace this :

Code: Select all

$searchSql = "AND LOWER($fieldName) LIKE LOWER(?)";
$paramArray[] = '%' . $search . '%';

by this :

Code: Select all

$searchArray = explode(",",$search);
$n=count($searchArray);
if($n>0)
{
   $searchSql = "AND (LOWER($fieldName) LIKE LOWER(?)";
   $paramArray[] = '%' . $searchArray[0] . '%';
   for($i=1;$i<$n;$i++)
   {
      $searchSql .="OR LOWER($fieldName) LIKE LOWER(?)";
      $paramArray[] = '%' . $searchArray[$i] . '%';
   }
   $searchSql .= ")";
}

it split text on ',' and search all the terms.

with hope this will be usefull for someone else

[theodore]

thnx! very useful. Maybe could use the same to getCopyeditorsNotAssignedToArticle function.

[MarieNyst]

I'm happy to know that someone use it

there where a little bug on the above code, here is the revised version :

Code: Select all

$searchArray1 = explode(", ",$search);
               $m=count($searchArray1);
               $n=0;
               for ($i=0;$i<$m;$i++)
               {
                  $Array=explode(",",$searchArray1[$i]);
                  $j = count($Array);
                  for ($k = 0; $k<$j;$k++)
                  {
                     $searchArray[$n]=$Array[$k];
                     $n++;
                  }
               }
               if($n>0)
               {
                  $searchSql = "AND (LOWER($fieldName) LIKE LOWER(?)";
                  $paramArray[] = '%' . $searchArray[0] . '%';
                  for($i=1;$i<$n;$i++)
                  {
                     $searchSql .="OR LOWER($fieldName) LIKE LOWER(?)";
                     $paramArray[] = '%' . $searchArray[$i] . '%';
                  }
                  $searchSql .= ")";
               }

it cut the text on ", " (with a space char) and then cut it on "," (some reviewer were not found because of the space char)