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. 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
10. 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
11. 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
12. 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
13. 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
14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... a message handler or participation handler. As for the usage, simply ask the Cliq Bot a question and it will forward the query and respond with the response from the OpenAI API. Setup a Zoho Cliq ...; Created on 13 February 2023
15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" ...; Created on 08 February 2023
16. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; What? A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the ...; Created on 24 October 2022
17. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... build URL to query l_Params = List(); l_Params.add("refresh_token="+v_RefreshToken); l_Params.add("client_id="+v_ClientID); l_Params.add("client_secret="+v_ClientSecret); l_Params.add("redirect_uri=https%3A%2F%2Fsign.zoho." ...; Created on 17 October 2022
18. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = " } } }"; m_GraphQl = Map(); m_GraphQl.put("query", v_GraphQl); // // Let's test with this GraphQL query v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; r_GetProduct ...; Created on 14 February 2022
19. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: ...; Created on 22 January 2022
20. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022