/** * Filter the query by column * * Example usage: * * $query->filterBy(1234); // WHERE = 1234 * $query->filterBy(array(12, 34)); // WHERE IN (12, 34) * $query->filterBy(array('min' => 12)); // WHERE >= 12 * * * @param mixed $value The value to use as filter. * Use scalar values for equality. * Use array values for \in_array() equivalent. * Use associative array('min' => $minValue, 'max' => $maxValue) for intervals. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL * * @return $this| The current query, for fluid interface */ public function filterBy($value = null, $comparison = null) { return $this->useQuery()->filterBy($value, $comparison)->endUse(); } /** * Adds an ORDER BY clause to the query * Usability layer on top of Criteria::addAscendingOrderByColumn() and Criteria::addDescendingOrderByColumn() * Infers $column and $order from $columnName and some optional arguments * Examples: * $c->orderBy('Book.CreatedAt') * => $c->addAscendingOrderByColumn(BookTableMap::CREATED_AT) * $c->orderBy('Book.CategoryId', 'desc') * => $c->addDescendingOrderByColumn(BookTableMap::CATEGORY_ID) * * @param string $order The sorting order. Criteria::ASC by default, also accepts Criteria::DESC * * @return $this|ModelCriteria The current object, for fluid interface */ public function orderBy($order = Criteria::ASC) { return $this->useQuery()->orderBy($order)->endUse(); }