admin-server/src/main/java/com/estate/expert/admin/domain/project/ProjectRepository.java
@@ -36,5 +36,11 @@ @Query("select p.id from Project p where ( :keyword is null or :keyword = '' or p.name like %:keyword% ) " + "and p.deleted = false " ) List<Integer> listProjectIds(@Param("keyword") String keyword); @Query("select p from Project p where ( :name is null or :name = '' or p.name like %:name% ) " + "and p.deleted = false " + "order by p.updateTime desc") List<Project> findAllByTitleIdAndDeleted(String name); }