Changeset f29cd58 for src/main/java/edu/gjoko/schedlr/repositories

Timestamp:

01/15/24 00:11:01 (10 months ago)

Author:

gjoko kostadinov <gjokokostadinov@…>

Branches:

master

Children:

943857c

Parents:

e8999eb

Message:

Add services search functionality.

File:

• src/main/java/edu/gjoko/schedlr/repositories/ServiceRepository.java (modified) (1 diff)

src/main/java/edu/gjoko/schedlr/repositories/ServiceRepository.java

@@ -11 +11 @@
 @Repository
 public interface ServiceRepository extends JpaRepository<Service, Long> {
+
+    @Query(value = "select s from Service as s " +
+            " where (s.serviceType.name like CONCAT('%', :keyword, '%') " +
+            " or s.description like CONCAT('%', :keyword, '%'))" +
+            " and s.serviceStatus = 'ACTIVE'")
+    List<Service> getServicesByKeyword(String keyword);
 }