How to filter activities with external predecesors?

Member for

20 years 3 months

Shahab,



You can run an Activity Relationships report, apply the following filter "Where ’Predecessor Project’ ’does not equal’’Select your current Project from the list’.



Group the Report by Activity.



Once you have the definitive list, you can then nick a udf field to use to flag these activities and filter in the activity view.



Alternatively, if the external links are proper external (i.e. from projects not held on your db [i.e. if you’re a subbie on a project within a larger linked portfolio], you can simply filter within the activity view "where ’external early start’ ’does not equal’ ’blank’ OR ’external late finish’ ’does not equal’ ’blank’



Hope the above helps,



Gordon

Member for

20 years 3 months

Shahab,



You can run an Activity Relationships report, apply the following filter "Where ’Predecessor Project’ ’does not equal’’.



Group the Report by Activity.



Once you have the definitive list, you can then nick a udf field to use to flag these activities and filter in the activity view.



Alternatively, if the external links are proper external (i.e. from projects not held on your db [i.e. if you’re a subbie on a project within a larger linked portfolio], you can simply filter within the activity view "where ’external early start’ ’does not equal’ ’’ OR ’external late finish’ ’does not equal’ ’’



Hope the above helps,



Gordon

Member for

19 years

Naveen,



Thanks for this reply. You are right but these are the hard way of getting the result. I was wondering a simple filter or way to get the activities with external predecessors. Unfortunately searching for specific activity ID or activity title is not a good way in my projects since they come with very different ID’s and names.



Any other filters or solutions?

Any other eager fellow?

Member for

20 years 10 months

Shahab,



If your external project had a different set of activity IDs that begin with specific set of characters, then the easiest way is to filter predecessors that starts with "enter those characters.

Alternate way is to run a report with activities & predecessors as subject areas to get activities with predecessors from external projects. But in this case, you have to mention the external projects (in the filter) from where the predecessor is linked from.



Regards

Naveen