Available Filter Options - Program List
This article describes the Fields available for filtering and their respective conditions as well as available values.
Available Filter options:
Field Name
|
Description | Available options | Conditions |
---|---|---|---|
Alternate Manager | The Alternate Manager selected in Program Edit. | In, Not in | Only the Value1 column will be available as a browse field. Clicking the browse field will open the User List. |
End | The Actual End date of the program: Earliest Project Start date of the associated Project(s). | Equal to, Not equal to, Greater than or equal to, Less than or equal to, Less than, Greater than, Between, Not between, Today, This Week, Last Week, This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, Year to Date, This Fiscal Month, Last Fiscal Month, This Fiscal Quarter, Last Fiscal Quarter, This Fiscal Year, Last Fiscal Year, Fiscal Year to Date | When Between or Not between is selected, both Value fields will be available; otherwise, only Value1 will be available.
Calendar values only. |
Health | The health of the program. | In, Not in | Only the Value1 column will be available and it will be a multi-select combo-box with all health indicators available. |
Id | The id of the program. | Equal to, Not equal to, Like, Not like, In, Not in | Only the Value1 field will be available . It will be a text field. When In or Not in are selected, the values must be delimited by commas. |
Is Active | The suspended flag of the Program. | In, Not in |
Only the Value1 column will be available and it will be a multi-select combo-box with the following values:
|
Manager | The actual manager of the program. | In, Not in | Only the Value1 column will be available as a browse field. Clicking the browse field will open the User List. |
Name | Program name. | Equal to, Not equal to, Like, Not like, In, Not in | Only the Value1 field will be available . It will be a text field. When In or Not in are selected, the values must be delimited by commas. |
Planned End | The planned start date of the program set in Program Edit. | Equal to, Not equal to, Greater than or equal to, Less than or equal to, Less than, Greater than, Between, Not between, Today, This Week, Last Week, This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, Year to Date, This Fiscal Month, Last Fiscal Month, This Fiscal Quarter, Last Fiscal Quarter, This Fiscal Year, Last Fiscal Year, Fiscal Year to Date | When Between or Not between is selected, both Value fields will be available; otherwise, only Value1 will be available.
Calendar values only. |
Planned Start | The planned end date of the program set in Program Edit. | Equal to, Not equal to, Greater than or equal to, Less than or equal to, Less than, Greater than, Between, Not between, Today, This Week, Last Week, This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, Year to Date, This Fiscal Month, Last Fiscal Month, This Fiscal Quarter, Last Fiscal Quarter, This Fiscal Year, Last Fiscal Year, Fiscal Year to Date | When Between or Not between is selected, both Value fields will be available; otherwise, only Value1 will be available.
Calendar values only. |
Projects Count | The number of Projects associated to the Program. | Equal to, Not equal to, Greater than or equal to, Less than or equal to, Less than, Greater than, Between, Not between | When Between or Not between is selected, both Value fields will be available; otherwise, only Value1 will be available.
Number values only. |
Start | The Actual Start date of the program: Earliest Project Start date of the associated Project(s). | Equal to, Not equal to, Greater than or equal to, Less than or equal to, Less than, Greater than, Between, Not between, Today, This Week, Last Week, This Month, Last Month, This Quarter, Last Quarter, This Year, Last Year, Year to Date, This Fiscal Month, Last Fiscal Month, This Fiscal Quarter, Last Fiscal Quarter, This Fiscal Year, Last Fiscal Year, Fiscal Year to Date | When Between or Not between is selected, both Value fields will be available; otherwise, only Value1 will be available.
Calendar selection. |