What are variables in Queries?

1. Filter By field
   
2. Criteria
   

1. Using record ID variable in the "Filter By" field

1. The base module is Contacts, and the related module is Products that is linked via the lookup field.
   
2. Choose the required fields you want to retrieve through the query.
   
3. In Filter by, select Record ID.
   
4. Give the variable to hold the contact's ID in the Record ID field. The format is {{variable_name}}.
   
5. The query assigns the ID of the contact dynamically during runtime.
   
6. Click Next.
   
7. A pop-up asks for the value of the variable.
   
   
8. Input the ID of the contact and click Save.
   
9. The response contains the fields that were queried for.
   
   

Benefits of having the record ID variable in "Filter by"

• Efficiency: Directly retrieves the relevant records, reducing the need to sift through unnecessary data.
  
• Simplicity: Easy to set up and understand, making it ideal for direct queries.
  

Considerations

• Limited Flexibility: May not be suitable for complex queries requiring multiple conditions or criteria.
  
• Specific Use Cases: Best used for scenarios where you have a clear and specific record ID to filter by.
  

2. Using Record ID Variable in Criteria While Fetching Related Records

1. Create a CRM - Module type query for the Deals module.
   
2. Choose Contacts as the Related Module.
   
3. Select the fields from these two modules that you want to retrieve.
   
   
4. Select "Criteria" and create a variable for the record ID of the contact.
   
   
5. Click Save and click Next.
6. Give a contact ID for the variable in the pop up.
   
   
7. Click Save and click Next.
   
8. You can see the response to the query.
   
   

Benefits of using record ID variable in "criteria"

• Flexibility: Allows for more complex queries with multiple criteria.
  
• Dynamic Data Retrieval: Useful for scenarios where the criteria for related records may change based on different conditions.
  
• Comprehensive Data: Fetches a broader range of related records, providing a more holistic view of the data.
  

Considerations

• Complexity: More suitable for complex queries and requires deeper understanding of how modules are related in Zoho CRM.
  

Conclusion

See Also

• Queries in Zoho CRM
  
• Kaizen #166 - Handling Query Variables in Zoho CRM
  
• Kaizen #169 - Serialization and Schema Management in Queries
  
• Kaizen #172 - Leveraging the 'crmAPIResponse' object in Queries
  
• Kaizen Directory
  
• Previous Kaizen - Leverage Settings Widget for Zoho CRM Extensions