Class BaseContactQuery

Base class that represents a query for the 'contact' table.

ModelCriteria

cli_db\propel\om\BaseContactQuery

Direct known subclasses

Abstract
Namespace: cli_db\propel\om
Package: propel\generator\cli\db\om
Located at src/cli/db/propel-classes/cli_db/om/BaseContactQuery.php

Methods summary
`public`	# `__construct( string $dbName = 'cli_db', string $modelName = 'cli_db\\propel\\Contact', string $modelAlias = null )` Initializes internal state of BaseContactQuery object. Initializes internal state of BaseContactQuery object. Parameters `$dbName` `string` $dbName The dabase name `$modelName` `string` $modelName The phpName of a model, e.g. 'Book' `$modelAlias` `string` $modelAlias The alias for the model in this query, e.g. 'b'
`public static cli_db\propel\ContactQuery`	# `create( string $modelAlias = null, cli_db\propel\ContactQuery\|Criteria $criteria = null )` Returns a new ContactQuery object. Returns a new ContactQuery object. Parameters `$modelAlias` `string` $modelAlias The alias of a model in the query `$criteria` `cli_db\propel\ContactQuery\|Criteria` $criteria Optional Criteria to build the query from Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\Contact\|cli_db\propel\Contact[]\|mixed`	# `findPk( mixed $key, PropelPDO $con = null )` Find object by primary key. Propel uses the instance pool to skip the database if the object exists. Go fast if the query is untouched. Find object by primary key. Propel uses the instance pool to skip the database if the object exists. Go fast if the query is untouched. $obj = $c->findPk(12, $con); Parameters `$key` `mixed` $key Primary key to use for the query `$con` `PropelPDO` $con an optional connection object Returns `cli_db\propel\Contact\|cli_db\propel\Contact[]\|mixed` the result, formatted by the current formatter
`public cli_db\propel\Contact`	# `findOneByContactId( mixed $key, PropelPDO $con = null )` Alias of findPk to use instance pooling Alias of findPk to use instance pooling Parameters `$key` `mixed` $key Primary key to use for the query `$con` `PropelPDO` $con A connection object Returns `cli_db\propel\Contact` A model object, or null if the key is not found Throws `PropelException`
`protected cli_db\propel\Contact`	# `findPkSimple( mixed $key, PropelPDO $con )` Find object by primary key using raw SQL to go fast. Bypass doSelect() and the object formatter by using generated code. Find object by primary key using raw SQL to go fast. Bypass doSelect() and the object formatter by using generated code. Parameters `$key` `mixed` $key Primary key to use for the query `$con` `PropelPDO` $con A connection object Returns `cli_db\propel\Contact` A model object, or null if the key is not found Throws `PropelException`
`protected cli_db\propel\Contact\|cli_db\propel\Contact[]\|mixed`	# `findPkComplex( mixed $key, PropelPDO $con )` Find object by primary key. Find object by primary key. Parameters `$key` `mixed` $key Primary key to use for the query `$con` `PropelPDO` $con A connection object Returns `cli_db\propel\Contact\|cli_db\propel\Contact[]\|mixed` the result, formatted by the current formatter
`public PropelObjectCollection\|cli_db\propel\Contact[]\|mixed`	# `findPks( array $keys, PropelPDO $con = null )` Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con); Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con); Parameters `$keys` `array` $keys Primary keys to use for the query `$con` `PropelPDO` $con an optional connection object Returns `PropelObjectCollection\|cli_db\propel\Contact[]\|mixed` the list of results, formatted by the current formatter
`public cli_db\propel\ContactQuery`	# `filterByPrimaryKey( mixed $key )` Filter the query by primary key Filter the query by primary key Parameters `$key` `mixed` $key Primary key to use for the query Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\ContactQuery`	# `filterByPrimaryKeys( array $keys )` Filter the query by a list of primary keys Filter the query by a list of primary keys Parameters `$keys` `array` $keys The list of primary key to use for the query Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\ContactQuery`	# `filterByContactId( mixed $contactId = null, string $comparison = null )` Filter the query on the contact_id column Filter the query on the contact_id column Example usage: $query->filterByContactId(1234); // WHERE contact_id = 1234 $query->filterByContactId(array(12, 34)); // WHERE contact_id IN (12, 34) $query->filterByContactId(array('min' => 12)); // WHERE contact_id >= 12 $query->filterByContactId(array('max' => 12)); // WHERE contact_id <= 12 Parameters `$contactId` `mixed` $contactId 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. `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\ContactQuery`	# `filterByTypeId( mixed $typeId = null, string $comparison = null )` Filter the query on the type_id column Filter the query on the type_id column Example usage: $query->filterByTypeId(1234); // WHERE type_id = 1234 $query->filterByTypeId(array(12, 34)); // WHERE type_id IN (12, 34) $query->filterByTypeId(array('min' => 12)); // WHERE type_id >= 12 $query->filterByTypeId(array('max' => 12)); // WHERE type_id <= 12 Parameters `$typeId` `mixed` $typeId 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. `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface See `cli_db\propel\om\BaseContactQuery::filterByCvterm()`
`public cli_db\propel\ContactQuery`	# `filterByName( string $name = null, string $comparison = null )` Filter the query on the name column Filter the query on the name column Example usage: $query->filterByName('fooValue'); // WHERE name = 'fooValue' $query->filterByName('%fooValue%'); // WHERE name LIKE '%fooValue%' Parameters `$name` `string` $name The value to use as filter. Accepts wildcards (* and % trigger a LIKE) `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\ContactQuery`	# `filterByDescription( string $description = null, string $comparison = null )` Filter the query on the description column Filter the query on the description column Example usage: $query->filterByDescription('fooValue'); // WHERE description = 'fooValue' $query->filterByDescription('%fooValue%'); // WHERE description LIKE '%fooValue%' Parameters `$description` `string` $description The value to use as filter. Accepts wildcards (* and % trigger a LIKE) `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\ContactQuery`	# `filterByCvterm( cli_db\propel\Cvterm\|PropelObjectCollection $cvterm, string $comparison = null )` Filter the query by a related Cvterm object Filter the query by a related Cvterm object Parameters `$cvterm` `cli_db\propel\Cvterm\|PropelObjectCollection` $cvterm The related object(s) to use as filter `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface Throws `PropelException` - if the provided filter is invalid.
`public cli_db\propel\ContactQuery`	# `joinCvterm( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::LEFT_JOIN )` Adds a JOIN clause to the query using the Cvterm relation Adds a JOIN clause to the query using the Cvterm relation Parameters `$relationAlias` `string` $relationAlias optional alias for the relation `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\CvtermQuery`	# `useCvtermQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::LEFT_JOIN )` Use the Cvterm relation Cvterm object Use the Cvterm relation Cvterm object Parameters `$relationAlias` `string` $relationAlias optional alias for the relation, to be used as main alias in the secondary query `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\CvtermQuery` A secondary query class using the current class as primary query See useQuery()
`public cli_db\propel\ContactQuery`	# `filterByAssay( cli_db\propel\Assay\|PropelObjectCollection $assay, string $comparison = null )` Filter the query by a related Assay object Filter the query by a related Assay object Parameters `$assay` `cli_db\propel\Assay\|PropelObjectCollection` $assay the related object to use as filter `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface Throws `PropelException` - if the provided filter is invalid.
`public cli_db\propel\ContactQuery`	# `joinAssay( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )` Adds a JOIN clause to the query using the Assay relation Adds a JOIN clause to the query using the Assay relation Parameters `$relationAlias` `string` $relationAlias optional alias for the relation `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\AssayQuery`	# `useAssayQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )` Use the Assay relation Assay object Use the Assay relation Assay object Parameters `$relationAlias` `string` $relationAlias optional alias for the relation, to be used as main alias in the secondary query `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\AssayQuery` A secondary query class using the current class as primary query See useQuery()
`public cli_db\propel\ContactQuery`	# `filterByBiomaterial( cli_db\propel\Biomaterial\|PropelObjectCollection $biomaterial, string $comparison = null )` Filter the query by a related Biomaterial object Filter the query by a related Biomaterial object Parameters `$biomaterial` `cli_db\propel\Biomaterial\|PropelObjectCollection` $biomaterial the related object to use as filter `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface Throws `PropelException` - if the provided filter is invalid.
`public cli_db\propel\ContactQuery`	# `joinBiomaterial( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::LEFT_JOIN )` Adds a JOIN clause to the query using the Biomaterial relation Adds a JOIN clause to the query using the Biomaterial relation Parameters `$relationAlias` `string` $relationAlias optional alias for the relation `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\BiomaterialQuery`	# `useBiomaterialQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::LEFT_JOIN )` Use the Biomaterial relation Biomaterial object Use the Biomaterial relation Biomaterial object Parameters `$relationAlias` `string` $relationAlias optional alias for the relation, to be used as main alias in the secondary query `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\BiomaterialQuery` A secondary query class using the current class as primary query See useQuery()
`public cli_db\propel\ContactQuery`	# `filterByQuantification( cli_db\propel\Quantification\|PropelObjectCollection $quantification, string $comparison = null )` Filter the query by a related Quantification object Filter the query by a related Quantification object Parameters `$quantification` `cli_db\propel\Quantification\|PropelObjectCollection` $quantification the related object to use as filter `$comparison` `string` $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL Returns `cli_db\propel\ContactQuery` The current query, for fluid interface Throws `PropelException` - if the provided filter is invalid.
`public cli_db\propel\ContactQuery`	# `joinQuantification( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::LEFT_JOIN )` Adds a JOIN clause to the query using the Quantification relation Adds a JOIN clause to the query using the Quantification relation Parameters `$relationAlias` `string` $relationAlias optional alias for the relation `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\ContactQuery` The current query, for fluid interface
`public cli_db\propel\QuantificationQuery`	# `useQuantificationQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::LEFT_JOIN )` Use the Quantification relation Quantification object Use the Quantification relation Quantification object Parameters `$relationAlias` `string` $relationAlias optional alias for the relation, to be used as main alias in the secondary query `$joinType` `string` $joinType Accepted values are null, 'left join', 'right join', 'inner join' Returns `cli_db\propel\QuantificationQuery` A secondary query class using the current class as primary query See useQuery()
`public cli_db\propel\ContactQuery`	# `prune( cli_db\propel\Contact $contact = null )` Exclude object from result Exclude object from result Parameters `$contact` `cli_db\propel\Contact` $contact Object to remove from the list of results Returns `cli_db\propel\ContactQuery` The current query, for fluid interface

Magic methods summary
`public cli_db\propel\ContactQuery`	# `orderByContactId( mixed $order = cli_db\propel\om\Criteria::ASC )` Order by the contact_id column Order by the contact_id column Parameters `$order` `mixed` $order Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `orderByTypeId( mixed $order = cli_db\propel\om\Criteria::ASC )` Order by the type_id column Order by the type_id column Parameters `$order` `mixed` $order Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `orderByName( mixed $order = cli_db\propel\om\Criteria::ASC )` Order by the name column Order by the name column Parameters `$order` `mixed` $order Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `orderByDescription( mixed $order = cli_db\propel\om\Criteria::ASC )` Order by the description column Order by the description column Parameters `$order` `mixed` $order Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `groupByContactId( )` Group by the contact_id column Group by the contact_id column Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `groupByTypeId( )` Group by the type_id column Group by the type_id column Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `groupByName( )` Group by the name column Group by the name column Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `groupByDescription( )` Group by the description column Group by the description column Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `leftJoin( mixed $relation = )` Adds a LEFT JOIN clause to the query Adds a LEFT JOIN clause to the query Parameters `$relation` `mixed` $relation Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `rightJoin( mixed $relation = )` Adds a RIGHT JOIN clause to the query Adds a RIGHT JOIN clause to the query Parameters `$relation` `mixed` $relation Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `innerJoin( mixed $relation = )` Adds a INNER JOIN clause to the query Adds a INNER JOIN clause to the query Parameters `$relation` `mixed` $relation Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `leftJoinCvterm( mixed $relationAlias = null )` Adds a LEFT JOIN clause to the query using the Cvterm relation Adds a LEFT JOIN clause to the query using the Cvterm relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `rightJoinCvterm( mixed $relationAlias = null )` Adds a RIGHT JOIN clause to the query using the Cvterm relation Adds a RIGHT JOIN clause to the query using the Cvterm relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `innerJoinCvterm( mixed $relationAlias = null )` Adds a INNER JOIN clause to the query using the Cvterm relation Adds a INNER JOIN clause to the query using the Cvterm relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `leftJoinAssay( mixed $relationAlias = null )` Adds a LEFT JOIN clause to the query using the Assay relation Adds a LEFT JOIN clause to the query using the Assay relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `rightJoinAssay( mixed $relationAlias = null )` Adds a RIGHT JOIN clause to the query using the Assay relation Adds a RIGHT JOIN clause to the query using the Assay relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `innerJoinAssay( mixed $relationAlias = null )` Adds a INNER JOIN clause to the query using the Assay relation Adds a INNER JOIN clause to the query using the Assay relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `leftJoinBiomaterial( mixed $relationAlias = null )` Adds a LEFT JOIN clause to the query using the Biomaterial relation Adds a LEFT JOIN clause to the query using the Biomaterial relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `rightJoinBiomaterial( mixed $relationAlias = null )` Adds a RIGHT JOIN clause to the query using the Biomaterial relation Adds a RIGHT JOIN clause to the query using the Biomaterial relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `innerJoinBiomaterial( mixed $relationAlias = null )` Adds a INNER JOIN clause to the query using the Biomaterial relation Adds a INNER JOIN clause to the query using the Biomaterial relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `leftJoinQuantification( mixed $relationAlias = null )` Adds a LEFT JOIN clause to the query using the Quantification relation Adds a LEFT JOIN clause to the query using the Quantification relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `rightJoinQuantification( mixed $relationAlias = null )` Adds a RIGHT JOIN clause to the query using the Quantification relation Adds a RIGHT JOIN clause to the query using the Quantification relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\ContactQuery`	# `innerJoinQuantification( mixed $relationAlias = null )` Adds a INNER JOIN clause to the query using the Quantification relation Adds a INNER JOIN clause to the query using the Quantification relation Parameters `$relationAlias` `mixed` $relationAlias Returns `cli_db\propel\ContactQuery`
`public cli_db\propel\Contact`	# `findOne( PropelPDO $con = null )` Return the first Contact matching the query Return the first Contact matching the query Parameters `$con` `PropelPDO` $con Returns `cli_db\propel\Contact`
`public cli_db\propel\Contact`	# `findOneOrCreate( PropelPDO $con = null )` Return the first Contact matching the query, or a new Contact object populated from the query conditions when no match is found Return the first Contact matching the query, or a new Contact object populated from the query conditions when no match is found Parameters `$con` `PropelPDO` $con Returns `cli_db\propel\Contact`
`public cli_db\propel\Contact`	# `findOneByTypeId( integer $type_id = )` Return the first Contact filtered by the type_id column Return the first Contact filtered by the type_id column Parameters `$type_id` `integer` $type_id Returns `cli_db\propel\Contact`
`public cli_db\propel\Contact`	# `findOneByName( string $name = )` Return the first Contact filtered by the name column Return the first Contact filtered by the name column Parameters `$name` `string` $name Returns `cli_db\propel\Contact`
`public cli_db\propel\Contact`	# `findOneByDescription( string $description = )` Return the first Contact filtered by the description column Return the first Contact filtered by the description column Parameters `$description` `string` $description Returns `cli_db\propel\Contact`
`public array`	# `findByContactId( integer $contact_id = )` Return Contact objects filtered by the contact_id column Return Contact objects filtered by the contact_id column Parameters `$contact_id` `integer` $contact_id Returns `array`
`public array`	# `findByTypeId( integer $type_id = )` Return Contact objects filtered by the type_id column Return Contact objects filtered by the type_id column Parameters `$type_id` `integer` $type_id Returns `array`
`public array`	# `findByName( string $name = )` Return Contact objects filtered by the name column Return Contact objects filtered by the name column Parameters `$name` `string` $name Returns `array`
`public array`	# `findByDescription( string $description = )` Return Contact objects filtered by the description column Return Contact objects filtered by the description column Parameters `$description` `string` $description Returns `array`

Namespaces

Classes

Class BaseContactQuery

Direct known subclasses

Parameters

Parameters

Returns

Parameters

Returns

Parameters

Returns

Throws

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

See

Parameters

Returns

Parameters

Returns

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

See

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

See

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

See

Parameters

Returns

Throws

Parameters

Returns

Parameters

Returns

See

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Returns

Returns

Returns

Parameters

Returns