Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... != "") { r_SearchResults = zoho.crm.searchRecords(v_CrmSoModule,"(Name:equals:" + v_CrmSoRef + ")"); for each r_Result in r_SearchResults { v_CrmSoID = r_Result.get("id").toLong(); } } // // ...; Created on 15 May 2020
13. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with ...; Created on 04 May 2020
14. Joomla CMS: Register to Read More: / Joomla /; ... not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the Joomla built-in search ...; Created on 11 April 2020
15. Joomla: Remove IDs from URLs for out-of-the-box SEF: / Joomla /; Applies to Joomla! CMS v3.5.x What? This is a short article on how to remove the ID numbers from your Joomla website addresses for search engine friendly URLs. // What I have www.joellipman.com/index.php?option=com_content&category_id=4&article_id=123-article-alias // ...; Created on 14 March 2020
16. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... I needed a way to programmatically link the sales order to the invoice. Why? The documentation around the API does not detail how to do this. I also couldn't find any search result via Google or ...; Created on 10 March 2020
17. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid ...; Created on 21 November 2019
18. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("^.*href\s*=\s*\"([^\"]*)\".*$","$1"); // yields https://www.google.com?searchword=Joe Get first 3 words: v_MyString = "I am Joe the Awesomest"; v_FormattedString = v_MyString.replaceAll("^((?:\S+\s+)\S+).*","$1",false); // ...; Created on 31 May 2019
19. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; What? So this is an article for me on how to copy Joomla's and Wordpress' feature where a Title/Name value is converted to a search-engine friendly URL alias and is unique in the database. Ok that's a ...; Created on 06 May 2019
20. GDPR Privacy Policy: / Static Items /; ... address which you have provided. From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the information ...; Created on 14 February 2019