Filter with large number of criteria

[AltshulerMG]

This may be a duplicate post; my appologies if it is.

How can I filter a project with around 60 criteria. When I try, project
limits me to 40 entries. Is there a way to increase this limit? Is there
some other type of workabound? Can 2 filters be "chained"?

thanks, Mike

 

[John]

This may be a duplicate post; my appologies if it is.

How can I filter a project with around 60 criteria. When I try, project
limits me to 40 entries. Is there a way to increase this limit? Is there
some other type of workabound? Can 2 filters be "chained"?

thanks, Mike

Mike,
Duplicate posts are normally frowned upon but you recognized a potential
duplicate (we've all been there) so you covered yourself - i.e. no
problem.

It sounds like you have quite a demanding filter. Yes, filters can be
"chained". First break the criteria into groups where spare flag fields
are used for each group. Then filter on the flag fields.

Hope this helps.
John
Project MVP

 

[JackD]

Filters can not be chained.
I am having a hard time imagining why you have 60 different criteria.
Perhaps they can be collapsed somehow.
60 factorial =
8,320,987,112,741,390,000,000,000,000,000,000,000,000,000,000,000,000,000,00
0,000,000,000,000,000,000,000,000.

If you really need to do this then you can use some VBA to filter. With that
you are only limited to the amount of time you want to spend writing/running
code.

If you can give some details on what sort of filtering you are doing which
requires 60 criteria I'd be happy to make some suggestions about how to do
it more efficiently.

 

[AltshulerMG]

The criteria I am using are the ID's. I am periodically getting a schdule
(with almost 1000 tasks) from another group, and I planned to copy the filter
into the updated schedule and then filter out the tasks I am not interested
in. In some cases, the ID's are sequential, and I am using a single crteria
for those; also many of the tasks can be filtered out by specifiying the
summary task. In the end, I have a total of 60 summary task ID's, sequential
group of ID's, or individual ID's.

It wouldn't help to add flag fields, because then each time I get a schedule
update, I would have to add the flag's into the data. On the other hand,
right now I don't see how to copy a set of filter criteria from one schedule
to another.

Perhaps a macro is the only way to go?

thanks

 

[JackD]

Work with the other group and flag the interesting tasks in their original
schedules. You only need to do it once and will benefit from then on.
For example tell them that they should use the Flag1 field and set it to
"Yes" for tasks A, B and C.
Then when they send it to you you just filter on Flag1.

 

[AltshulerMG]

That make the best technical sense, but I am not going to able to do that. I
cannot get the originator to change anything; it all has to be done on my
end. Any other ideas?

thanks

 

[JackD]

If you can get the originator to send you the file, then you should be able
to get them to tag a few tasks.
If they won't do it, then tell them to send you the file, flag the tasks and
send it back.
Try harder.