use Civi\Api4\Contact;
use Civi\Api4\Contribution;
use Civi\Api4\Relationship;
-use api\v4\UnitTestCase;
+use api\v4\Api4TestBase;
+use Civi\Test\TransactionalInterface;
/**
* @group headless
*/
-class DateTest extends UnitTestCase {
+class DateTest extends Api4TestBase implements TransactionalInterface {
public function testRelationshipDate() {
$c1 = Contact::create()
$this->assertContains($act[5], $result);
$this->assertContains($act[6], $result);
+ // Ensure it also works if the DATE() function is used
$result = Activity::get(FALSE)->addSelect('id')
- ->addWhere('activity_date_time', '>=', 'this.year')
+ ->addWhere('DATE(activity_date_time)', '>=', 'this.year')
->execute()->column('id');
$this->assertNotContains($act[0], $result);
$this->assertNotContains($act[1], $result);