Version

SpecialFilterOperands Class Members

The following tables list the members exposed by SpecialFilterOperands.

Public Properties
 NameDescription
Public Propertystatic (Shared in Visual Basic)AboveAverageAn 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.  
Public Propertystatic (Shared in Visual Basic)AprilAn operand representing the fourth month of the year.  
Public Propertystatic (Shared in Visual Basic)AugustAn operand representing the eighth month of the year.  
Public Propertystatic (Shared in Visual Basic)BelowAverageAn 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.  
Public Propertystatic (Shared in Visual Basic)BlanksAn operand used to determine if a specified value is blank ('null', 'dbnull' or empty string).  
Public Propertystatic (Shared in Visual Basic)Bottom10An 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.  
Public Propertystatic (Shared in Visual Basic)Bottom10PercentageAn 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.  
Public Propertystatic (Shared in Visual Basic)DecemberAn operand representing the last month of the year.  
Public Propertystatic (Shared in Visual Basic)FebruaryAn operand representing the second month of the year.  
Public Propertystatic (Shared in Visual Basic)JanuaryAn operand representing the first month of the year.  
Public Propertystatic (Shared in Visual Basic)JulyAn operand representing the seventh month of the year.  
Public Propertystatic (Shared in Visual Basic)JuneAn operand representing the sixth month of the year.  
Public Propertystatic (Shared in Visual Basic)LastMonthAn operand used to determine if a specified value is between the first and last days of last month.  
Public Propertystatic (Shared in Visual Basic)LastQuarterAn operand used to determine if a specified value is between the first and last days of the previous quarter.  
Public Propertystatic (Shared in Visual Basic)LastWeekAn operand used to determine if a specified value is between the first and last days of last week.  
Public Propertystatic (Shared in Visual Basic)LastYearAn operand used to determine if a specified value is between the first and last days of the previous year.  
Public Propertystatic (Shared in Visual Basic)MarchAn operand representing the third month of the year.  
Public Propertystatic (Shared in Visual Basic)MayAn operand representing the fifth month of the year.  
Public Propertystatic (Shared in Visual Basic)NextMonthAn operand used to determine if a specified value is between the first and last days of next month.  
Public Propertystatic (Shared in Visual Basic)NextQuarterAn operand used to determine if a specified value is between the first and last days of next quarter.  
Public Propertystatic (Shared in Visual Basic)NextWeekAn operand used to determine if a specified value is between the first and last days of next week.  
Public Propertystatic (Shared in Visual Basic)NextYearAn operand used to determine if a specified value is between the first and last days of next year.  
Public Propertystatic (Shared in Visual Basic)NonBlanksAn operand used to determine if a specified value is not blank (anything that's not 'null', 'dbnull' or empty string).  
Public Propertystatic (Shared in Visual Basic)NovemberAn operand representing the eleventh month of the year.  
Public Propertystatic (Shared in Visual Basic)OctoberAn operand representing the tenth month of the year.  
Public Propertystatic (Shared in Visual Basic)Quarter1An operand used to determine if a specified value falls within the first 3 months of the calendar year.  
Public Propertystatic (Shared in Visual Basic)Quarter2An operand used to determine if a specified value falls within the second 3 months of the calendar year.  
Public Propertystatic (Shared in Visual Basic)Quarter3An operand used to determine if a specified value falls within the third 3 months of the calendar year.  
Public Propertystatic (Shared in Visual Basic)Quarter4An operand used to determine if a specified value falls within the last 3 months of the calendar year.  
Public Propertystatic (Shared in Visual Basic)SeptemberAn operand representing the ninth month of the year.  
Public Propertystatic (Shared in Visual Basic)ThisMonthAn operand used to determine if a specified value is between the first and last days of this month.  
Public Propertystatic (Shared in Visual Basic)ThisQuarterAn operand used to determine if a specified value is between the first and last days of the current quarter.  
Public Propertystatic (Shared in Visual Basic)ThisWeekAn operand used to determine if a specified value is between the first and last days of this week.  
Public Propertystatic (Shared in Visual Basic)ThisYearAn operand used to determine if a specified value is between the first and last days of the current year.  
Public Propertystatic (Shared in Visual Basic)TodayAn operand used to determine if a specified value is equal to today's date.  
Public Propertystatic (Shared in Visual Basic)TomorrowAn operand used to determine if a specified value is equal to tomorrow's date.  
Public Propertystatic (Shared in Visual Basic)Top10An 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.  
Public Propertystatic (Shared in Visual Basic)Top10PercentageAn 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.  
Public Propertystatic (Shared in Visual Basic)YearToDateAn operand used to determine if a specified value is between the first day of the year and the current date.  
Public Propertystatic (Shared in Visual Basic)YesterdayAn operand used to determine if a specified value is equal to yesterday's date.  
Public Methods
 NameDescription
Public Methodstatic (Shared in Visual Basic)CreateDateRangeOperandCreates 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).  
Public Methodstatic (Shared in Visual Basic)GetBuiltInOperandGets the built-in special filter operand of specified name.  
Public Methodstatic (Shared in Visual Basic)GetRegisteredOperandReturns the registered operand with the specified name. If no operand with the matching name is found, returns null.  
Public Methodstatic (Shared in Visual Basic)GetRegisteredOperandsOverloaded. Returns all registered operands.  
Public Methodstatic (Shared in Visual Basic)RegisterRegisters 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.  
Public Methodstatic (Shared in Visual Basic)UnregisterUn-registers a previously registered operand. Built-in operands can also be un-registered.  
See Also