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

  1. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    BEGIN -- Declare some variables to use DECLARE @ColToProcess varchar(max), @SqlToExecute varchar(max), @myXml xml; -- Parse comma delimited string into a table SELECT @myXml = CONVERT(xml,'' + REPLACE(@p_SearchColumns,',','') + ''); DECLARE Cursor1...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  2. Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

    BEGIN -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  3. Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

    for a User Product means any methods, procedures, authorization keys, or other information required to install and execute modified versions of a covered work in that User Product from a modified version of its Corresponding Source. The information must...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  4. Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

    for how to do this in VB or C#. This version is entirely using T-SQL and we're going to use a function so no dynamic SQL (execute, evaluate). Method #1: First version This was my first attempt based on snippets around the web. This one has two sections,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  5. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    $url); curl_setopt($ch,CURLOPT_POST, count($fields)); curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string); // execute post $result = curl_exec($ch); // close connection curl_close($ch); Things I stumbled upon regarding SSL and cURL Posted data for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  6. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

    storeCredentials($STORE_PATH, $credentials); return $credentials; } Include the following at the end of all of this and to execute the functions but before any outputs (HTML or JS): $credentials = authenticate(); To view these or output to screen:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

    A combined all-in-one solution The following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then paste the below into the developer window. Ensure that your mouse cursor has focus in the first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    Field Start Date: select form and choose Modified_Time Run this process on condition "Attached Files in CRM equals false" Execute Workflow "After 2 Minutes" Repeat Interval = Once Name the workflow > Create Workflow Give it the code // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    2.txt My File 3 (2).wav My File 3.wav My File 3 (3).wav How? So if you copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  10. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

    Don't worry about knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through the installation process with the final step to move it to trash/bin. Open the terminal app on your Mac...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    Quote History" and it is a report on the form "Partners Quote": Add new action item Name your action item Name the workflow Execute the action for Collection of record (this step is very important!) And you should have something like the following:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

    approval, or blueprint. If trigger is not mentioned, the workflows, approvals, and blueprints related to the API will get executed. Enter the trigger value as [] to not execute the workflows. Source(s): Insert Records API

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    on Mail Merge, which opens Writer, then has to click on various settings and run the Mail Merge; then has to click on "execute function after merge" and select the function to run (this would initially attach the file to the CRM record). This wasn't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    = ""; v_AccessToken = ""; r_Response = getUrl("https://www.zohoapis.com/crm/v2/functions/fn_api_getxeroaccesstoken/actions/execute?auth_type=apikey&zapikey="); if(!isnull(r_Response.toMap().get("details"))) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. 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

    Function: void fn_AB_GenerateVacanciesCandidatesAssociations() Workflow: - Trigger: Standalone function triggered on execute Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening Date Created:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

    stripe terminal payments. OAuth URL: https://www.zohoapis.com/books/v3/settings/incomingwebhooks/iw_stripe_terminal_payment/execute?auth_type=oauth Inputs: invoice Outputs: - Date Created: 2023-03-23 - Initial release - been successfully proccessed by...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    Click on "Create Rule" Select "Tickets" 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

    held belief, method-chaining still counted as separate statements; this is not true as the following counts 3 statements executed prior to the loop: // l_LoopInnerInner = " ".leftpad(5000); l_LoopInner = l_LoopInnerInner.replaceAll(" ", ","); l_Loop =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

    Function: string standalone.fn_eBay_AlertNotification(String crmAPIRequest) Trigger: Function executed when a webhook from eBay is sent to ZohoCRM (Market Deletion Webhook) Purpose: eBay Marketplace Account Deletion/Closure Notifications Workflow...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 40 of 40

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.