cancel
Showing results for 
Search instead for 
Did you mean: 

using $findAll operator with variables

Former Member
0 Kudos

Hi,

i'm facing again some troubles dealing this time with the $findAll method...

i've got this code, but is throwing an error

Error: Error in matching clause: Value of $eq must be a String, Number, Boolean or Date


Is there a way to pass the value via variable?? Will it work with the creation of the new instance in the code below?

function setGroupUsers(groupId, listUsers) {
  //var con = null;
    try {
       var instances = user_groupEntity.$findAll({ group_id: { $eq: groupId } });
       user_groupEntity.$discardAll(instances);

//    con.executeUpdate("DELETE FROM user_group WHERE group_id = ?", groupId);
   users = listUsers.split(",");

      for (var i = 0; i < users.length; i++) {
         var instance = new user_groupEntity({ user_id: users[i], group_id: groupId });
         instance.$save();

// con.executeUpdate("INSERT INTO user_group (group_id, user_id) VALUES (?,?)", groupId, users[i]);

    }
//con.commit();
    } catch(err) {
      throw err;
    }
}

Is there a way to pass the value via variable?? Will it work with the creation of the new instance in the code above? If the answer is No, would someone tell me haw to solve this?

Thank you very much in advance.

Best regards,

Luis.

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor
0 Kudos

Hello Luis,

variables are of course supported. Can you check which value your parameter "groupId" contains and that it is not null or undefined?

Best Regards,

Florian

Former Member
0 Kudos

OMG, sorry to bother you with this silly question...i thought i had that possibility controlled...

Thank you very much

Answers (0)