Smart Report Engine Documentation

filter_like

 
          filter_like(string $table,string $column, string $param)

This filter should be used with a textual data type column to get the data that is like a certain textual 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

All filters supported in Smart Report Engine starts with the word

# 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 only be a string value.

# 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_more("items", "date", "2018-01-01",SRE_TEXT);
$engine = new CustomEngine($report);
$report_path = $engine->create_report();

# See Also

filter_not_like
filter_more
filter_equal

# Related Post

Building reports with data filters using Smart Report Engine