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

  1. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    = if(v_CrmProductName.length() >= 200,v_CrmProductName.subString(0,199),v_CrmProductName); v_CrmProductNameSafe = zoho.encryption.urlEncode(v_CrmProductName); v_SearchCriteria = "Product_Name:equals:" + v_CrmProductNameSafe; l_SearchProducts =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Windows 10: Shortcut Apps to Settingshttps://joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    Duplicating my display ms-settings:quietmomentspresentation During these hours ms-settings:quietmomentsscheduled Encryption ms-settings:deviceencryption Focus assist ms-settings:quiethours ms-settings:quietmomentshome Graphics Settings...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  3. DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    ; GO -- Create user defined function CREATE FUNCTION ufn_DataJumble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  4. DataScramble - Randomizing data rowshttps://joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    ; GO -- Create user defined function CREATE FUNCTION ufn_DataScramble ( @OrigVal varchar(max) ) RETURNS varchar(max) WITH ENCRYPTION AS BEGIN -- Variables used DECLARE @NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. Accessing Apimo WebService APIhttps://joellipman.com/component/content/article/accessing-apimo-webservice-api.html?catid=109&Itemid=165

    $apimo_version = 2; // specify data output $apimo_method = 'getAgencies'; $apimo_type = 'xml'; // specify key and encryption $apimo_key = 'abcd1234abcd1234abcd1234abcd1234abcd1234'; // specify your assigned key here $apimo_sha =...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
Results 21 - 25 of 25