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

26 October 2012 ** Author: Joel Lipman ** ** Created On: 26 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to list distinct values and counts (defaults to case and accent-sensitive). ** ** ** ** Usage: ** ** EXEC [usp_ListDistinctValuesAndCounts]...

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

Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 ) AS /*********************************************************************************** ** Author: Joel Lipman ** ** Created On: 29 October 2012 ** ** Revision: v1.0 ** ** Description: Stored Procedure to return counts of records per staging database...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why?...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 name if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or listed building. Dynamic Zones are created using data fed for...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The fix that I use involves...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 - Added Thumbnail Service: PagePeeker.Com - Removed Thumbnail Service: FreeWebsiteThumbnails.Com - Parameter: Date created or date modified - Parameter: Parameter "More Links" prefix text (moved from language file) - Critical: Fixed Custom Order by...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 some point for my colleagues. The below instructions follow a fresh install as if this is the first time this computer has created a Zoho Creator Widget. Software used: Zoho Creator v5 (Plan Premium or greater is required - includes Zoho One) macOS...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 "details": { "Modified_Time": "2021-05-17T11:02:59+01:00", "Modified_By": { "name": "Joel Admin", "id": "123456" }, "Created_Time": "2021-05-17T11:02:59+01:00", "id": "98498465735491156", "Created_By": { "name": "Joel Admin", "id": "123456" } },...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 OpenAI ChatGPT API but at the same time retain the context of ZohoCRM Inputs: string userInput Outputs: map m_Response Date Created: 2023-02-08 (Joel Lipman) - Initial release - Queries OpenAI ChatGPT Date Modified: 2023-03-11 (Joel Lipman) - Stores...

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

ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 via Email Create an app as described under Get Access section Click My Apps on the portal website Click on the App you created Note the API Key by clicking on "Show Key" The deluge function So this function will return the word "delivered" or whatever...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 and write to a CRM quote record. The code: This is the code used in a workflow triggered within ZohoCRM when a Quote is created or modified: // // initialize v_BooksOrgID = 123456789; v_BooksCustomerID = 0; m_CreateEstimate = Map(); l_CrmBillingAddress...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 WorkDrive.organization.READ, WorkDrive.teamfolders.ALL, WorkDrive.links.ALL, WorkDrive.DataTemplates.READ Date Created: 2023-12-05 (Joel Lipman) - Initial release - Uploads an image to workdrive and returns the public link Date Modified: ??? - ???...

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

Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

23 May 2024 because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is created to do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 triggering eBay’s validation process, which requires your endpoint to successfully reply to eBay's challenge code. So I created a function within ZohoCRM to return the challenge and made it into a REST API function with a zapikey. I entered the URL...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 change Purpose: Prepares the invoice as a deposit invoice or final balance invoice Inputs: string value Outputs: - Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 script to retrieve the pipeline given a deal record id Inputs: Deal Record ID Outputs: the value of the pipeline Date Created: 2025-05-06 (Joel Lipman) - Initial release Date Modified: ??? - ???...

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

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

09 October 2025 a name, I'm calling mine Invoice TBC Give it a description. I said "Sets the subject/name of the invoice to TBC when first created. Maps values from the related quote if loaded from somewhere other than converting quote to invoice.". Note that I have a...

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

SITS: XET format for Export not availablehttps://joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to see what...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 Purpose: Actions when a quote is modified Inputs: int p_QuoteID - the ID of the CRM Quote Record Outputs: void Date Created: 2024-12-10 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created earlier Pointed a test.joellipman.com domain to the 2025 folder. Visited the test.joellipman.com to run through the Joomla...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *