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.

DateTime


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


Id


Guid


String


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


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


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