Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming searchname is required, the following 3 results were found.

  1. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe for sql v_SearchName =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *

  2. Zoho CRM: Remove Duplicate Product Recordshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    more api calls if occurs more than once if(v_Frequency > 1) { // // replace apostrophes with double apostrophe for coql v_SearchName = v_ProductName.replaceAll("'","''",true); // v_KeepID = 0; // // get other products with the same name (set in order of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  3. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by id limit " + v_PerPage}; r_CoqlSortedProducts = invokeUrl [ url :"https://www.zohoapis.eu/crm/v7/coql" type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 1 - 3 of 3