Search - Joel Lipman .Com

1. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020
2. 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
3. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...; Created on 07 November 2011
4. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line 114 ...; Created on 02 September 2011
5. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters ...ouch... ...and it was so easy up to here... Tables of interest StaffActivities ...; Created on 24 August 2011
6. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...; Created on 19 July 2011
7. Set default parameter dates to start and end of month: / SQL Server Reporting Services /; ... specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes ...; Created on 05 April 2011
8. SSRS Use T-SQL Like with a Parameter: / SQL Server Reporting Services /; ... rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with apostrophes ...; Created on 04 April 2011
9. Parameters not being used in report processing: / SQL Server Reporting Services /; ... 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format ...; Created on 07 January 2011
10. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... = invokeurl [ url :v_Url type :POST parameters:m_CreateTimeLog connection:"joels_connector" ]; info r_CreateTimeLog; Example #2: Pushing a time log defaulting to the current time as start ...; Created on 30 April 2021
11. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... 's Awesome Life"); m_NestedRequest.put("data[item_price]","priceless"); r_PostResponse = invokeurl [ url :"https://api.joellipman.com/my_test_api.php" type :POST parameters:m_NestedRequest ]; ...; Created on 03 February 2021
12. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Customization > Forms > Leave Under "Form Properties" > Tick the box under "Validation" for "Custom Validation" to create a function: Ensure you select parameters to input rather than retrieving ...; Created on 10 December 2020
13. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... we'll go into more detail: Create a function that accepts a form of records Create a workflow that understands the function parameters Create a function Why are we doing this first? Well ...; Created on 06 December 2020
14. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... call it "Notify". Add the 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page with the following: /* optional: hide some of the wrapper div boxes: ...; Created on 06 November 2020
15. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... page (new or existing), select "Widgets" and drag your new Widget to the page: Don't forget to click on the page settings (cog in the top right) and add a parameter, in this case "name": Great! ...; Created on 24 October 2020
16. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeurl r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() ...; Created on 28 August 2020
17. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... to say connected. Done! Now you can use this in your custom function with the invokeURL without the need for a header parameter: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" ...; Created on 12 August 2020
18. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Return } SplitPath, sFile, _FileExt, _Dir, _Ext, _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ...; Created on 07 August 2020
19. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported in Zoho Creator ...; Created on 15 May 2020
20. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns: Nothing Author: Joel Lipman Date Created: ...; Created on 17 March 2020