I have made an API for reports and it is all working fine, but on adding the filter on one field (status code) it is not giving the expected results.

This is the controller

@GetMapping(path = {"/fyqcv"})
    public Page<ReportingDto> getData(@RequestParam String username, @RequestParam String startDate, @RequestParam String endDate, @RequestParam String statusCode, @RequestParam String search , @RequestParam(name = "page", required = false, defaultValue = "0") Integer page, @RequestParam(name = "limit", required = false, defaultValue = "10") Integer limit) {
        return reportingService.getData(username, startDate, endDate,search,statusCode, page, limit);
    }

and this is how i am making diff repo calls in service layer

if (username != null && startDate != null && endDate != null) {
            entityPage = reportingRepository.findByUsernameAndDates(username, startDate, endDate, pageable);
        } else if (username != null) {
            entityPage = reportingRepository.findByUsername(username, pageable);
        } else if (startDate != null && endDate != null) {
            entityPage = reportingRepository.findByDates(startDate, endDate, pageable);
        } else if(search != null){
            entityPage = reportingRepository.findByTxnId(search, pageable);
        } else if(statusCode != null){
            entityPage = reportingRepository.findbyStatusCode(statusCode , pageable);
        } else {
            entityPage = reportingRepository.findAll(pageable);
        }

this is the repo interface

 @Query("{ 'params.verification_status_code': { $regex: ?0, $options: 'i' } }")
    Page<ReportingEntity> findbyStatusCode(String statusCode, Pageable pageable);

all the queries in repository are giving result as expected but this query findbyStatusCode is not filtering and returning the data with other params only.