Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have:...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 => again params => what params? I couldn't find any A little more to change A-Z or Z-A change ASC (ascending) to DESC (descending) in the last bit of the above code. To sort by 2 categories, change ' ORDER BY title ASC' to 'ORDER BY title ASC, hits...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 on one of the values of the row label you just moved Select "Sort" Select "More Sort Options" Select "Ascending or Descending" and select "Month" (or name of field) from the dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note:...

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

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

07 September 2015 Rank or ID. - Date Uploaded: Wed, 23rd Jan 2013 2.1 Personal Edition- Fixed Bug: Order By Date - Fixed Bug: Order in descending/ascending order - Enhancement: Changed default settings (matches personal site) - IMPORTANT: Cannot use "Public" usergroup to...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 := 3 COM_Invoke(pwb, "document.all.sort_by.selectedIndex", 3) Radio / Checkbox Selection - checked Quote: Ascending Descending This is the HTML for the Sort By Radio selection. The following will set the Radio to Ascending: Code: javascript:...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Admin Option: Sort Words By (shuffle, alphabet, frequency) - Added Joomla! Admin Option: Sort Words Order (ascending, descending) - Prefixed language file references with JWC to avoid conflicts with 3rd-party apps. - Restructured extension into an MVC...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 b SET a.`block`=b.`block` WHERE a.`id`=b.`id`; -- Tip: order by created_user_id in both ascending/descending to ensure any new user IDs -- Any deletions should be accompanied by reset of auto-increment -- eg. ALTER TABLE `v34_content` AUTO_INCREMENT = 1...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I have added a LIMIT to only return the top 50 words. Source(s): Counting word occurrences in a table column Stack...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 an image This step here will create a widget that will show the last image (or first image if ordered by modified time in descending order) in this status table. For simplicity, I'm going to select the first type of widget under "1. Select Widget"; then...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 this function will be creating contacts and products if required m_Params.put("pageSize",v_PageSize); // // order by date descending (most recent first) - sometimes need to use Date%20DESC m_Params.put("order","UpdatedDateUTC DESC"); // // get the first...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 this function will be creating contacts and products if required m_Params.put("pageSize",v_PageSize); // // order by date descending (most recent first) - sometimes need to use Date%20DESC m_Params.put("order","UpdatedDateUTC DESC"); // // get the first...

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