Ecovoyageurs
Member
Hi,
I have a trip list called fk_voyages. On this list, I have a LEFT JOIN on a table called fk_groupes (= departures).
It returns :
Trip 1
- departure 1 on 2018-07-26
- departure 2 on 2018-07-30
Trip 2
- departure 1 on 2018-07-24
I now would like to filter the list (url filter) on the departure date, but I would like the result to all trips, even if they don't have any departure.
My url filter is like :
...fk_groupes___start_date[value][0]=2018-07-25 00:00:00&fk_groupes___start_date[value][1]=2018-07-26 00:00:00&fk_groupes___start_date[condition]=BETWEEN
And it would return :
Trip 1
- departure 1 on 2018-07-26
Trip 2
How is this possible ?
The thing is that even if the JOIN is LEFT, the list only returns a trip that has at least 1 departure.
Ex : In the previous exemple it doesn't show the trip 2.
Thanks for any help !
Theo
I have a trip list called fk_voyages. On this list, I have a LEFT JOIN on a table called fk_groupes (= departures).
It returns :
Trip 1
- departure 1 on 2018-07-26
- departure 2 on 2018-07-30
Trip 2
- departure 1 on 2018-07-24
I now would like to filter the list (url filter) on the departure date, but I would like the result to all trips, even if they don't have any departure.
My url filter is like :
...fk_groupes___start_date[value][0]=2018-07-25 00:00:00&fk_groupes___start_date[value][1]=2018-07-26 00:00:00&fk_groupes___start_date[condition]=BETWEEN
And it would return :
Trip 1
- departure 1 on 2018-07-26
Trip 2
How is this possible ?
The thing is that even if the JOIN is LEFT, the list only returns a trip that has at least 1 departure.
Ex : In the previous exemple it doesn't show the trip 2.
Thanks for any help !
Theo