Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming criteria is required, the following 28 results were found.

  1. ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

    An example of code using the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. Not sure about the rest of you, but I've been using this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho People: Get Performance Records over APIhttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    m_Columns = Map(); m_Columns.put("columns",m_OutputRecord); m_Columns.put("criteria","\"Performance Objectives / Goals\".\"ObjectiveRecordID\"='" + p_RecordID + "'"); m_Columns.put("addIfNotExist",true); m_Params = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  3. Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    "myAdminAccount", "myApp", "myForm", v_RecordID, m_Params, "myzohocreatorconnection"); Successful Response: { "criteria": "ID==1234567890123456789", "newvalues": [ { "FieldToUpdate": "ValueToUpdateWith" } ], "status": "Success" } Method #2: Using API v1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  4. ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    duplicate lead (if a lead exists with the same email as a contact): // init v_Count = 0; v_CountDeleted = 0; // // sort criteria for our selection m_Criteria = Map(); m_Criteria.put("sort_order","asc"); m_Criteria.put("sort_by","Modified_Time"); // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    */ // // -------------------------------------------------------------------- // using Analytics API v2.0 (this time with criteria) // // get contact email and related surveys r_ContactDetails = zoho.crm.getRecordById("Contacts", p_ContactID);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  6. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/else/app-dev/android-os/basic-android-app-using-google-maps-and-current-location.html

    LocationManager locationManager = (LocationManager) getSystemService(Context.LOCATION_SERVICE); // Create a criteria object to retrieve provider Criteria criteria = new Criteria(); // Get the name of the best provider String provider =...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  7. Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    var v_ConsultantLocation = ZDK.Page.getField('Location').getValue(); // only run the rest if record matches criteria if (v_CurrencyCode == "GBP" && v_ConsultantLocation == "UK") { // get value of trigger field var v_RateCard =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-check-shipment-status-via-dhl-api.html

    to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map(); m_Criteria.put("date",v_Date); // // retrieve all shipment orders...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    number of employees, we will use zoho.people.getRecords as a search: // get total "team members" in department l_SearchCriterias = List(); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","Department");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  10. Zoho CRM: searchRecords with sorted resultshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    list of pages to the number of pages you want to search. Keep in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    { if(!isnull(r_Data.get("id"))) { v_SearchEndpoint = "https://recruit.zoho.com/recruit/v2/Candidates_x_JobOpenings/search?criteria=(CustomModule6_Name:equals:" + v_CandidateZohoID + r_Data.get("id") + ")"; l_CheckExists = invokeurl [ url...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  12. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    Configuration > Compose > Email Signature as in the following screenshot: This function generates all email signatures (no criteria). You will need to change the HTML signature and use the Image Source URLs returned from the above function to generate a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://joellipman.com/articles/crm/zoho/zoho-books/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

    = Map(); m_Header.put("ZANALYTICS-ORGID",v_ZA_OrgID); m_Params = Map(); m_Params.put("responseFormat","json"); // note how criteria column is denoted by double-quotes and a value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    COM_Invoke(pwb, "document.all.search_keywords.value") getElement Methods If you want to get an element(s) based on limited criteria, you can use the following 3 methods: getElementById(id) - returns a reference to the first object with the specified ID...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    So I could do it the long way in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx = "^[A-Za-z0-9._-]+@[A-Za-z0-9._-]+\.[A-Za-z]{2,}$"; v_MyString =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    = v_Name.toLowerCase()];... Returns the error: "Expression is not allowed in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    200 but can return up to 10000 records (NB: use endpoint https://www.zohoapis.com/crm/v7/coql). where can contain up to 25 criteria. Use parenthesis for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html

    that regenerates an access token or reuses if not expired). Thereafter, I use the GetMyeBaySelling API Call with specific criteria to only return the active listings as well as specific fields so my function doesn't get overwhelmed with the amount of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    looped through the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort criteria to be by order of cursor alphabetically; but we were happy with the results the above code did anyway so I haven't tried...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/component/content/article/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html?catid=129&Itemid=165

    under "Module" for the Rule Name, I called mine "Tickets - On Create or Edit" Execute On: Create, Edit, Customer Reply No Criteria Under 4. Actions, I click on "All Actions" and select "Custom Functions" Click on the Plus icon alongside this, scroll...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Desk
    • Language: *
Results 1 - 20 of 28