The conn.get_data method holds onto previous filters values. This can be seen where trying to retrieve several road_ids from a table one after the other. In this situation only the first road_id is retrieved as the filter for the next road_id contains all subsequent road_ids so there are no matching rows.
The
conn.get_datamethod holds onto previousfiltersvalues. This can be seen where trying to retrieve several road_ids from a table one after the other. In this situation only the first road_id is retrieved as the filter for the next road_id contains all subsequent road_ids so there are no matching rows.