On probation
Not IsNull([ProbationReason])
All
Salaried
[Status] = ##Enum#DevExpress.DevAV.EmployeeStatus,Salaried#
Commission
[Status] = ##Enum#DevExpress.DevAV.EmployeeStatus,Commission#
Contract
[Status] = ##Enum#DevExpress.DevAV.EmployeeStatus,Contract#
Terminated
[Status] = ##Enum#DevExpress.DevAV.EmployeeStatus,Terminated#
On Leave
[Status] = ##Enum#DevExpress.DevAV.EmployeeStatus,OnLeave#
Active
[Status] = ##Enum#DevExpress.DevAV.CustomerStatus,Active#
Suspended
[Status] = ##Enum#DevExpress.DevAV.CustomerStatus,Suspended#
All
Stores > 10 Locations
[TotalStores] > 10
Revenues > 100 Billion
[AnnualRevenue] > 100000000000.0m
Employees > 10000
[TotalEmployees] > 10000
Discontinued
[Available] = False
Out of Stock
[CurrentInventory] = 0
All
Video Players
[Category] = ##Enum#DevExpress.DevAV.ProductCategory,VideoPlayers#
Automation
[Category] = ##Enum#DevExpress.DevAV.ProductCategory,Automation#
Monitors
[Category] = ##Enum#DevExpress.DevAV.ProductCategory,Monitors#
Projectors
[Category] = ##Enum#DevExpress.DevAV.ProductCategory,Projectors#
Televisions
[Category] = ##Enum#DevExpress.DevAV.ProductCategory,Televisions#
Sales > $5000
[TotalAmount] > 5000.0m
Sales < $5000
[TotalAmount] < 5000.0m
Sales by Jim Packard
[EmployeeId] = 41
Sales by Harv Mudd
[EmployeeId] = 43
Sales by Clark Morgan
[EmployeeId] = 44
Sales by Todd Hoffman
[EmployeeId] = 45
All
Today
IsOutlookIntervalToday([OrderDate])
Yesterday
IsOutlookIntervalYesterday([OrderDate])
This Month
IsThisMonth([OrderDate])
This Year
IsOutlookIntervalEarlierThisYear([OrderDate])
Unpaid Orders
[PaymentTotal] = 0.0m
Refunds
[RefundTotal] = [TotalAmount]
All
Today
IsOutlookIntervalToday([Date])
Yesterday
IsOutlookIntervalYesterday([Date])
This Month
IsThisMonth([Date])
This Year
IsOutlookIntervalEarlierThisYear([Date])