Intersoft Community - WebGrid Enterprise - Complex Conditional Formatting And Dates

Complex Conditional Formatting And Dates

Glayaar — Tue, 01 Sep 2009 00:27:14 GMT

The CustomConditionText will accept any ADO.NET expression. Based on this article on MSDN DataColumn Expression, it seems ADO.NET does not accept Between or NotBetween keyword.

The Between and NotBetween keyword is supported for single column format, for example

ISNet.WebUI.WebGrid.WebGridFormatCondition fmt = new ISNet.WebUI.WebGrid.WebGridFormatCondition();
fmt.Name = "condition4";
fmt.Operator = ISNet.WebUI.WebGrid.ColumnFilterType.Between;
fmt.ColumnMember = "OrderDate";
fmt.ConditionText = "7/1/1996 and 7/18/1996";
fmt.TargetObject = ISNet.WebUI.WebGrid.TargetObjectType.Row;
fmt.FormatStyle.Font.Bold = true;
fmt.FormatStyle.ForeColor = System.Drawing.Color.Green;
fmt.Enabled = true;

WebGrid1.RootTable.FormatConditions.Add(fmt);

The syntax will be similar for NotBetween operation

Complex Conditional Formatting And Dates

PRISMAY — Wed, 26 Aug 2009 13:30:39 GMT

I wanted to report that I did get some custom stuff to work. For example, this works:

"([reportRunStatusID] = 2) and ([dateSubmitted] <= [dataEndDate])"

And this works as well:

"([reportRunStatusID] = 2) and ([dateSubmitted] >= '12 Aug 2009 12:29:14' and [dateSubmitted] <= '26 Aug 2009 12:29:14')"

I would still like to see detailed documentation on this please as I can't find all the available syntax for this. Thank you.

Complex Conditional Formatting And Dates

PRISMAY — Wed, 26 Aug 2009 11:27:43 GMT

I'm also trying to find detailed documentation on what is and is not supported in the CustomConditionText. I tried a SQL type condition below and got the error below.

"[reportRunStatusID] = 1 and [dateSubmitted] between '12 Aug 2009 10:24:23' and '26 Aug 2009 10:24:23'"

The expression contains unsupported operator 'Between'.

Complex Conditional Formatting And Dates

PRISMAY — Wed, 26 Aug 2009 11:22:24 GMT

I'm using the following custom condition to highlight a row based on the status of failed (1) and where something was submitted two weeks ago. However, it doesn't do anything. Can you help me identify what's wrong please? I would also appreciate some complex examples of how to use the Between and NotBetween for boty Row and Cell types. Thank you.

   fmt = new ISNet.WebUI.WebGrid.WebGridFormatCondition();
   fmt.Name = "condition4";
   fmt.CustomConditionText = "[reportRunStatusID] = 1 and [dateSubmitted] > '" +
      DateTime.Now.AddDays(-14).ToString(PRISM.Xtensions.Date.CPRISMDate.CFmtDateTime.Std24) + "'";
   fmt.TargetObject = ISNet.WebUI.WebGrid.TargetObjectType.Row;
   fmt.FormatStyle.Font.Bold = true;
   fmt.FormatStyle.ForeColor = System.Drawing.Color.Green;
   fmt.Enabled = true;

The custom condition evaluates, as of this morning, to this for example:
"[reportRunStatusID] = 1 and [dateSubmitted] > '12 Aug 2009 10:14:52'"