The Work Cache by default includes only open work items. It is also possible to configure which specific list items are added to the Work Cache.
This can be achieved by adding a calculated Yes/No column to the list. The recommended steps, with some examples, are described below.
Each of these steps assumes you are in a List Settings page.
Select Create column in the list
Set the Column name to
Set the type of column to Calculated (calculation based on other columns)
Add a Formula. See below for examples
Set the data type returned from this formula to Yes/No
Whether to include the column in a view is up to you. It can be useful initially to test the formula entered.
Click OK to save the column
Note: The list column must be a calculated Yes/No column.
The list column's internal name must be: bwAddItemToWorkCache
The 'bwAddItemToWorkCache' column is not a readily understandable title for the column, so you can rename it to aid understanding:
In the list of columns, click on 'bwAddItemToWorkCache'
Change the Column name to something more intuitive for example
Include in Work Cache (Hidden)
The 'bwAddItemToWorkCache' column is a complex concept and not something you want everyone to see. To hide the column from forms:
Select Column Visibility Settings (BrightWork)
Make sure each checkbox for 'bwAddItemToWorkCache' is not set. This hides the column in the interface as much as possible
Once the 'bwAddItemToWorkCache' column is in place it will determine which items are included or excluded from the Work Cache.
If items from the list are already in the Work Cache then you will want to refresh the Work Cache to reflect your changes. To do this you should run a Work Cache Refresh for the project.
Here are some examples to help illustrate how this can work. Values that return 'Yes' are included in the Work Cache. Values that return 'No' are excluded from the Work Cache.
Formula that will include everything in the list in the Work Cache:
Formula that will exclude everything in the list from the Work Cache:
Include items with a Due Date in the next 7 days:
Include open Priority 1 Issues:
=AND([Completed Flag]=FALSE,[Priority Code]="1")
Include open Priority 1 Tasks:
Include all Risks that don't start with a bracket:
Tip! Learn more about Calculated Field Formulas
Note: Depending on your SharePoint server language, the comma delimiter used above may be different. For example, in the US English the delimeter is
, while in French the delimeter is
So, in the example above for 'Include open Priority 1 Tasks' the formula would be
=AND(Completed=FALSE;MID(Priority;2;1)="1") for a French language server.