Custom Filter: two Resources and Start-Date

[Sascha Wald]

Hi,

Using filters in MS Project is not that easy way as in Excel. I need a
special filter in MS Project that gives me al tasks from two resources,
starting after or at least on a given date.
So the "where" clause is:
((Resourcename is 'Patty') or (Resourcename is 'Georg)) AND (start >=
#2004/03/05#)
I can do this manually in a customized filter, but what I want is
- how can I set order of filtering (first all ORs, then AND) to avoid
writing Resource and Date criteria for each resource?
- how can I show a dialogue to select the resource like it is in the filter
'uses resource'?
- why can't I copy or edit the filter 'uses resources...'

Do I need VBA for this?

regards
Sascha

**************************************
adminsoft
Sascha Wald
Software-Entwicklung und -Wartung
www.adminsoft.info
**************************************

 

[Gérard Ducouret]

Hello Sascha,
This filter, like the All Tasks filter is protected in MS Project.

To create your filter :
Project / Filter For / More filters / New...
- Field Name : Resource Names
- Test : contains
- Value : "First resource name"?
Or
- on the same row that the "Or" : Field Name : Resource Names
- Test : contains
- Value : "Second resource name"?
AND
- skip a row : grey line
- Field Name : Start
- Test : is greater than or equal to
- Value : "Start Date of the task"?

Note the ? just after the "" without any space for interactive dialog box.
If you want a drop down list for the resource names, you have to develop it
with VBA.

Hope this helps,

Gérard Ducouret

 

[Sascha Wald]

Salut Gérard,

Hello Sascha,

This filter, like the All Tasks filter is protected in MS Project.

To create your filter :
Project / Filter For / More filters / New...
- Field Name : Resource Names
- Test : contains
- Value : "First resource name"?
Or
- on the same row that the "Or" : Field Name : Resource Names
- Test : contains
- Value : "Second resource name"?
AND
- skip a row : grey line
- Field Name : Start
- Test : is greater than or equal to
- Value : "Start Date of the task"?

Note the ? just after the "" without any space for interactive dialog box.
If you want a drop down list for the resource names, you have to develop it
with VBA.

Unfortunately I still don't understand th Or-And-priority, but that is
something I will do researches on.
I tested your filter and it worked, thank you. AND: there is automatically a
drop-down-list for Resources and a calendar for the date-field!!!

Thank You

Sascha