Forums - Thread Details
  • State Not Answered
  • Replies 2 replies
  • Subscribers 321 subscribers
  • Views 469 views
  • Users 0 members are here
Related

Search or Filter Records from Module

john Fieldsend

Hi All,

Im creating a live search module for our wordpress website and want users to be able to search our sugarcrm knowlege base module

I was wandering if anyone had used filter or search and if they had noticed any performance  differences in the two. I wan to create this as a live search so results will change as a user types 

reading https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.9/Integration/Web_Services/v10/Endpoi… 

it says module has been added to the search endpoint put when i add this to my GET request  i get 

{
    "error": "no_method",
    "error_message": "Could not find a route with 2 elements"
}

 my query is 

http://mc.sugarcrm.localdev/rest/v11/search/KBContents?q=test&max_num=5&offset=0&fields=&order_by=&favorites=false&my_it… 

we use sugar cloud  Ent v9

  • 0

    Can someone help with my understanding here, i have tried using the globalsearch but this will only return exact matches to the q parameter. I thought id create my own custom endpoint and use mysql match to do a full text search

    SELECT
         kb.id,
         kb.name
    FROM
        kbcontents kb
    WHERE
        MATCH(kb.name) AGAINST(
            'my printer' IN NATURAL LANGUAGE MODE
        )

    however this throws an sql error as fulltext index is not created on this table, but i thought that if you made a field searchable in studio where is asks Full Text Searchable

    Im now confused as this doesn't seam to alter the table and add the full text index

    Anyone know how i can create an effective search of knowledge based name and content fields for a phrase but not nessacry an exact match

  • 0

    Am using globalsearch to now achieve what i want as I couldn't see how to get the search endpoint to search only a certain module. Is this the correct base way to search sugar?