Changes between Version 3 and Version 4 of ViewMyTripsUseCase

Timestamp:

01/13/25 16:27:04 (42 hours ago)

Author:

221514

Comment:

--

ViewMyTripsUseCase

@@ -32 +32 @@
 JOIN trip_stops as stop on lf.location_id = stop.location_id
 WHERE tick.account_id = {account_lists_id}
-AND status = {selected_status} -- Optional
-AND (trip.date < {before_date} AND trip.date < {after_date}) -- Optional
-AND t_o.company_name = {selected_company_name}; -- Optional
+AND ({selected_status} IS NULL OR tick.status = {selected_status})
+AND ({before_date} IS NULL OR trip.date < {before_date})
+AND ({after_date} IS NULL OR trip.date > {after_date})
+AND ({selected_company_name} IS NULL OR t_o.company_name = {selected_company_name});
 }}}