COQL queries follow SQL syntax: SELECT field1, field2 FROM Deals WHERE Stage = 'Proposal Sent' AND Amount > 100000 ORDER BY Created_Time DESC LIMIT 10. Queries are executed via the Zoho CRM REST API endpoint or within Deluge using zoho.crm.searchRecords() with the COQL parameter.
COQL supports: basic field comparisons, IN and NOT IN operators, LIKE for pattern matching, IS NULL and IS NOT NULL, joins across related modules (up to 2 levels), and aggregate functions like COUNT, SUM, MIN, MAX.
The standard searchRecords API supports simple criteria-based filtering but is limited in flexibility. COQL offers full SQL-style querying with multi-field conditions, sorting, field selection, and cross-module joins. For any complex data retrieval in Deluge scripts or external integrations, COQL is the preferred approach.
SELECT Deal_Name, Account_Name, Amount, Stage, Owner FROM Deals WHERE Closing_Date >= '2026-04-01' AND Stage != 'Closed Lost'. The COQL query returns exactly the fields needed for the analytics dashboard, avoiding the need to fetch all deal fields and filter in the receiving application.COQL (CRM Object Query Language) is Zoho CRM’s SQL-like query language for retrieving records. It supports SELECT, WHERE, ORDER BY, LIMIT, and JOIN operations, allowing developers to fetch precisely the CRM data they need in API integrations and Deluge Custom Functions.
Yes. COQL supports joins across related modules up to 2 levels deep. For example, you can query Deals and include fields from the related Account and the Account’s parent Account in a single COQL query.
Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.