Building Filters
This page should be used as a reference for building filters and reports.
Use the property names in the object for filters and reports. This document explains how to get the most out of creating filters to reduce the number of records being viewed and creating reports to provide better data output.
Boolean
Properties with true/false values require the property name and property value.
- Boolean example: 'IsCompleted=true'
DateTime
- Use a 'dot expression' to match dates and times.
- DateTime property example: 'StartDate.Year=2014'
- DateTime Between Filter example: 'StartDate.Year Between 2014,2015'
- Other DateTime dot properties: Date, Day, DayOfWeek, Hour Month, TimeOfDay, Year
Date
Date is identical to DateTime, except that it ONLY includes the Date component.
DateTimeOffset
DateTimeOffset is identical to DateTime, except that it includes a LocalDateTime, Offset, UtcDateTime
TimeSpan
- Use a 'dot expression' to match Time Spans.
- TimeSpan property example: 'Duration.Hours=11'
- TimeSpan Between Filter example: 'Duration.Hours Between 11,13'
- Other TimeSpan dot properties: Days, Hours, Minutes, Seconds, TotalDays, TotalHours, TotalMinutes, TotalSeconds
Id
- The key to the record is the 'Id'.This points to only one record.
- Id example: 'Id=ed662309-55e0-40cd-bdf7-b1852124d748' will get one record.
Guid
- Many classes have properties that point to other classes -these are called foreign keys. The property type is a Guid.The property name will vary, but tends to be the class name + 'Id', e.g.TagId points to a record in the Tag table.
- Guid property example: 'TagId=ed662309-55e0-40cd-bdf7-b1852124d748'
String
- Text - based Properties, such as 'Name', require the property name and property value with NO QUOTES.
- String example: 'Name = John Smith'. (Spaces are optional.)
Color
Color Filters can be defined as 'Color=Black'.
Int32
Integer filters can be defined as 'Count>0'.
Decimal
Decimal filters can be defined as 'Count>0'.
Double
Double filters can be defined as 'Count>0'.
Int64
Long filters can be defined as 'Count>0'.
Complex Filter Expressions
- Multiple filters are supported for AND and OR.
- Multiple filter example: 'StartDate.Year=2014 & IsCompleted=true & Name = John Smith' - look for objects where ALL of these conditions are satisfied.
- Multiple filter example: 'StartDate.Year=2014 | IsCompleted=true | Name = John Smith' - look for objects where any of these conditions are satisfied.
Enumerations Overview
An enumeration is a complete, ordered listing of all the items in a collection. The term is commonly used in mathematics and computer science to refer to a listing of all of the elements of a set.
AccessTarget
None example: AccessTarget=None
ActionType
DesktopAlert example: ActionType=DesktopAlert
AssetType
None example: AssetType=None
CatanPlayerType
Player example: CatanPlayerType=Player
CatanPlayerStatus
NotLoggedIn example: CatanPlayerStatus=NotLoggedIn
CatanPlayingState
StartTurn example: CatanPlayingState=StartTurn
CatanGameState
OrderOfPlayers example: CatanGameState=OrderOfPlayers
CategoryType
Category example: CategoryType=Category
ClassType
ToDo example: ClassType=ToDo
ConditionType
IfThenElse example: ConditionType=IfThenElse
Country
Eritrea example: Country=Eritrea
EmployeeType
Coach example: EmployeeType=Coach
LogCategory
WP7_Skydrive example: LogCategory=WP7_Skydrive
LogType
Cloud example: LogType=Cloud
MessageType
Outgoing example: MessageType=Outgoing
NotificationType
None example: NotificationType=None
Province
Kansas example: Province=Kansas
VolunteerType
Family example: VolunteerType=Family
ActiveStatus
- Active: ActiveStatusId=0
- Inactive: ActiveStatusId=1
AccessType
- Deny: AccessTypeId=0
- Allow: AccessTypeId=1
- Read Only: AccessTypeId=2
- Deny Members: AccessTypeId=3
- Allow Members: AccessTypeId=4
- Read-Only Members: AccessTypeId=5
AssignmentStatus
- Tentative: AssignmentStatusId=0
- Assigned: AssignmentStatusId=1
- Substitute: AssignmentStatusId=2
- Unassigned: AssignmentStatusId=3
AudioType
- None: AudioTypeId=0
- Voice: AudioTypeId=1
- Music: AudioTypeId=2
- BackgroundType
- Solid Color: BackgroundTypeId=0
- Gradient Color: BackgroundTypeId=1
- Photo: BackgroundTypeId=2
Clearance
- '': ClearanceId=0
- Cleared: ClearanceId=1
- Reconciliated: ClearanceId=2
ContactStatus
- Valid: ContactStatusId=0
- Suspended: ContactStatusId=1
- Expired: ContactStatusId=2
CostInfo
- None: CostInfoId=0
- Cost By Department: CostInfoId=1
- Cost By Project: CostInfoId=2
- Cost By Contact: CostInfoId=3
- Fixed Cost: CostInfoId=4
ErrorLevel
- Store no logs: ErrorLevelId=0
- Store Errors only: ErrorLevelId=1
- Store Errors, Info, Audits: ErrorLevelId=2
- Store all logs: ErrorLevelId=3
FontFamily
- Segoe W P: FontFamilyId=0
- Calabri: FontFamilyId=1
- Comic Sans M S: FontFamilyId=2
- Courier New: FontFamilyId=3
- Lucida Sans Unicode: FontFamilyId=4
- Tahoma: FontFamilyId=5
- Times New Roman: FontFamilyId=6
- Yu Gothic: FontFamilyId=7
- Arial Black: FontFamilyId=8
- Wingdings: FontFamilyId=9
- Webdings: FontFamilyId=10
- Trebuchet M S: FontFamilyId=11
- Georgia: FontFamilyId=12
FontSize
- 24: FontSizeId=0
- 28: FontSizeId=1
- 32: FontSizeId=2
- 36: FontSizeId=3
- 40: FontSizeId=4
- 48: FontSizeId=5
- 54: FontSizeId=6
ImportanceUrgence
- Important and Urgent: ImportanceUrgenceId=0
- Important and Not Urgent: ImportanceUrgenceId=1
- Not Important and Urgent: ImportanceUrgenceId=2
- Not Important and Not Urgent: ImportanceUrgenceId=3
Priority
- Low: PriorityId=0
- Medium: PriorityId=1
- High: PriorityId=2
- Must: PriorityId=3
ProjectStatus
- Not Started: ProjectStatusId=0
- Active: ProjectStatusId=1
- Completed: ProjectStatusId=2
Recurrence
- No: RecurrenceId=0
- Daily: RecurrenceId=1
- Weekly: RecurrenceId=2
- Monthly: RecurrenceId=3
- Yearly: RecurrenceId=4
ResourceType
- Contact: ResourceTypeId=0
- Location: ResourceTypeId=1
SlideShowOrder
- Image Created Date: SlideShowOrderId=0
- File Created Date: SlideShowOrderId=1
- Order: SlideShowOrderId=2
SlideShowSelection
- By Tag: SlideShowSelectionId=0
- By Folder: SlideShowSelectionId=1
- All: SlideShowSelectionId=2
SortOrderDisplay
- none: SortOrderDisplayId=0
- Ascending: SortOrderDisplayId=1
- Descending: SortOrderDisplayId=2
SortPropertyDisplay
- none: SortPropertyDisplayId=0
- Name: SortPropertyDisplayId=1
- Created on: SortPropertyDisplayId=2
- Created by: SortPropertyDisplayId=3
- Site name: SortPropertyDisplayId=4
- Updated on: SortPropertyDisplayId=5
- Updated by: SortPropertyDisplayId=6
StartPage
- Main: StartPageId=0
- Tasks: StartPageId=1
- Projects: StartPageId=2
- To Dos: StartPageId=3
- Tags: StartPageId=4
- Notes: StartPageId=5
- Sign In: StartPageId=6
- Notes Editor: StartPageId=7
- Timesheets: StartPageId=8
- New Timesheet: StartPageId=9
- Expenses: StartPageId=10
- New Expense: StartPageId=11
- S T O R E: StartPageId=12
- D E M O: StartPageId=13
- Banners: StartPageId=14
- New Banner: StartPageId=15
- Map Route: StartPageId=16
- All Routes: StartPageId=17
- All Locations: StartPageId=18
- Edit Location: StartPageId=19
StartState
- Not Started: StartStateId=0
- Active: StartStateId=1
StorageType
- Session: StorageTypeId=0
- Local Database: StorageTypeId=1
- Cloud Logs only: StorageTypeId=2
- Cloud: StorageTypeId=3
TaskDueDate
- No date: TaskDueDateId=0
- Today at 12pm: TaskDueDateId=1
- Tomorrow at 12pm: TaskDueDateId=2
- Next Week at 12pm: TaskDueDateId=3
TaskState
- Unscheduled: TaskStateId=0
- Delayed: TaskStateId=1
- Today: TaskStateId=2
- Tomorrow: TaskStateId=3
- Next: TaskStateId=4
- Completed: TaskStateId=5
Theme
- Dark: ThemeId=0
- Light: ThemeId=1
TermsType
- Now Due: TermsTypeId=0
- Due in 2 weeks: TermsTypeId=1
- Due in 30 days: TermsTypeId=2
- Due in 60 days: TermsTypeId=3
- Due by end of month: TermsTypeId=4
TimesheetStatus
- Not Started: TimesheetStatusId=0
- Submitted: TimesheetStatusId=1
- Approved: TimesheetStatusId=2
- Locked: TimesheetStatusId=3
TimeslipStatus
- Not Started: TimeslipStatusId=0
- Submitted: TimeslipStatusId=1
- Locked: TimeslipStatusId=2
TravelMode
- Driving: TravelModeId=0
- Walking: TravelModeId=1
- Running: TravelModeId=2
- Road Biking: TravelModeId=3
- Mountain Biking: TravelModeId=4
- Swimming: TravelModeId=5
- Canoeing: TravelModeId=6
TypeOfTimeslip
- Straight Time: TypeOfTimeslipId=0
- Regular Overtime: TypeOfTimeslipId=1
- Premium Overtime: TypeOfTimeslipId=2
- Time-off in lieu Credit: TypeOfTimeslipId=3
- Time-off in lieu Debit: TypeOfTimeslipId=4
SupportedLanguages
- English: SupportedLanguagesId=en
- Finnish: SupportedLanguagesId=fi
- French: SupportedLanguagesId=fr
- German: SupportedLanguagesId=de
- Italian: SupportedLanguagesId=it
- Portuguese: SupportedLanguagesId=pt
- Russian: SupportedLanguagesId=ru
- Spanish: SupportedLanguagesId=es
- Swedish: SupportedLanguagesId=sw