I am trying to fetch all the rows where deletedAt fields are null. But it's not working.
List<DesignTeam> findByDesignTeamContainingIgnoreCaseOrDesignCodeContainingIgnoreCaseAndDeletedAtNullOrderByIdDesc(String search, String s, Pageable pageable);
Asked
Active
Viewed 19 times
0
Jens Schauder
- 77,657
- 34
- 181
- 348
Majed Abdullah
- 1
- 4
-
How does the genererated SQL look like? – Simon Martinelli Jul 21 '22 at 11:15
-
select * from designTeam where deleted_at is null and (design_team like '%params%' or design_code like '%param2%' orderBy id desc limit 0 offset 10; – Majed Abdullah Jul 21 '22 at 11:21
-
1And this is not what you want? – Simon Martinelli Jul 21 '22 at 11:54
-
Yes! But I want to write ***findByDesignTeamContainingIgnoreCaseOrDesignCodeContainingIgnoreCaseAndDeletedAtNullOrderByIdDesc*** in this way. – Majed Abdullah Jul 21 '22 at 12:17