|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.|
Compared with ItemBar property that can access bars based on bar's Key only, the ItemBarEx property can access bars based on any:
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.