added where and orderBy bean loading capabilities