Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 = Map(); m_Message.put("role",v_Role); m_Message.put("content",v_Content); l_Messages.add(m_Message); } } The one to rule them all So I've been asked here and on the forums as well for the full query that includes making ChatGPT keep the context of the...

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

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 a FAILURE ***/ But if I want it to join to my images table and with a bit more foresight (I plan to do a mega query to rule them all which has all the data for my widgets), I have to write it as such: SELECT 'CRM Accounts' AS "DataSource",...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 others hidden. Standard tabs such as Notes, Attachments, Emails, and Timeline should remain. Code will be needed as a layout rule couldn't control the tabs on a canvas view page. An additional function is needed as the pipeline was not displayed on the...

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

Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html

03 August 2012 Internal table P = SQL Stored Procedure PC = Assembly (CLR) stored-procedure PG = Plan guide PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) RF = Replication-filter-procedure S = System base table SN = Synonym SQ = Service queue TA =...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *