Hi everyone!
This post is to inform all the developers who work with functions (DRE) of an update to Search Records.
We all know the Search Records API filters records based on certain criteria and gives the response.
You can make the search records request from one of the following places:
When you search for records through a function (with a single criterion), your criterion can contain one of the comparators such as not_equal, greater_equal, greater_than, less_equal, less_than, or between. However, these operations are complex and amount to a great load on the server.
So, we would like to inform you that we will disallow the usage of these comparators in a search request for all the new users that sign up from September 15, 2020.
However, all users can achieve the same functionality of each of these comparators through the Query API(COQL).
The following table gives you the COQL equivalent of every comparator in the function call.
Comparator
| Function (DRE)
| Query API (Request body)
|
greater_equal
|
zoho.crm.searchRecords('Deals', 'Amount:greater_equal:45000')
| {"select_query": "select id,Deal_Name from Deals where Amount >= 45000"}
|
greater_than
| zoho.crm.searchRecords('Deals', 'Amount:greater_than:45000')
| {"select_query": "select id,Deal_Name from Deals where Amount > 45000"}
|
less_equal
| zoho.crm.searchRecords('Deals', 'Amount:less_equal:45000')
| {"select_query": "select id,Deal_Name from Deals where Amount <= 45000"}
|
less_than
| zoho.crm.searchRecords('Deals', 'Amount:less_than:45000')
| {"select_query": "select id,Deal_Name from Deals where Amount < 45000"}
|
not_equal
| zoho.crm.searchRecords('Deals', 'Amount:not_equal:45000')
| {"select_query": "select id,Deal_Name from Deals where Amount != 45000"}
|
between
| NA
| {"select_query": "select id,Created_Time from Events where Created_Time > '2020-06-30T00:00:00+05:30' and Created_Time < '2020-08-26T00:00:00+05:30'"}
|
Cheers!
Shylaja
Zoho CRM