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

11 October 2011 Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday The Official Gist Okay so the below article with the 3 stages can be a little confusing. When I wrote the support documentation which makes use of this little trick for my managers, I...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 par with Google and Wikipedia (or near enough). How? I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles...

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

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

28 August 2020 for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; // returns 2 deals after the first 400 records // OR v_CoqlQuery = "select id, Deal_Name from...

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

ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with a criteria: v_PerPage = 200; v_CountCriteria = "Quote_Stage:equals:Draft"; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count?criteria=" + v_CountCriteria; r_MaximumCount =...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 for each m_Deal in l_Deals { if(!isNull(m_Deal.get("id"))) { v_CountTotal = v_CountTotal + 1; if(m_Deal.get("Stage").equalsIgnoreCase("Cancelled")) { // // cancel all related quotes // (...) // // cancel all related sales orders l_RelatedSOs =...

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

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 projects but most people find this overwhelming. It's in business techno babble and I get asked what does this mean in stage 1? And this in stage 2? (There are over 100 stages)... Below is my template project initiation plan (project mandate?) for my...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Zoho CRM REST API: Stop Workflow from Triggeringhttps://joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 createRecord or updateRecord. Why? We had a Creator app updating a CRM record which in turn had a workflow to update the Stage in Creator (so a user can change the stage in CRM and it would reflect this in the equivalent Creator record). There was also...

• 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 table `#_user_usergroup_map` Viewing Articles in the Administrator panel: INSERT INTO `#_workflow_associations` (`item_id`, `stage_id`, `extension`) SELECT `id`, 1, "com_content.article" FROM `#_content`; UPDATE `#_content` SET `checked_out`=NULL,...

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

Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 REMOVE. - Changed code to loop through an array of files rather than the directory. - Added subtext to inform user at each stage of the process. - Added resize capabilities to the program. - Added more column details in the review list. v1.0...

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

Room with a view E.M. Forsterhttps://joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 it is impossible to rehearse life. A fault in the scenery, a face in the audience, an irruption of the audience on to the stage, and all our carefully planned gestures mean nothing, or mean too much."

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

MySQL: Find records in one table that are not in another.https://joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 into an executable and interface (almost as quick as google's chrome :c). Version 0.6 beta is ready. I've left it in BETA stage without an official release because I'm the only one to have tested it and it works perfectly for me. And I guess I'll just...

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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 or ErrorLevel EXECUTE MY_PRETEND_STORED_PROCEDURE('value1','value2','value3',:errorcode,:errormsg) Still discussing this stage... Not proceeding with this as there may be a better way. In addition, SSRS was complaining about assignment targets not being...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 v_QuoteRef = ifnull(r_Result.get("Quote_Ref"),"-"); v_QuoteName = ifnull(r_Result.get("Quote_Name"),"-"); v_QuoteStage = ifnull(r_Result.get("Quote_Stage"),"-"); v_QuoteCurr = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal =...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 a third-party server (my example here is a LAMP server): Complete webhook setup by passing 'Intent to receive' required stage. Xero will test both a valid and invalid signed webhook. So I'm going to cheat, by setting up a PHP script on a server we own...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 means that the first-line agent would be referring to 2 status fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 see all 5 screens flicker to life.... Finally! I say the dreaded "should" because it took so many reboots to get to this stage that I lost track of all the different configurations. The 2nd diagram is the working configuration I have now. Note that I've...

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

Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 if 3 different skills are not specified in the subform: // initialize var v_CalculatedNumberOfSkills = 0; // get the Opp stage var v_OppStage = ZDK.Page.getField('Stage').getValue(); // get the Skills subform var l_SkillsSubform =...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 no avail. An assignment rule wouldn't work in this case as it had to be the lead owner (there is no owner at assignment rule stage). A workflow email notification doesn't do the popup on the CRM as well. A workflow notify by email didn't give the option...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 my device: Now I can select the image(s) I want to upload (unfortunately only 1 at a time): Create an Image Table At this stage, I'm going to create a table that holds the URLs of the images I want to use but if the image is hosted elsewhere, then this...

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