Assuming order is required, the following 133 results were found.
-
I'd like to document for future use. The use-case is the client has their own delivery drivers and want them to mark a sales order & package as shipped and delivered. How? Here's a code snippet that works for me. It is triggered when a user ticks a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
have -- the same date then they will be numbered the same. Used in -- calculation to determine row record is to display on. [Order] = DENSE_RANK() OVER (ORDER BY d.[Date]), -- date used in all calculations for date d.[Date], --generates matrix columns...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new values come along then they get added to the bottom of the list... This is the problem. For example,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
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: id...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Time] , e.[TimeRendering] AS [Render Time] , DATEDIFF(MILLISECOND, e.TimeStart, e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM [ReportServer].[dbo].[ExecutionLogStorage] e INNER JOIN [ReportServer].[dbo].[Catalog] c ON...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER BY b.user_name ) t2...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
calendar WHERE calendar.SetID=( SELECT acyear.SetID FROM joes_weekstructure acyear WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= List(); l_PaginationParams.add("page=1"); l_PaginationParams.add("per_page=100"); l_PaginationParams.add("order_by=id"); // // we have no more than 100 categories so let's start counting r_Categories = invokeurl [ url: v_EndpointCategories + "?" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
'' post_content_filtered, '0' post_parent, CONCAT('http://demo.joellipman.com/wordpress/', '?p=', id) AS guid, '0' menu_order, 'post' AS 'post_type', '' post_mime_type, 0 comment_count FROM my_joomla_db.jos_content ORDER BY id Importing the joomla...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Frontpage Item Orderinghttps://joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit " + v_PerPage + " offset " + v_PageOffset; Sort Order: ORDER BY column_name ASC/DESC: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, a package slip/delivery note, a shipment order; as well as record any payments, inventory adjustments, status...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
myself) in the future. At time of print (9th October 2025), for some reason, if you click on the plus icon next to Sales Order (creates a new sales order) on the quote record, the fields auto-map. The client script below does the same for invoice as the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_TranslateStatuses.put("ACCEPTED","Approved by Customer"); m_TranslateStatuses.put("INVOICED","Converted to Sales Order"); m_TranslateStatuses.put("DELETED","Cancelled / Rejected"); // // Xero Tax Rates translated to Zoho Tax Rate (manual reference)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
. ')') $query->where($db->quoteName('u.real_name') . ' LIKE '. $db->quote('\'%smith%\'')); $query->order('u.real_name ASC'); // Reset the query using our new query object $db->setQuery($query); // Load the results as a list of stdClass objects (see...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
for Joomla! FTP upload. - File Download: Payment Options --- merchant ID, --- amount --- currency, --- paypal, google, --- order ref, --- download limit, --- download period, --- thank you message v0.1 (06/07/2011) - Added Admin Section:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
a datatype Boolean. Our function will then loop through each record and do what it has to do. The workaround here is that we order this by modified time. When the checkbox gets updated, this modifies the record and puts it at the bottom of the list. In...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *