added query to find transactions by their status