I have products with different times in the same table::
id_product
time_station_1_line1
desc_1_line_1
time_station_1_line2
desc_2_line2
time_station_2_line1
desc_2_line1
time_station_2_line2
desc_2_line2
I need a filtering panel per global day, this is how I solve it (I am aware that this is wrong): :
day(time_station_1).
One of the problems I have is that when I filter for example on day 1 there are records that I lose because there are products that pass through either line 1 or line 2.
ex:
product a223 -> time_station1 line 2 -> time_station2 line 2
product a224 -> time_station1 line 1 -> time_station 2 line 1
