// This will load all filters by type activity

EnterpriseLoadManager elm = session.getEnterpriseLoadManager();

BOIterator<ActivityFilter> boiActivityFilter = elm.loadActivityFilters(ActivityFilter.getAllFields(), "FilterType = 'VT_LWF_FILTER'", null);

while (boiActivityFilter.hasNext()) {

    ActivityFilter filter = boiActivityFilter.next();

    System.out.println("Filter Id: "        + filter.getActivityFilterId());
    System.out.println("Filter Name: "      + filter.getActivityFilterName());
    System.out.println("Filter Criteria: "  + filter.getFilterCriteria());
    System.out.println("Filter Type: "      + filter.getFilterType());
    System.out.println("Filter UserId: "    + filter.getUserId());
    System.out.println();

}

Types include:

• 'VT_RISK'
• 'VT_FILTER'
• 'VT_TMUSER_FILTER'
• 'VT_FILTER_STANDARD'
• 'VT_ASSIGNS_FILTER'
• 'VT_PROJECTS_FILTER'
• 'VT_PROJ_FILTER_STAND'
• 'VT_ASSIGNS_FILTER'
• 'VT_ASSGN_FILT_STAND'
• 'VT_LWF_FILTER'
• 'VT_ASSGN_LWF_FILTER'
• 'VT_PROJ_LWF_FILTER'
• 'VT_TM_ACT_FILTER'
• 'VT_TM_TS_FILTER'
• 'VT_TM_ACT_STAND'
• 'VT_TM_TS_STAND'

Filter information can be found in the following PMDB table:

select * from viewpref;

// This will use a filter called 'API Activity Filter' to read activity data

EnterpriseLoadManager elm = session.getEnterpriseLoadManager();

BOIterator<ActivityFilter> boiActivityFilter = elm.loadActivityFilters(ActivityFilter.getAllFields(), "ActivityFilterName = 'API Activity Filter'", null);

if (boiActivityFilter.hasNext()) {

    ActivityFilter filter = boiActivityFilter.next();

    BOIterator<Activity> boiActivity = elm.loadActivities(Activity.getAllFields(), filter.getFilterCriteria(), null);

    while (boiActivity.hasNext()) {

        Activity activity = boiActivity.next();
        System.out.println(activity.getId() + "  " + activity.getName());

    }

} 

else {

    System.out.println("No filter named 'API Activity Filter' found.");

}