Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 same material under section 10. 9. Acceptance Not Required for Having Copies. You are not required to accept this License in order to receive or run a copy of the Program. Ancillary propagation of a covered work occurring solely as a consequence of...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items , ROW_NUMBER() OVER (PARTITION BY EmployeeNo, DateOfSickness ORDER BY EmployeeNo, DateOfSickness) AS Rownum FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND...

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

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 The component I'm making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects WHERE...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 admin user can log in). Create a .htaccess file in your /administrator folder with the following content: # ALLOW USER BY IP order deny,allow deny from all allow from 123.123.123.123 # change 123.123.123.123 to your static IP address # PREVENT VIEWING...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 MsgBox 1: %v_Leftest% 2: %v_Central% 3: %v_Rightest% Now there is an issue in that Monitor 1,2, and 3 might not be in the order placed on the desk and not in the order of left to right. So the above code tries to determine the leftmost monitor and...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://www.joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 street 2 and shipping street 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in CRM. As my client's sales team would only create sales orders in CRM and don't use the invoice module (that's for their...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 description, tags and inventory details. This means the app needs to be able to sync all of its products, customers, and orders with Shopify as a 2-way integration as the Zoho app needs information from additional apps installed on the Shopify store....

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 // // search payments m_SearchCriteria = Map(); m_SearchCriteria.put("customer_id",v_CustomerID); m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // fetch all payments against this customer in order of...

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

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

08 February 2023 = 0; v_CountProcessed = 0; v_FromIndex = (v_Page - 1) * v_PerPage; v_ToIndex = v_FromIndex + v_PerPage - 1; // // note that ordering here seemed to do nothing... it's in an order, not sure what order. Let's loop through every page anyway. l_Candidates =...

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

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

25 July 2024 ) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified Time of Record If Modified Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago...

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one (referred to as keep ID). Another point is that this is using...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType =...

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

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

18 December 2024 invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function invokeURL rather than...

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

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

04 February 2025 SELECT m.`user_id`, m.`group_id`, u.`username`, u.`email` FROM `#_user_usergroup_map` m JOIN `#_users` u ON u.id = m.user_id ORDER BY `group_id` DESC; UPDATE `#_user_usergroup_map` SET `group_id`=2 WHERE `user_id`111 AND `user_id`222 AND `user_id`333;...

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

Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 issues with one of the servers being down, or inaccessible due to certificate expirys, means that the Cx business halts. In order to add a bit of clustering, we have added a bit of code for it to try one server first, if there is any kind of an error...

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

Returned a data type that is not validhttps://www.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 'SonyEricsson') THEN 'Smartphone' ELSE 'Other' END VisitorBrowser FROM custombu_stats_visits a GROUP BY a.VisitorIP ORDER BY a.DateTimeStamp DESC) t1 GROUP BY CONCAT(MONTH(t1.Date), ' ', YEAR(t1.Date)) Caused by SQL statement returning first column date...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 t.PageTitle, t.PageContent, t.Source, ".$scorepartstring." AS Score FROM (".$live_sub_query.") AS t WHERE ".$parts." ORDER BY Score DESC LIMIT 0, ".$maximum_number_of_results_from_db; $terms_rx = search_rx_escape_terms($terms); $results_rows = array();...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 OR StudentName=@StudentADAccount). And according to other web articles on this matter, I have to change the order of my parameters (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried...

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