Building Filters

Modified on 2017/05/25 14:49 by Charles — Categorized as: GUI, Jazz

Table of Contents [Hide/Show]

   Building Filters
      Boolean
      DateTime
      Date
      DateTimeOffset
      TimeSpan
      Id
      Guid
      String
      Color
      Int32
      Decimal
      Double
      Int64
      Complex Filter Expressions
   Enumerations Overview
      AccessTarget
      ActionType
      AssetType
      CatanPlayerType
      CatanPlayerStatus
      CatanPlayingState
      CatanGameState
      CategoryType
      ClassType
      ConditionType
      Country
      EmployeeType
      LogCategory
      LogType
      MessageType
      NotificationType
      Province
      VolunteerType
      ActiveStatus
      AccessType
      AssignmentStatus
      AudioType
      Clearance
      ContactStatus
      CostInfo
      ErrorLevel
      FontFamily
      FontSize
      ImportanceUrgence
      Priority
      ProjectStatus
      Recurrence
      ResourceType
      SlideShowOrder
      SlideShowSelection
      SortOrderDisplay
      SortPropertyDisplay
      StartPage
      StartState
      StorageType
      TaskDueDate
      TaskState
      Theme
      TermsType
      TimesheetStatus
      TimeslipStatus
      TravelMode
      TypeOfTimeslip
      SupportedLanguages

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