const originalLogger = this.repository.manager.connection.logger;

        // Create a custom logger for this query
        this.repository.manager.connection.logger = {
        ...originalLogger,
        logQuery: (query, parameters) => {
            console.log('Generated SQL Query:', query);
            console.log('Parameters:', parameters);
        },
        };

        // matching user resume on given jobpost
        const where: FindOptionsWhere<UserResumeEntity> = {
            wauthostatus_id: record.wauthostatus_id,
            //state_id: In(state_id),
            acaddeg_id: record.acaddeg_id,
            //gradu_acadfield_id: record.,
            postgradu_acadfield_id: record.postgradu_acadfield_id,
            //joblevl_id: record.,
            econosect_id: record.econosect_id,
            busitype_id: record.busitype_id,
            businature_id: record.businature_id,
            jobnature_id: record.jobnature_id,
            jobcat_id: record.jobcat_id,
            applicant_curr_location: record.applicant_curr_location,
            zipcode: record.zipcode,
            work_area: record.work_area,
            work_time: record.work_time,
            gradu_institution: record.gradu_institution,
            postgradu_institution: record.postgradu_institution,
            salary: record.salary,
            //gradu_acadfield_id: record.gradu_acadfield_id,
        };
        if(record.fr_job_post_graduation_academic_fields){
            const gradu_acadfield_ids = record.fr_job_post_graduation_academic_fields.map(graduAcademicField => graduAcademicField.graduation_acadfield_id);
            where['gradu_acadfield_id'] = In([...gradu_acadfield_ids]);
        }
        if(record.fr_job_post_job_levels){
            const joblevl_id = record.fr_job_post_job_levels.map(jobLevel => jobLevel.joblevl_id);
            where['fr_user_resume_job_levels'] = {
                'joblevl_id': In([...joblevl_id])
            };
        }
 
       const resp = await this.repository.find({
          select: {
             id: true,
             u_id: true,
             title: true,
             desc: true,
             send_msg_to_employer: true,
          },
          where: where as UserResumeEntity, // TODO: in future we need to rewrite where condition to match more precise records, at this moment this is only for basic demo
       });
       // Restore the original logger
        this.repository.manager.connection.logger = originalLogger;