Smart Report Engine Documentation

filter_more

 
          filter_more(string $table, string $column, mixed $param, bool  $is_or_equal = false, $parameters_type = Constants::SRE_NUMBER)

This filter should be used with a numeric or DateTime column to get the data that is higher than 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

1- The column you are using for any of the filters methods must be a selected column in your report.
2- In case of native projects, constants should be passed directory (i.e SRE_NUMBER), but in case of Laravel project constants should be passed as static members of the constants class (i.e Constants::SRE_NUMBER)

# 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 date.
$is_or_equal	A boolean with false as the default. Set this parameter to true if you want the filter to be "more or equal".
$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_more("items", "date", "2018-01-01",SRE_TEXT);
$engine = new CustomEngine($report);
$report_path = $engine->create_report();

# See Also

filter_equal
filter_between
filter_less
dynamic_filter_not_equal
dynamic_filter_more

# Related Post

Building reports with data filters using Smart Report Engine