Search - Joel Lipman .Com

1. jQuery Framework: / Category /; Created on 05 March 2020
2. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the record: / Zoho /; What? A super quick article to demonstrate how an idiot like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). ...; Created on 26 July 2021
3. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU ...; Created on 21 November 2019
4. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g ...; Created on 05 December 2013
5. Error 1065: Query was Empty: / MySQL /; What? In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. ...; Created on 13 December 2012
6. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, ...; Created on 19 July 2011
7. Formatting a date in an MDX query: / Transact-SQL /; ... English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query ...; Created on 11 January 2011
8. Increment a column in MySQL using the UPDATE query: / MySQL /; ... with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET counter_field_value=counter_field_value+1 WHERE ...; Created on 18 February 2010
9. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as ...; Created on 25 July 2024
10. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... is. So we have a workaround, by sending all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a query which joins the sales orders and ...; Created on 09 July 2024
11. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... stop working when a third-party CDN / API gets upgraded. Add these to the widget as you see fit but I'm including jQuery and Bootstrap: Company Name - Quote Builder ...; Created on 14 March 2024
12. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... extras Just making a list of things that at-time-of-print of this article aren't in the official Zoho documentation: Query the documents folder r_MyDocuments = invokeurl [ url: "https://www.zohoapis.com/books/v3/documents?organization_id=123456789" type: ...; Created on 02 October 2023
13. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID ...; Created on 06 July 2023
14. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
15. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: ...; Created on 29 March 2023
16. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register to Signup Complete the form with ...; Created on 21 March 2023
17. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers ...; Created on 20 March 2023
18. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. ...; Created on 06 March 2023
19. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
20. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The ...; Created on 20 February 2023