Changeset 45df607

Timestamp:

02/18/25 18:06:32 (3 days ago)

Author:

Nikola Mishevski <Nikola.Mishevski@…>

Branches:

main

Parents:

07b59f8

Message:

name and surname shipment filter amended due to added database indexing

File:

• WineTrackerFinal/WineTrackerWebApi/Controllers/ShipmentController.cs (modified) (1 diff)

WineTrackerFinal/WineTrackerWebApi/Controllers/ShipmentController.cs

@@ -35 +35 @@
             List<string> whereConditons = new List<string>();
             if(!string.IsNullOrEmpty(shipmentDate)) whereConditons.Add("s.shipment_date = @ShipmentDate");
-            if(!string.IsNullOrEmpty(employeeNameSurname)) whereConditons.Add("LOWER(CONCAT(e.employee_name, ' ', e.employee_surname)) Like '%' || @employeeNameSurname || '%'");
+            if(!string.IsNullOrEmpty(employeeNameSurname)) whereConditons.Add("LOWER(e.employee_name || ' ' || e.employee_surname) Like '%' || @employeeNameSurname || '%'");
             if(!string.IsNullOrEmpty(registration)) whereConditons.Add("LOWER(v.registration) = @Registration");