- 1. ZohoCRM: Integrate ChatGPT to ZohoZIA
- / Zoho /
- ... build up COQL query v_CoqlQuery = "select Content, Role from GPT_Chats where Owner='" + v_LoggedInUserID + "' order by Created_Time asc"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // ...
- Created on 06 March 2023
- 2. Zoho CRM: Schedule a Task: Timesheet Reminder
- / Zoho /
- ... sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = ...
- Created on 02 December 2021
- 3. Zoho CRM: Get Unique Values of a Text Field
- / Zoho /
- ... query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql ...
- Created on 08 October 2021
- 4. Zoho Deluge: Search Records with Special Characters (COQL)
- / Zoho /
- ... 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 + "'"; // // ...
- Created on 28 August 2020