[rules-users] Searching for archived packages in the repository

Hi, I am trying to get a list of all archived packages from the Drools repository but I can't seem to get packages that have been archived. Below is the query I am using to get a list of archived packages: RulesRepository repo = createRepository(); PackageItem item = repo.createPackage( "testPackage", "A test" ); item.archiveItem( true ); item.checkin( "Archive test" ); System.out.println( "Archived=" + repo.loadPackageByUUID( item.getUUID() ).isArchived()); String sql = "SELECT " + PackageItem.TITLE_PROPERTY_NAME + ", " + PackageItem.DESCRIPTION_PROPERTY_NAME + ", " + PackageItem.CONTENT_PROPERTY_ARCHIVE_FLAG; sql += " FROM " + PackageItem.RULE_PACKAGE_TYPE_NAME; sql += " WHERE "; sql += " jcr:path LIKE '/" + RulesRepository.RULES_REPOSITORY_NAME + "/" + RulesRepository.RULE_PACKAGE_AREA + "/%'"; //sql += " AND " + PackageItem.CONTENT_PROPERTY_ARCHIVE_FLAG + " = 'true'"; Query q = repo.getSession().getWorkspace().getQueryManager().createQuery( sql, Query.SQL ); QueryResult res = q.execute(); Iterator<PackageItem> it = new PackageIterator( repo, res.getNodes() ); while( it.hasNext() ) { PackageItem pi = it.next(); System.out.println( "***** item=" +pi.getUUID() + ", name=" +pi.getName() + ", isArchived=" + pi.isArchived() ); } If I don't archive a package then the code returns my package. I know that the package is archived because if I do "loadPackageByUUID( uuid ).isArchived()" it return true. Does anyone know what I am doing wrong here? Thanks, Len