Assuming expression is required, the following 36 results were found.
-
A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another error you may get when using the deluge script is: LIST value cannot be assigned to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Right-click on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week grouping expression: you're being asked to Group by, so we click on the "fx" button to enter the below expression: Delete Order Column: Ok the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
select "Insert Row" then "Below". Repeat with all values you want to compare. For each Data cell, Set the background fill expression as per the MDX expression below. The MDX Expression This is to be applied to the "Fill" expression of the textbox with...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DisplayToolTip: SetTimer, DisplayToolTip, Off ToolTip % %CurrControl%_TT ; The leading percent sign tell it to use an expression. SetTimer, RemoveToolTip, 3000 return RemoveToolTip: SetTimer, RemoveToolTip, Off ToolTip return } Search: Return GuiClose:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Right-click on the cell you want to put the image in. Insert > Rectangle Set the Rectangle Fill color (I'm using an expression based on the status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the rectangle and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
trying to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the collection rather than inserting the collection...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the following: =IIF(RowNumber(Nothing) Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
number datepart) DATEADD(datepart, number, date) DATESUB(datepart, number, date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing expression 00936. 00000 - "missing expression" The solution was to enclose the subquery with an opening and closing parenthesis. --...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
element Defines an element extension Extends an existing simpleType or complexType element field Specifies an XPath expression that specifies the value used to define an identity constraint group Defines a group of elements to be used in complex type...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces. I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
= v_PaymentTermsAlphaNum.removeAllAlpha() // yields 30 But just to demo a regex and a one liner, here's a typical regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name' Line:(99)". This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_XeroTime.indexOf("+")).toLong().toTime(); // yields 15-Apr-2020 17:00:00 Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
contains special characters. Improper Statement Error might be due to missing ';' at end of the line or incomplete expression This could be a missing semi-colon somewhere in your code OR that you have included either "content-type" in your invokeUrl...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *