transaction getall tests in logic