iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Latest Development Blogs
ForumPostTopic
Browse By Tag
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'"
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
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'.
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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Creating your account...