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 february is required, the following 6 results were found.

  1. Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

    will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames = {"January","February","March","April","May","June","July","August","September","October","November","December"}; Here's the standard code...

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

    yields I am Joe Not a regular expression but something I use to pad months and dates in a date format: v_MyString = 2; // February v_FormattedString = leftpad(toString(v_MyString), 2).replaceAll(" ", "0"); // yields "02"

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps created before February 2022 won't be deprecated? Because the previous version was limited by our ability to search by product SKU. The new version,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

    third server to try if the first 2 fail for whatever reason. How? Admittedly, perhaps this maybe wasn't possible but as of February 2024; I have been able to test and implement this. Consider the following code: try { v_Test1 = "Foo"; info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Delete related records from multiple tableshttps://joellipman.com/articles/else/database/mysql/delete-related-records-from-multiple-tables.html

    sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- Deletes all sessions dated after February 1st 2013 -- and all related records (linked by ID) in relevant tables. Delete from specific tables but not all Simply don't refer to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  6. Excel PivotTable Filter List Orderinghttps://joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row Labels" (put it at the top...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 1 - 6 of 6