Changes between Version 3 and Version 4 of SearchRoutesUseCase

Timestamp:

01/12/25 21:45:05 (3 days ago)

Author:

222077

Comment:

--

SearchRoutesUseCase

@@ -11 +11 @@
     1.2. If no routes match the search criteria, the user is notified accordingly.
 
+
+ The user clicks on the ‘Search’ button
 {{{#!sql
-SELECT r.route_id, l1.name AS from_location, l2.name AS to_location, tr.company_name AS organizer_name
+SELECT r.route_id, 
+       l1.name AS from_location, 
+       l2.name AS to_location, 
+       tr.company_name AS organizer_name
 FROM route r
-         JOIN location l1 ON r.from_location_id = l1.location_id
-         JOIN location l2 ON r.to_location_id = l2.location_id
-         JOIN transport_organizer tr ON r.transport_organizer_id = tr.transport_organizer_id
+JOIN location l1 ON r.from_location_id = l1.location_id
+JOIN location l2 ON r.to_location_id = l2.location_id
+JOIN transport_organizer tr ON r.transport_organizer_id = tr.transport_organizer_id
 WHERE l1.name ILIKE '%from_location%'
   AND l2.name ILIKE '%to_location%'