MetadataPackageVersion

1// Finds all Active subscriber orgs that have the package installed
2String PACKAGE_SUBSCRIBER_ORG_KEY_QUERY = "Select OrgKey from PackageSubscribers where OrgStatus = 'Active' and InstalledStatus = 'I'";
3
4// Finds all MetadataPackageVersions lower than the version given, including the list 
5// of subscribers for each version
6String METADATA_PACKAGE_VERSION_QUERY = "Select Id, Name, ReleaseState, (%s) from"
7	+ " MetadataPackageVersion where MetadataPackageId = '%s' AND ReleaseState = 'Released'"
8	+ " AND (MajorVersion < 3 OR (MajorVersion = 3 and MinorVersion < 4)"
9	+ " OR (MajorVersion = 3 and MinorVersion = 4 and PatchVersion < 6))";
10
11// conn is an EnterpriseConnection instance initialized with a ConnectionConfig object
12// representing a connection to the developer org of the package
13QueryResult results = conn.query(String.format(METADATA_PACKAGE_VERSION_QUERY, PACKAGE_SUBSCRIBER_ORG_KEY_QUERY));
14
15// This list will hold all of the PackageSubscriber objects that are eligible for upgrade
16// to the given version
17List<PackageSubscriber> subscribers = new ArrayList<>();
18for (SObject mpvso : results.getRecords()) {
19
20		// Cast the sObject to a MetadataPackageVersion
21		MetadataPackageVersion mpv = (MetadataPackageVersion) mpvso;
22
23		// Add subscribers to our list
24		if (mpv.getPackageSubscribers() != null) {
25			for (SObject psso : mpv.getPackageSubscribers().getRecords()) {
26				subscribers.add((PackageSubscriber) psso);
27			}
28	}
29}