property Items.ItemBarEx(Criteria as Variant, Property as ItemBarPropertyEnum) as Variant
Gets or sets the property's bar that matches the criteria.

 TypeDescription 
   Criteria as Variant A String expression that defines the criteria / formula to select/query the bars in the chart, or a Boolean expression that specifies that all or none bars are selected to be queried. For instance, "cellstate(0) = 1" queries all bars hosted by items whose check-box in the column with the index 0, are checked, or "itemisselected and itembar(0) = `Task`" queries all Task bars from the selected items. The Criteria parameter of the ItemBarEx property supports predefined functions and keywords as defined bellow.  
   Property as ItemBarPropertyEnum A ItemBarPropertyEnum expression that defines the bar's property to be queried. For instance, you can use exBarsCount to query the number of bars that matches the criteria.  
   Variant For the get_ItemBarEx property, it indicates the value of the bar's property being found ( for instance, if the Property is exBarsCount, the ItemBarEx property returns a numeric value that specifies the number of bars that matches the criteria). For set_ItemBarEx property it could be a string expression that defines the formula to change the bar's property, or any other value to assign to the bar's property for all bars that matches the criteria. For instance, "value + 1", indicates the previously value plus one. The Value parameter of the ItemBarEx property supports predefined functions and keywords as defined bellow.  
The ItemBarEx property is an extension of ItemBar property, that allows changing the properties for a set of bars, using expressions. For instance, you want to select all bars whose value on the Country column is France, or move all bars of type "Task", change the color for all checked items, change the percent for selected bars, and so on.

Compared with ItemBar property that can access bars based on bar's Key only, the ItemBarEx property can access bars based on any:

For instance:

The Criteria and Value parameters of the ItemBarEx property support the following pre-defined functions:

The Criteria and Value parameters of the ItemBarEx property support the following pre-defined keywords:

Additionally, the Value parameter of the ItemBarEx property supports the following pre-defined keywords:

For instance, the Criteria parameter could be:

The expression may be a combination of variables, constants, strings, dates and operators.  A string is delimited by ", ` or ' characters, and inside they can have the starting character preceded by \ character, ie "\"This is a quote\"". A date is delimited by two # characters, ie #1/31/2001 10:00# means the January 31th, 2001, 10:00 AM.

This property/method supports predefined constants and operators/functions as described here.


Send comments on this topic.
1999-2017 Exontrol.COM, Software. All rights reserved.