I don't encounter any problem when only single data is in assignedTo however when multiple data is in assignedTo its validation no longer works, it is separated by the pipeline,

example of single data by assignedTo:

123456

for multiple data of assignedTo:

123456|789101

current code

    hasExistingEvent: (assignedTo) => {
        var assignes = assignedTo.replace(/\|/g, ",")
        return  new Promise((resolve, reject) => {
            .....("SELECT exp_fAssignedTo FROM Event WHERE exp_fAssignedTo LIKE '%" + assignes + "%'", 100, function(a){
                return !resolve(a.length ==0)
            })
        })
    },
    validatedUserExistsEvent: async(data) => {
        var {  assignedTo } = data
        var hasExisting = await _data.hasExistingEvent(assignedTo);
        console.log(hasExisting)
        return hasExisting;
    },

the exp_fAssignedTo field is collection of ids , Its a string of ids. Separated by coma

data from database

I don't know how or what logic to do