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

  1. Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *

  2. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    that might work and were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were. The main revelation was the function getEmployeesOnLeave and perhaps this can be combined...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *

  3. Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-map-quote-to-invoice.html

    onLoad Purpose: Loads in a "TBC" so that the the naming of the invoice can happen on save Maps other fields to fill in the blanks Inputs: - Outputs: - Date Created: 2025-10-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *

  4. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    ? "" : This_String ISNULL(This_Date) ? NULL(DT_DATE) : (DT_DATE)This_Date ISNULL(This_Date) ? "" : (DT_STR)This_Date -- if blanks LTRIM(This_String)=="" ? "" : LTRIM(This_String) LTRIM(This_Date)=="" ? (DT_DATE)"1900-01-01" : (DT_DATE)This_Date -- last...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  5. T-SQL Record Separatorhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-record-separator.html

    the different days which is either blank or full of hyphens/dashes. Stage #2: Replace values in last data row with blanks The trick to this is to get Stage #1 working for you with your query and then for every column of data that you are extracting, you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  6. A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

    parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are included in the output or not. Select and right-click on the entity and select "Edit... exchange fields" (in this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *
Results 1 - 6 of 6