added getById to query, though its not implemented yet
adding report to route