The following tables list the members exposed by SpecialFilterOperands.
Name | Description | |
---|---|---|
AboveAverage | An operand used to determine if a specified value is above the average of the set of values of which the value being tested is a member value. | |
April | An operand representing the fourth month of the year. | |
August | An operand representing the eighth month of the year. | |
BelowAverage | An operand used to determine if a specified value is below the average of the set of values of which the value being tested is a member value. | |
Blanks | An operand used to determine if a specified value is blank ('null', 'dbnull' or empty string). | |
Bottom10 | An operand used to determine if a specified value is one of the bottom 10 values in the set of values that the value being tested is a member of. | |
Bottom10Percentage | An operand used to determine if a specified value is one of the bottom 10 percent of the values in the set of values that the value being tested is a member of. | |
December | An operand representing the last month of the year. | |
February | An operand representing the second month of the year. | |
January | An operand representing the first month of the year. | |
July | An operand representing the seventh month of the year. | |
June | An operand representing the sixth month of the year. | |
LastMonth | An operand used to determine if a specified value is between the first and last days of last month. | |
LastQuarter | An operand used to determine if a specified value is between the first and last days of the previous quarter. | |
LastWeek | An operand used to determine if a specified value is between the first and last days of last week. | |
LastYear | An operand used to determine if a specified value is between the first and last days of the previous year. | |
March | An operand representing the third month of the year. | |
May | An operand representing the fifth month of the year. | |
NextMonth | An operand used to determine if a specified value is between the first and last days of next month. | |
NextQuarter | An operand used to determine if a specified value is between the first and last days of next quarter. | |
NextWeek | An operand used to determine if a specified value is between the first and last days of next week. | |
NextYear | An operand used to determine if a specified value is between the first and last days of next year. | |
NonBlanks | An operand used to determine if a specified value is not blank (anything that's not 'null', 'dbnull' or empty string). | |
November | An operand representing the eleventh month of the year. | |
October | An operand representing the tenth month of the year. | |
Quarter1 | An operand used to determine if a specified value falls within the first 3 months of the calendar year. | |
Quarter2 | An operand used to determine if a specified value falls within the second 3 months of the calendar year. | |
Quarter3 | An operand used to determine if a specified value falls within the third 3 months of the calendar year. | |
Quarter4 | An operand used to determine if a specified value falls within the last 3 months of the calendar year. | |
September | An operand representing the ninth month of the year. | |
ThisMonth | An operand used to determine if a specified value is between the first and last days of this month. | |
ThisQuarter | An operand used to determine if a specified value is between the first and last days of the current quarter. | |
ThisWeek | An operand used to determine if a specified value is between the first and last days of this week. | |
ThisYear | An operand used to determine if a specified value is between the first and last days of the current year. | |
Today | An operand used to determine if a specified value is equal to today's date. | |
Tomorrow | An operand used to determine if a specified value is equal to tomorrow's date. | |
Top10 | An operand used to determine if a specified value is one of the top 10 values in the set of values that the value being tested is a member of. | |
Top10Percentage | An operand used to determine if a specified value is one of the top 10 percent of the values in the set of values that the value being tested is a member of. | |
YearToDate | An operand used to determine if a specified value is between the first day of the year and the current date. | |
Yesterday | An operand used to determine if a specified value is equal to yesterday's date. |
Name | Description | |
---|---|---|
CreateDateRangeOperand | Creates an operand used to compares dates to a range of dates based on a given relative date and the granularity to which the dates should be compared (e.g. compare the year). | |
GetBuiltInOperand | Gets the built-in special filter operand of specified name. | |
GetRegisteredOperand | Returns the registered operand with the specified name. If no operand with the matching name is found, returns null. | |
GetRegisteredOperands | Overloaded. Returns all registered operands. | |
Register | Registers a user defined special operand. This method can be used to re-register built-in special operand as well, in case it was un-registered with Unregister method. | |
Unregister | Un-registers a previously registered operand. Built-in operands can also be un-registered. |