Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024
2. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...; Created on 17 November 2011
3. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
4. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records ...; Created on 12 July 2023
5. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...; Created on 10 February 2022
6. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022
7. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all calls Action is the ...; Created on 16 December 2021
8. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article ...; Created on 17 November 2021
9. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... r_ShopifyProduct in r_GetProducts.get("products") { if(!isnull(r_ShopifyProduct.get("id"))) { // // an error-prone one-liner so that we don't hit an execution statement limit v_ProductSKU ...; Created on 12 October 2021
10. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
11. 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
12. Zoho Deluge - MD5 function: / Zoho /; ... writing a Creator function but found a shortcut playing with the base64encode function: v_Etag = zoho.encryption.base64encode(v_Combined_Fields); // returns error Error on Execution Execution ...; Created on 19 November 2018
13. 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
14. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... e.TimeStart, e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM [ReportServer].[dbo].[ExecutionLogStorage] e INNER JOIN [ReportServer].[dbo].[Catalog] ...; Created on 02 December 2011
15. SSRS External Images don't displa: / SQL Server Reporting Services /; ... hosted on an external URL Check if image exists to display alternative placeholding image. Solution #1: Image does not appear within SSRS Configure the Unattended Execution Account: According ...; Created on 19 September 2011
16. SSRS Redirect after a report is run: / SQL Server Reporting Services /; ... further. Google Searches that got me nowhere: ssrs process parameter after report execution auto-redirect after are a report is run ssrs vbscript post report processing ssrs auto redirect ...; Created on 12 August 2011
17. The ReportServer Database: / Databases /; ... as to what this database is and how it populates its data. View: ExecutionLog InstanceName nvarchar(38) NOT NULL Name of the report server instance that handled the request. Usually YOURSERVERNAME\MSSQLSERVER ...; Created on 08 August 2011
18. Before and After, Highs and Lows: / SQL Server Reporting Services /; ... Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun, DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun, DATEPART(year, ExecutionLogStorage.TimeStart) ...; Created on 03 August 2011
19. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns ...; Created on 19 July 2011
20. SSRS Report Builder 2.0 - Error during processing: / SQL Server Reporting Services /; ... during report processing. Query execution failed for dataset 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The ...; Created on 06 May 2010