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 26 results were found.

  1. ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  2. Basic Android App using Google Maps and Current Locationhttps://www.joellipman.com/articles/google/androidos/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: *
  3. Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: en-GB
  4. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  5. Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  6. ZohoDeluge: Check Shipment Status via DHL APIhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  7. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  8. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  9. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  10. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  11. ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  12. Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

    mandate) Review milestones (tasks) as set in the project management system Review original deliverables and success criteria Satisfied? Can be quoted? Portfolio screenshots. Service Level Agreement Post-project support to be arranged prior to launch...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  13. URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

    &rc:BookMarkID=1 Provide search criteria and find the first instance http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:FindString=foo Note: I have no idea what this is for. Render a snapshot...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  14. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    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. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    Table: Drag StaffName to Columns, Resource to Row and PersonDays to Values Tick a field that will be the parameter/filter/criteria (it will be automatically added to row or column), then click on it and select "Move to Report Filter". Shout in Gordon...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  16. SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    In addition, we also need a second dataset in our report which gets the total count of all the rows matching the selection criteria (the parameters). The concern was that this would make the report just as slow but the count only returns a number to be...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. Import Excel CSV file as JavaScript arrayhttps://www.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    file launching this function (not from the if external JS)) // add parameters to this function to specify rows based on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array = populate_array_from_csv('./mydata/data.csv');...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  18. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  19. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/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
    • Language: *
  20. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/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
    • Language: *
Results 1 - 20 of 26

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.