Search - Joel Lipman .Com

1. 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
2. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... = r_SearchResults.get("customerpayments"); for each r_Result in l_SearchResults { if(!isnull(r_Result.get("payment_id"))) { // // invalid searches will return 200 results non-matching, ...; Created on 17 August 2022
3. 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
4. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... though I tend to use !myVar.contains() startsWith startsWithIgnoreCase used in fuzzy logic searches to broaden the resultset containKey Applies to maps only containValue Applies to maps only ...; Created on 21 November 2019
5. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... = v_MyString.replaceAll("[^0-9]",""); // yields 123 The following is used in searches to escape special characters with a backslash: v_MyString = "Joe's \"Amazing\" Skill & Sidekick (1)"; v_FormattedString ...; Created on 31 May 2019
6. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
7. Joes Search Module (JSM): / Product Documentation /; ... these to the following: action = /index.php?option=com_search method = post role = search Issues Further searches do not include the same filters. This will be because the setting to ...; Created on 09 March 2015
8. Restore MSSQL Error: Database is in use: / Databases /; ... Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database ...; Created on 08 March 2013
9. Ordered List of over 1000 Items: / Cascading Stylesheets /; What? So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item ...; Created on 08 February 2013
10. Quickly update all content in mySQL database replacing a string: / MySQL /; What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin ...; Created on 03 February 2013
11. List last modified files using FTP Command-line: / File Transfer Protocol /; ... command to output to a local file. Type dir . temp.txt to output the current remote directory list of files to the local file temp.txt. Other Searches msdos ftp print server directory to local ...; Created on 20 November 2012
12. Sync Outlook 2007 Shared Calendar with SharePoint 2007: / SharePoint /; ... No but far more manageable when using Outlook 2007 instead of the SharePoint 2007 web interface... Other Searches Import Outlook 2007 calendar into Sharepoint 2007 Sync Sharepoint 2007 calendar ...; Created on 09 November 2012
13. Search a database with SOUNDEX: / Databases /; ... ** ** Revision: v1.2 ** ** Description: Script to create a SQL query which searches ...; Created on 11 October 2012
14. Search a database for a string (MySQL, T-SQL): / Databases /; ... ,@SearchStr = '%TEST%' The above sample searches in table T1 with string containing TEST. 2. To search in a multiple table EXEC SearchTable ...; Created on 08 October 2012
15. Joomla article modal with clear button: / Joomla /; Applies to Joomla 1.6+ What? This is an article to describe how to add an article modal button in the Joomla Admin Panel (at time of print version 2.5.6) of your component including the all important ...; Created on 27 August 2012
16. Joomla field types clear my html: / Joomla /; What? Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS ...; Created on 09 August 2012
17. MySQL day of week ending on Friday: / MySQL /; ... AS WeDate -- yields -- 2012-04-29 -- this Sunday -- 2012-04-29 -- this Sunday -- 2012-04-29 -- this Sunday Other Searches These didn't get me very far until I decided to write this article: DAYOFWEEK(myDate, ...; Created on 26 April 2012
18. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...; Created on 24 January 2012
19. Getting the mysql where in delimited string to work: / MySQL /; What? I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", ...; Created on 02 January 2012
20. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...; Created on 14 December 2011