Developer forum

For such scenarios we've used a User Repository with index, queries etc. if you don't need the user object themselves.

You could create your own safe SQL query to fetch the users from the database and then use Fill to populate them:

private static UserCollection GetUsersByCustomerNumber(string customerNumber)
{
  var users = new UserCollection();
  var sqlCommandText = "SELECT * FROM AccessUser WHERE AccessUserCustomerNumber = {0} AND AccessUser_IsCompany = 1";
  var commandBuilder = new CommandBuilder();
  commandBuilder.Add(sqlCommandText, customerNumber);

  using (var dataReader = Database.CreateDataReader(commandBuilder))
  {
    while (dataReader.Read())
    {
      var user = new User();
      user.Fill(dataReader);
      users.Add(user);
    }
  }
  return users;
}

This only loads the basic user data, so not sure if this gives you exactly what you need (for example, I assume this won't load addresses). If that's a concern, you could do a double query: fetch user IDs with a custom query and then use the API to fetch those users by their ID.

Imar