private async _updateRefIdRecordByRefId(refField: string, sourceRefId: string, destinationRefId: string): Promise<any>{
    try{
        const uSets: any = {};
        const uWhere: any = {};
        
        uSets[refField] = sourceRefId;
        uWhere[refField] = destinationRefId;
        
        const affectedRow = await this.repository.update(uWhere, uSets);

        return affectedRow.affected as number;
    } catch(err: any){
        throw new BadRequestException(err, err.message);
    }
}