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

  1. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search Records via API I won't go into detail on how to set up your own connection as I have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    involved, plus the documentation online was in parts and requires going to several pages across the Internet. Here I have 1 page and 1 article documenting the process. How? I'm breaking this down into 3 stages: Zoho Creator: Specify Custom Domain Domain...

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

    Name (eg. "Shopify API Oauth") Enter the Shop ID (eg. "example-store.myshopify.com") Give it an API version (eg. "2022-01" - or whichever is the latest stable version) Location ID if you know it, otherwise leave blank (eg. "123456789") Location Code if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    // yields // https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567890,https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567891 Note that for the below code, only 1 image is accepted at the moment, and the endpoint will depend...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    to ChatGPT. The plus side however is that it is connected to the Internet unlike ChatGPT which only has information up to 2021. How? The basics of setting this up would be to setup a bot in ZohoCliq and then to edit either a message handler or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  6. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    thought it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date Created: 2023-03-01 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: - API Explorer Test Tool:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: 21917182) - Modified to check that there are some orders. More Info: - API Explorer Test Tool:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  8. Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    = 0; for each c_ImageRow in c_TicketRecord.Images { v_ImageRowID = c_ImageRow.ID.toString(); v_CountImages = v_CountImages + 1; v_ImageHtml = ifnull(c_ImageRow.Image,""); if(v_ImageHtml.contains("\"")) { v_ImageSrc = v_ImageHtml.getSuffix("\"");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    the header on every page. The key here is the HTML attribute zcpage-headerhtml: My Company Ltd Test Street, Test County TEST1 ZIP1 +44 (0)1234 567890 sales@mycompany.com QUOTE The Quick Answer: the footer This repeats the footer on every page. The key...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    name and ID, this avoids the need of using up an API request to get the portal v_PortalName = "my_portal"; v_PortalID = "789456123"; // // get all projects v_EndpointProjects = v_BaseURL + "/restapi/portal/" + v_PortalID + "/projects/"; r_Projects =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  11. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    results from Analytics into the corresponding Zoho CRM record. Inputs: String crmAPIRequest Outputs: - Date Created: 2025-09-19 (Joel Lipman) - Initial release - Identifies a survey by email Date Modified: 2025-10-06 (Joel Lipman) - Clients wants a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    be reformatted back onto a single line. How? Below are three examples demonstrating multi-line assignments in Zoho Deluge. 1) Multi-line string concatenation, converted into a map This builds a JSON string over several lines, then converts it into a map...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. View your available module positionshttps://www.joellipman.com/articles/cms/joomla/view-your-available-module-positions.html

    for Joomla 2.5.x Note that Joomla versions 1.6 upwards include this as an option in the global configuration settings which you can access using your Joomla admin panel: Template Manager Options Preview Module Positions -> Disabled or Enabled You will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  14. ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

    a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  15. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    I installed and uninstalled just as quickly as they failed to properly reflect IE6 and IE8 features (& bugs?). IECollection v1.6.0.6 Multiple IE Installer v? (Old and unstable...) Browser Sandbox (Need IE and install their plugin - does not reflect my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  16. Reorder Columns in a Tablehttps://www.joellipman.com/articles/else/database/reorder-columns-in-a-table.html

    interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns Method: phpMyAdmin So in the phpMyAdmin interface, apparently, you can drag the columns by clicking and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  17. Compare two databases using T-SQLhttps://www.joellipman.com/articles/else/database/t-sql/compare-two-databases-using-t-sql.html

    possibly be cheap. MS SQL Server Management Studio (SSMS) comes included so use it... How? Well I started with the method #1 listed here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT *...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  18. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    similar to this: ID SetID WeekNumber StartDate --------- ---------------- ---------------------- ---------------------------- 1 2011/2012 1 2011-07-18 00:00:00... 52 2011/2012 52 2012-07-09 00:00:00 Joe you're an idiot! You might say to me why not run...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  19. MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/else/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

    as `value` FROM ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, '//text()'), ' ', n.n), ' ', -1) `value` FROM `mydbprefix_content` t CROSS JOIN ( SELECT a.N + b.N * 10 + 1 n FROM (SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  20. Web Browsers Release Yearhttps://www.joellipman.com/articles/cms/website-development/web-browsers-release-year.html

    Source: http://en.wikipedia.org/wiki/Comparison_of_web_browsers Year Web Browsers Internet Users (in millions) 1991 WorldWideWeb 1992 ViolaWWW, Erwise, MidasWWW, MacWWW 1993 Mosaic, Cello, Lynx 2.0, Arena, AMosaic 1.0 1994 IBM WebExplorer, Netscape...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
Results 141 - 160 of 337