NewsletterQuery

Initializes internal state of \Thelia\Model\Base\NewsletterQuery object.

Returns a new ChildNewsletterQuery object.

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);

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

Filter the query by primary key

Filter the query by a list of primary keys

Filter the query on the id column

Example usage: $query->filterById(1234); // WHERE id = 1234 $query->filterById(array(12, 34)); // WHERE id IN (12, 34) $query->filterById(array('min' => 12)); // WHERE id > 12

Filter the query on the email column

Example usage: $query->filterByEmail('fooValue'); // WHERE email = 'fooValue' $query->filterByEmail('%fooValue%'); // WHERE email LIKE '%fooValue%'

Filter the query on the firstname column

Example usage: $query->filterByFirstname('fooValue'); // WHERE firstname = 'fooValue' $query->filterByFirstname('%fooValue%'); // WHERE firstname LIKE '%fooValue%'

Filter the query on the lastname column

Example usage: $query->filterByLastname('fooValue'); // WHERE lastname = 'fooValue' $query->filterByLastname('%fooValue%'); // WHERE lastname LIKE '%fooValue%'

Filter the query on the locale column

Example usage: $query->filterByLocale('fooValue'); // WHERE locale = 'fooValue' $query->filterByLocale('%fooValue%'); // WHERE locale LIKE '%fooValue%'

Filter the query on the unsubscribed column

Example usage: $query->filterByUnsubscribed(true); // WHERE unsubscribed = true $query->filterByUnsubscribed('yes'); // WHERE unsubscribed = true

Filter the query on the created_at column

Example usage: $query->filterByCreatedAt('2011-03-14'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt('now'); // WHERE createdat = '2011-03-14' $query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at > '2011-03-13'

Filter the query on the updated_at column

Example usage: $query->filterByUpdatedAt('2011-03-14'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt('now'); // WHERE updatedat = '2011-03-14' $query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at > '2011-03-13'

Exclude object from result

Deletes all rows from the newsletter table.

Performs a DELETE on the database, given a ChildNewsletter or Criteria object OR a primary key value.

Filter by the latest updated

Filter by the latest created

Order by update date desc

Order by update date asc

Order by create date desc

Order by create date asc

Order by the id column

Order by the email column

Order by the firstname column

Order by the lastname column

Order by the locale column

Order by the unsubscribed column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the email column

Group by the firstname column

Group by the lastname column

Group by the locale column

Group by the unsubscribed column

Group by the created_at column

Group by the updated_at column

Adds a LEFT JOIN clause to the query

Adds a RIGHT JOIN clause to the query

Adds a INNER JOIN clause to the query

Return the first ChildNewsletter matching the query

Return the first ChildNewsletter matching the query, or a new ChildNewsletter object populated from the query conditions when no match is found

Return the first ChildNewsletter filtered by the id column

Return the first ChildNewsletter filtered by the email column

Return the first ChildNewsletter filtered by the firstname column

Return the first ChildNewsletter filtered by the lastname column

Return the first ChildNewsletter filtered by the locale column

Return the first ChildNewsletter filtered by the unsubscribed column

Return the first ChildNewsletter filtered by the created_at column

Return the first ChildNewsletter filtered by the updated_at column

Return ChildNewsletter objects filtered by the id column

Return ChildNewsletter objects filtered by the email column

Return ChildNewsletter objects filtered by the firstname column

Return ChildNewsletter objects filtered by the lastname column

Return ChildNewsletter objects filtered by the locale column

Return ChildNewsletter objects filtered by the unsubscribed column

Return ChildNewsletter objects filtered by the created_at column

Return ChildNewsletter objects filtered by the updated_at column