Search API Help

27228

How can I call the search api to only return results where my search criteria is found in a particular column. For example, I want the results to contain all records where the word "test" is found in the matter name only but not where the word test is found in other columns.

 

This is the body I am passing in, I assume this would force it to search on columnid 39005 only but that does not seem to be the case.

{

"allofthesewords": "test",

  "data": {

    "item": [

      {

        "column": [

          {

             "columnid": 39005

          }

        

      }

    ]

  }

}

Results:

isheet 1, mattername=test, assignee=darren

isheet 2. mattername=blah blah, assignee=test

 

In the above scenario, I only want isheet1 to be returned

 

I have also tried creating a view that just contains column 39005 and calling the search api on that view only, but still the other items are returned.

Also, the allColumnRequired=false parameter does not seem to be working in this scenario as all columns are being returned, I would have thought it would respect the columns in the view and return just column 39005?

 

 

 

]]>
Parents
  • Brilliant, thank you so much for your help Andrew Quinn that's sorted it!

Reply
  • Brilliant, thank you so much for your help Andrew Quinn that's sorted it!

Children
No Data