replace modified retrieveAll method with retrieveAllActive method