Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Depending on the type of data that is contained within a given column the associated custom task filter rule has different options to allow the user control what is filtered. Task Table Columnscontainsa detailed list of the different kinds of columns in Fuzor and thier purpose. There are 5 column types that can be used with a Custom task Filter.

  • Text based

  • Selectable Options

  • Duration

  • Dates

  • Numeric

Two comparison operators are shared by most task filter rules. Only Rules that filter Date columns do not contain the Equal to and Not Equal comparison operators.

Equal to : Tasks with column data that match the column value exactly are displayed in the gantt chart

Not Equal : Any task with column data that does not match the column value exactly is displayed in the gantt chart.

The Selectable Options columns do not need any additional comparison operators. Many columns have selectable options that control the column data. Similarly asscoiated task filters allow the user to select from possible values that can be stored within these columns.

The Text Based solumns allow the user to specify a value with a textbox. Addional available comparison operators for text based data are:

  • Contains : Tasks with column data that contains the text in the column value are displayed in the gantt chart.

  • Not Contains : Tasks with column data that do not contain the text in the column value are displayed in the gantt chart.

The Numeric columns like Object Count and % complete that need special operators that only work with numbers.

The Duration columns are similar to numeric columns, however both the data and the Filter Rules are calculated using information in the Calendar settings. For example the number of hours in a day.

Both duration and numeric columns share similar task filter comparison operators.

Greater Than : Tasks that with column data that is greater than The Duration or Number specified in the column value are displayed in the gannt chart.

Greater Or Equal : Tasks that with column data that is greater than or equal to The Duration or Number specified in the column value are displayed in the gannt chart.

Less Than :Tasks that with column data that is less than The Duration or Number specified in the column value are displayed in the gannt chart.

Less Or Equal : Tasks that with column data that is less than or equal to The Duration or Number specified in the column value are displayed in the gannt chart.

The Date columns allow the user to specify a date as the column value.

Image RemovedImage Added

Changes the date of the column value.

Date column filter rules have the following comparison operators.

On : Tasks with a date in the specified column that is at the same date and time as the date specified by the column value.

Before : Tasks with a date in the specified column that occurs before the date specified by the column value.

After : Tasks with a date in the specified column that occurs after the date specified by the column value.

...