public notBetweenWhere (mixed $expr, mixed $minimum, mixed $maximum) Appends a NOT BETWEEN condition to the current conditions $criteria->notBetweenWhere('price', 100.25, 200.50);

public limit (mixed $limit, [mixed $offset]) Adds the limit parameter to the criteria

public leftJoin (mixed $model, [mixed $conditions], [mixed $alias]) Adds a LEFT join to the query $criteria->leftJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

public join (mixed $model, [mixed $conditions], [mixed $alias], [mixed $type]) Adds an INNER join to the query $criteria->join('Robots'); $criteria->join('Robots', 'r.id = RobotsParts.robots_id'); $criteria->join('Robots', 'r.id = RobotsParts.robots_id', 'r'); $criteria->join('Robots', 'r.id = RobotsParts.robots_id', 'r', 'LEFT');

public inWhere (mixed $expr, array $values) Appends an IN condition to the current conditions $criteria->inWhere('id', [1, 2, 3]);

public innerJoin (mixed $model, [mixed $conditions], [mixed $alias]) Adds an INNER join to the query $criteria->innerJoin('Robots'); $criteria->innerJoin('Robots', 'r.id = RobotsParts.robots_id'); $criteria->innerJoin('Robots', 'r.id = RobotsParts.robots_id', 'r');

public having (mixed $having) Adds the having clause to the criteria

public groupBy (mixed $group) Adds the group-by clause to the criteria

public getWhere () Returns the conditions parameter in the criteria

public array getParams () Returns all the parameters defined in the criteria