Search - Joel Lipman .Com

1. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... previous version was limited by our ability to search by product SKU. The new version, taking advantage of GraphQL, will be able to search by SKU and retrieve the correct product ID, variant ID, and inventory ...; Created on 14 February 2022
2. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
3. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; What? This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating ...; Created on 29 July 2021
4. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; What? This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and ...; Created on 28 August 2020
5. Joes Search Module (JSM): / Product Documentation /; What? This article serves as documentation for a Joomla extension I have released which is a copy of the built-in Joomla Search module but with the parameters embedded (set in the administration section). ...; Created on 09 March 2015
6. Improve Default Joomla Search: / Joomla /; - Applies to Joomla 2.5.x +, 3.4.x What? So I can't stand the way the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added ...; Created on 07 May 2013
7. Search a database for a value and count matching rows: / Databases /; ... "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters ...; Created on 05 November 2012
8. Search a database with SOUNDEX: / Databases /; ... same values, so I should go through the database and change all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire database for similar sounding ...; Created on 11 October 2012
9. Search a database for a string (MySQL, T-SQL): / Databases /; ... SQL scripts that can simply be used to search an entire database for a particular string of word(s). I've posted my own as well as some others I've lifted from elsewhere, as they worked with my environment, ...; Created on 08 October 2012
10. PHP & MySQL Search Engine: / Personal Home Page /; Do you hate sites that do not have a search feature? I do. I think it defeats the purpose of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This ...; Created on 09 March 2011
11. Search and Replace in a MySQL Database: / MySQL /; Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever ...; Created on 17 March 2010
12. 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
13. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... = "I don't know. Would you like me to Google: [" + v_Message + "](https://www.google.com/search?q=" + zoho.encryption.urlEncode(v_Message) + ")?"; } } // // build up response to user m_Prompt = Map(); m_Prompt.put("param_name","banter"); m_Prompt.put("prompt_msg",v_Response); m_Response.put("prompt",m_Prompt); // // ...; Created on 06 March 2023
14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not currently connected to ChatGPT. The plus side ...; Created on 13 February 2023
15. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... searching the web for other art styles: Anamorphic Aquatint Avant-Garde Batik Caricature Collage Composite Concentric Conceptual Constructivism Contour Cor-Ten Steel Daguerreotype Diptych Double ...; Created on 11 February 2023
16. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... r_Associated; if(!isnull(r_Associated.get("data"))) { for each r_Data in r_Associated.get("data") { if(!isnull(r_Data.get("id"))) { v_SearchEndpoint = "https://recruit.zoho.com/recruit/v2/Candidates_x_JobOpenings/search?criteria=(CustomModule6_Name:equals:" ...; Created on 08 February 2023
17. ZohoCRM: Import Attachments: / Zoho /; ... %v_RunFolder%\Attachments GuiControlGet, v_FolderToSearch, , MySelectedFolder v_FilesCopied := 0 v_FilesTotal := 0 ; attachments csv headings v_CsvLine := "Attachment Id,Attachment Owner Id,Modified ...; Created on 16 January 2023
18. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... = 0; l_CandidateSearch = zoho.recruit.searchRecords("Candidates","School Name|=|" + v_SchoolName,1,200,"ALL","zrecruit"); for each r_Candidate in l_CandidateSearch { if(!isnull(r_Candidate.get("CANDIDATEID"))) { v_CandidatePlacedCount ...; Created on 19 October 2022
19. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... on the ZohoSign document and searches for the relevant Deal record in CRM. Why? A client wants that when this field is entered and the document signed and returned, it attached the signed document ...; Created on 17 October 2022
20. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... = invoice.get("invoice_number"); v_BalanceDue = ifnull(invoice.get("balance"),0.0); // // 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"); // // ...; Created on 17 August 2022