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 coqlquery is required, the following 5 results were found.

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

    ampersand with unicode value v_SearchName = v_SearchName.replaceAll("&","\u0026",true); // // build up COQL query v_CoqlQuery = "select id from Accounts where Account_Name='" + v_SearchName + "'"; // // build up parameters m_Params = Map();...

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

  2. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    Documentation and even on this website so we'll skip to the COQL query. This is what I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map();...

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

  3. Zoho CRM: Schedule a Task: Timesheet Reminderhttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

    00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = "select Start_DateTime, End_DateTime from Events where Created_By='" + v_UserID + "' and ("; v_CoqlQuery = v_CoqlQuery +...

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

  4. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    } } } // // start building conversation trail l_ConversationMessages = List(); // // build up COQL query v_CoqlQuery = "select Content, Role from GPT_Chats where Owner='" + v_LoggedInUserID + "' order by Created_Time asc"; // // build up parameters...

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

  5. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

    tag with the same name), then it only copies over the name: v_TotalCount = 0; v_TotalProcessed = 0; v_PerPage = 100; v_CoqlQuery = "select id, Contact_Name.Tag 'Tag' from Deals where Tag is null and Contact_Name.Tag is not null order by id asc limit " +...

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

Joes Word Cloud

Please publish modules in offcanvas position.