Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
11. Zoho Creator / Shopify: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021
12. Zoho Creator: Push to eBay Listings: / Zoho /; ... ly failed info "FAILED!\n\n" + r_ResponseXML; } } } On a successful listing you should get something like the following XML response: 2021-09-14T18:04:26.813Z Success 1221 E1221_UNI_API5_19110890_R1 456789012345 ABCDEF1234567 2021-09-14T18:04:25.569Z 2021-10-14T18:04:25.569Z AuctionLengthFee 0.0 BoldFee 0.0 BuyItNowFee 0.0 CategoryFeaturedFee 0.0 FeaturedFee 0.0 GalleryPlusFee 0.0 FeaturedGalleryFee 0.0 FixedPriceDurationFee 0.0 GalleryFee 0.0 GiftIconFee 0.0 HighLightFee 0.0 InsertionFee 0.0 0.06 InternationalInsertionFee 0.0 ListingDesignerFee 0.0 ListingFee 0.0 0.06 PhotoDisplayFee 0.0 PhotoFee 0.0 ReserveFee 0.0 SchedulingFee 0.0 SubtitleFee 0.0 BorderFee 0.0 ProPackBundleFee 0.0 BasicUpgradePackBundleFee 0.0 ValuePackBundleFee 0.0 PrivateListingFee 0.0 ProPackPlusBundleFee 0.0 MotorsGermanySearchFee 0.0 SpecialOffer ...; Created on 12 September 2021
13. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), ...; Created on 01 September 2021
14. ZohoCRM: Process all records of a module: / Zoho /; ... been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have ...; Created on 24 August 2021
15. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... The example below is that we are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been simplified and will ...; Created on 30 July 2021
16. 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
17. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; Created on 03 June 2021
18. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... relevant to this module: l_LinkedRecords = zoho.crm.searchRecords("Opportunities_X_Products","(Opportunity:equals:" + v_DealID + ")"); Find records relevant to this user: v_SearchCriteria ...; Created on 28 April 2021
19. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an employee for applying for leave if over 80% of the department ...; Created on 10 December 2020
20. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file as is. ; ; -------------------------------------------------------------------------------------- ; ...; Created on 08 July 2020