ArtiGrid

Where Condition

The where() method allows you to apply filtering conditions to your data query in a flexible way. It supports multiple comparison operators and logical conditions, making it easy to build dynamic queries.

Supported conditions:

Basic comparisons: =, !=, <>, >, <, >=, <=
LIKE operator: for partial text matching
IN operator: pass an array of values (e.g. [1,2,3])
Logical operators: AND / OR between conditions

You can chain multiple where() calls to create more complex filters. For convenience, the whereLike() method is also available for quick LIKE queries.

Example: Filtering records where paymentId is in a specific list.


<?php
    $grid = new ArtiGrid();
    $grid->table('payments')
        ->template('bootstrap5')
        ->where("paymentId", "IN", [21])
        ->required(false);
    echo $grid->render();
?>

	paymentId	customerNumber	checkNumber	paymentDate	amount	Actions