Smart Report Engine Documentation | Method: filter

filter_equal

 
          filter_equal(string $table, string $column, mixed $param, $parameters_type = Constants::SRE_NUMBER)

This filter should be used with a numeric or DateTime column to get the data that is equal to a certain parameter value. Please note that you can combine multiple filters for the same report.

# This method is available in both the community edition and the commercial edition .

# Note

The column you are using for any of the filters methods must be a selected column in your report.

# Parameters

Parameter	Description
$table	The table which contains the filter by column.
$column	The filter by column (The column by which you want to filter the report )
$param	The filter parameter value. It can be a number or a string parameter.
$parameters_type	The data type of the filter parameter. It can be SRE_NUMBER or SRE_TEXT. If omitted, SRE_NUMBER will be used.

# Returns

This method returns the calling object, so it can be chained with other methods in the ‘ReportOptions’ class

# Code Example

 
           $report = new ReportOptions(SRE_PUBLIC_REPORT);
$report->select_tables(array("items"))
       ->select_fields(array("id", "country", "date", "units_in_stock","product_name"))
       ->filter_like("items", "country", "usa")
       ->filter_equal("items", "date", "2018-01-01",SRE_TEXT);
$engine = new CustomEngine($report);
$report_path = $engine->create_report();

# See Also

filter_not_like
filter_not_equal
filter_between
filter_less

# Related Post

Building reports with data filters using Smart Report Engine