Page Comparison

The Custom Task Filters List appears in the bottom of the Task Filters Tab. It is used to filter by task column values.

The New button creates adds a Custom Task Filter to the Custom Task Filter List.

Removes the associated Task Filter From the Custom task Filter List

Activates the associated Task Filter. Multiple task filters can be activated at once.

Select a Custom Task Filter in the list to open the Edit Custom Task Filter Window.

The Edit Custom Task Filter Window allows you to define the a rules by which the tasksare filtered. For each column in the task table there is a separate rule. To edit a rule click on it in the List.

When a rule is edit the you may enter data that a task must match in order remain in the task view while the filter is active.

All rules that have a checkbox marked in the Culumn Filter Rules List are active and will filter according to their settings.

A Comparison Operator is used to control how the data is filtered. Use the drop down menu to change the comparison operator. Depending on the column type different options are avialable

A Value is used to control what data is used to compare to the data in the task column. The user menu to control the value is different depending on the column type.Match to Custom Column ????????

In some situations a user may want to match data in a specifc column to a custom column.

The Match to Custom Column drop down menu is used to select a custom column that the Selected column matches. Only tasks that have an exact match for the data in the specified custom column and the associated column used to create the rule are displayed in the gantt chart.

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

All Task Filter Rules can share two 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 : Many of the 4D Columns contain text based data. Columns with text based data 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 columns like Object Count and % complete that need special operators that only work with numbers.

Durations : Durations 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 Rulescomparison 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.

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.