Queries in Zoho CRM

Queries in Zoho CRM

Hello everyone!

We are here with an exciting feature - Queries in Zoho CRM!

A little context before we dive right into the feature specifics :)

In today’s fast-paced business environment, immediate access to relevant data is essential for informed decision-making.
We are thrilled to announce Queries, a powerful feature that allows you to dynamically retrieve data from CRM as well as third-party services directly within our platform. With Queries, you can streamline your workflow, gain deeper insights, and make data-driven decisions without leaving the product.

Whether you fetch records from CRM or data from any other third-party services, the Queries feature gives you the power to present that data the way you want. For example, displaying only closed deals of a contact on a canvas or displaying the details of a ticket from Zoho Desk on a screen(Kiosk) in Zoho CRM.

All you have to do is write a query that solves your business need and associate that query with the relevant CRM feature like Canvas, Kiosk etc. This helps you leverage the power of data retrieval using REST API and COQL, along with schema management, serialization of responses, and other functionalities in data handling.

Let us consider a Canvas Detail View where Deals is a related list in the Contacts module. Here, a contact can have multiple deals associated, but you want to display only those that are won.

You can write a query with the required criteria to filter out the deals and simply drag and drop them on to your canvas just like how you include other components now. Simple, isn't it?

Read on to know more!

Components of Queries

  1. Query
  2. Source
  3. Variables
  4. Serializer
  5. Schema

1. Query

Query is a component of this feature that allows you to fetch data. You can set variables, serialize the response, and manage the schema during query creation.
Query configuration depends on the Source type. You can choose the source type as COQL, Modules, or REST API to construct your query.
  • COQL type is based on CRM's Object Query Language, very similar to SQL.
  • Module type is to retrieve the records from a module by selecting the module and its fields. You can also specify the conditions to filter records.
  • REST API type is to retrieve data from external services.

2. Source

A source is the data provider.
Zoho CRM provides pre-configured sources like COQL and Module in Queries to fetch records from Zoho CRM. Apart from this, you can also create your own source in the REST API standard to fetch data from other services.

Info
Right now, you can add a source as a REST API. Future enhancements will allow you to have sources like GraphQL, Databases like MYSQL & PostgreSQL, Cloud Databases from AWS, Azure and Google Cloud, OData Protocols, etc. This broadens the range of services you can connect with Zoho CRM and simplifies data handling.

3. Variables

Queries allow you to use dynamic variables in the query for module criteria, COQL statement, endpoints, headers, etc,. When you are testing the query, a pop up asks for the test value of the variable.
However, you should pass the values of the variables(like merge fields) to the query during association.


4. Serializer

Serializer lets you modify your response using JavaScript to use it for further processing. For example, you can combine the Full_Name and Designation fields in the Leads module to be displayed as Full_Name (Designation) in the response using the serializer.


5. Schema

Schema refers to the path of each field in the result of the query. You can alter the schema to suit the field types in CRM and change their labels to suit your needs.


Association of Queries

Queries is a game-changer for users as all your data is available inside Zoho CRM's interface. Currently, you can associate queries in Canvas Detail view and show the responses of the query as "field name and value" or a list.
In Kiosk Studio, you can associate a query and use it in a screen or in the criteria component.

Canvas Detail View

Use case

Fetch only those deals of a specific account whose stage is "Negotiation" through a query. Associate this query to a Canvas and add the fields of the query to it.
Step 1: Associate a Query



Step 2: Drag and drop the fields from the associated query on the Canvas.




Kiosk Studio

Use Case
Pass the user ID as an input from the first screen to the second screen where a query is used to fetch and display the user details.

Step 1: Enter the User ID to the input field on a screen.




Step 2: Associate and configure the required query to fetch and display the relevant user details. The query will take the user ID that was input in the first screen as a variable.








Queries can be associated with the "Decision" component of Kiosk, as well, as depicted in the following images.





Info
In future enhancements, you will be able to associate a query in various features of Zoho CRM, for example in the Canvas List View as a column, in Client Script to fetch data, in Standard Detail View/List View and etc.

Supported Editions

Queries is available for the Enterprise/Zoho One and Ultimate/CRM Plus editions, and will be available in the Professional edition soon.

Exciting, isn't it? We are sure this feature will save you tons of time!
Give it a try and let us know your comments.
You can read our documentation here.

Cheers!
Shylaja S
Zoho CRM
    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • Chat function not working properly

                                  Ever since upgrading to plus, the chat is all messed up. it is coming up behind the web page so that I cannot see what I'm typing and cannot read replies. I can only see the bottom of the text box at the bottom of the page, and then it is blocked. I've
                                • Change email template depending on answer from form

                                  Is it possible to set up the following in Zoho Desk: When a user submits a ticket via the Zoho Help Center's form, they can select an answer from a dropdown field. In this example, the dropdown options are 'Option A' and 'Option B.' If a user selects
                                • Self Client Authorization Issue

                                  Hi. Trying to test the api integration for Zoho Desk with the Self Client - Client Credintials flow method. I've created the self client, obtained the client id and secret, inputted "Desk.tickets.ALL" as my scope, and "ZohoDesk.[My Zoho Desk Org ID]"
                                • Mass pdfs into OCR field

                                  I am working on a Creator app that my org will use internally. Is there any way to mass upload pfs through a form with an OCR file upload field? Is Creator capable of this, or would I need to use Catalyst?
                                • Cannot fetch url with custom extension (sigma - javascript)

                                  Hello i try to make my first extension with API request, i have two cases 1) this a deluge code attach to a button --> this one works very well response = invokeurl [ url :"my_api_fetch_url" type :GET headers:{"api_key":"myapikey","accept":"application/json","content-type":"application/json"}
                                • Wrong Time on Exported Records

                                  Hello, All records in my exported Notes .csv file have the incorrect time for Created Time. They are all 8 hours ahead. I've already verified that my time zone is correct in both Personal Settings and Company Settings. Is there any way to fix this?
                                • how to upload the picture and document

                                  i want to upload the picture and document,would you please told how to upload them?could you told it for each step?
                                • Zia Call Intelligence only up 10 License

                                  I have been trying to install Call Intelligence for two days now, but strangely, the button is missing at this point. The documentation could be better, but most importantly, someone should inform small businesses like us that they don’t even bother enabling
                                • Forgot my email management account

                                  Hello, I am the administrator of ihomemix.com. I can’t remember which email address I used to register the account and then opened the email service for ihomemix. I can’t see the subscription period of my email function when I log in with this account.
                                • Can multiple agents be assigned to one ticket on purpose?

                                  Is it possible to assign one ticket to two or more agents at a time? I would like the option to have multiple people working on one ticket so that the same ticket is viewable for those agents on their list of pending tickets. Is something like this currently
                                • Add customer to account based on domain name.

                                  I generate reports based on a the account field, i.e. companyX.  In GoToAssist, my last provider, there was an option to automatically assign new ticket creators to a company (or account) based on their domain name. So for example, if a new employee creates a ticket from @companyx.com, for them to be automatically added to the companyx account would be a huge advantage.  As it stands right now, I have to remember to add them to the account manually.  Often I forget and when generating a report for
                                • Facilitate business processes by mandating Kiosks in your Blueprint's transition settings

                                  Hello everyone, We've made a few enhancements to Kiosk Studio. Blueprints provide a structured and systematic approach to executing business processes, and you can use Kiosks to build custom capabilities to retrieve, collect, and execute actions on CRM
                                • Response Violation - Zoho Desk

                                  Hi Team, I just need an information regarding the zoho desk - Response Violation and how can we avoid the tickets from getting the tickets response violated.
                                • I need help in setting up a script that works for my calling service

                                  Please i need your guidance and expertise in how to go about a particular scripting. You see, we are a call service that assists companies to receive calls for them, i need to create a system in my Zoho CRM whereby i will receive call from my already
                                • "Select All" item in the context menu

                                  In the Client on Android, there is a “Select all” item in the note’s context menu. There is no such item in the PC client. Can it be added in future versions of the client?
                                • Subir o Preço Unitário já acrescido de um valor

                                  To com um desafio grande, e se alguém conseguir me ajudar, seria ótimo! O que eu preciso é que o na hora de adicionar um item no subformulário dos itens cotados do módulo Orçamentos, o preço de lista do item venha acrescido de 20% automaticamente e de
                                • Zoho CRM Customer Portal Pricing Question

                                  Hello, I am trying to find out about the pricing for a portal that will be used for the contacts and a custom module. My client needs to use a customer portal for 15k users that will display the contact details and some informations to a linked custom
                                • How to display Motivator components in Zoho CRM home page ?

                                  Hello, I created KPI's, games and so but I want to be able to see my KPI's and my tasks at the same time. Is this possible to display Motivator components in Zoho CRM home page ? Has someone any idea ? Thanks for your help.
                                • Zoho developer edition does not work for us

                                  Hi Is anyone else having this problem? I'm signed in with our admin/super user account. When I click on the link on this page: https://www.zoho.com/crm/developer/docs/dev-edition.html I am asked to agree to Terms and Conditions. Clicking Agree to Terms
                                • is zoho CRM down today ?

                                  Is zoho CRM down today ?
                                • Export email adresses to email service provider (mailchimp or other)

                                  Hello, Is there a way to export a list of email adresses from a search in my Zoho Creator forms to an external email service (gmail, yahoo...) and initiate at the same time an email message that I will fill and send myself ? And what about Mailchimp,
                                • is it possible to add more than one Whatsapp Phone Number to be integrated to Zoho CRM?

                                  so I have successfully added one Whatsapp number like this from this User Interface it seems I can't add a new Whatsapp Number. I need to add a new Whatsapp Number so I can control the lead assignment if a chat sent to Whatsapp Phone Number 1 then assign
                                • Remove 30-Day Client Reply Restriction on Supervisor Rules in Zoho Desk

                                  Dear Zoho Desk Team, I hope you're doing well. Currently, Supervisor Rules in Zoho Desk run once every hour but only apply to tickets that have received a customer response within the past 30 days. This restriction creates challenges for us, as we have
                                • Problem viewing document imported from google drive.

                                  Hello, When I add a document via my google drive, it is impossible to preview it. I get the error “Files without extensions cannot be previewed. Download to view this file”. Could you please help me? Also, and this is more of a question: is there a way
                                • Launch Blueprint or Workflow Automation via Zoho Dataprep Import

                                  Greetings All, I'm curious - Is it possible to trigger a Blueprint or Workflow via Data Prep import? Thanks in Advance
                                • Cross module filtering is now supported in CRM

                                  Editions: All DCs: All Release plan: This enhancement is being released in phases. It is now available in AU, JP, and CN DCs. Help resource: Advanced filters While the feature is being released in phases, you can also request for Early Access. Early Access
                                • Send Supervisor Rule Emails Within Ticket Context in Zoho Desk

                                  Dear Zoho Desk Team, I hope this message finds you well. Currently, emails sent via Supervisor Rules in Zoho Desk are sent outside of the ticket context. As a result, if a client replies to such emails, their response creates a new ticket instead of appending
                                • Posibility to add Emoticons on the Email Subject of Templates

                                  Hi I´ve tried to add Emoticons on the Subject line of Email templates, the emoticon image does show up before saving the template or if I add the Emoticon while sending an Individual email and placing it manually on the subject line. Emoticons also show
                                • Integrating Zoho Desk Instances from two separate organizations

                                  Is it possible to integrate Zoho Desk with an instance from another organization? For example, creating a ticket in one organization can cause the creation of a ticket in the second organization? Or certain tickets from one organization be viewable by
                                • Paid Support Plans with Automated Billing

                                  We (like many others, I'm sure) are designing or have paid support plans. Our design involves a given number of support hours in each plan. Here are my questions: 1) Are there any plans to add time-based plans in the Zoho Desk Support Plans feature? The
                                • Bulk Delete Customer Contacts.

                                  Due to a config issue on my end (my fault), I have ALL contacts from CRM imported as contacts in Books. Some clients have 30+ contacts. Is there a funky way to bulk delete? Each contact has three clicks and a scroll to delete them.
                                • Multiple domains for same username and password

                                  I've come across this situation the vault is currently suggessting the passwords autofill option by the domain. wondering whether is there any option to save one password for multiple domains since the microsoft login has two domains https://login.microsoftonline.com/
                                • Option to specify or disable "Idle" times in preferences

                                  It seems strange to me that my Cliq shows me as "Idle" when I'm using the PC and available just because I haven't interacted with Cliq in a while.  I'm far from "Idle" so we're just treating "Idle" and "Available" to mean the same thing.  I'd like to suggest a setting to change the timeout or even disable the automatic "Idle" mode.
                                • Link project tasks to tasks in CRM and/or other modules.

                                  Hello, I have created and configured a project in Zoho Projects with a set of tasks. I would now like to link these tasks (I imagine according to the ID of each one) to actions in the CRM: meetings, tasks, analytics). The aim is to link project tasks
                                • Function #61: Automatically add free item to the invoice based on item quantity

                                  Hello everyone, and welcome back to another Custom Function Friday! During holiday seasons or special promotions, businesses offer deals like BOGO (Buy One, Get One), Buy 3 Get 1 Free, Buy 2 at 50% off, and much more to attract customers. These promotions
                                • Regarding GST Report Issue in Zoho Books

                                  Hi, Right now, the very important point from my end is this Zoho Books issue. Here, you can see that we have created the invoice with the items of account sales and expenses. The journal is also correct. The profit and Loss statement is also correct.
                                • Multiple Salesperson against an invoice

                                  Hello, Against a particular invoice, we have multiple sales people working. The reason we combine the invoice is becuase we are an exporter and often consolidate cargo for our customer to save them freight costs. How do I capture the contribution of each
                                • Projectwise budget ---

                                  Can we have a Project wise subject in addition to the Monthly, and quarterly ACCOUNT LEVEL budget?
                                • UI Arabic

                                  can i change the member portal UI to arabic in zoho community?
                                • Looking back at Zoho Social's 2024: Highlights and memories

                                  Hey everyone, We hope you had a relaxing and joyous holiday season. Whether you're planning for the new year or still soaking in the magic of the season, we're here to share some exciting highlights from 2024 – a year that was fully packed with updates
                                • Next Page