Hi, I agree with what Ola says, you should definitely not split your database because of this. I am not sure if it is feasible to involve report tables in excel reporting. In any case there is a method on OrganisationUnitService which allows you to get all children of a specific orgunit on a specific orgunit level:
/** * Returns all OrganisationUnits which are children of the given unit and are * at the given hierarchical level. The root OrganisationUnits are at level 1. * * @param level the hierarchical level. * @param parent the parent unit. * @return all OrganisationUnits which are children of the given unit and are * at the given hierarchical level. * @throws IllegalArgumentException if the level is illegal. */ Collection<OrganisationUnit> getOrganisationUnitsAtLevel( int level, OrganisationUnit parent ); Lars
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp