Smart Report Engine | Report Options

dynamic_filter_less

 
           ->dynamic_filter_less($table, $column)

This is one of the dynamic filters supported in the Smart Report Engine to filter your report by parameters entered by your end users. In other words, your end users can change the output of generated reports based on the parameter values they enter before previewing the reports. For example, using this type of filter you can easily create a performance report where each end user can set certain indicators.
This method should be used with a numeric, date, or DateTime column to get all records that are less than the parameter entered by each end user. Please note that you can combine multiple filters for the same report.

# This method is exclusive to the commercial edition and is not supported in the community edition .

# Note

This method can be used with numeric, date, and datetime columns

# Parameters

Parameter	Description
$table	The table to be filtered.
$column	The filter-by column (The column by which you want to filter the report).

# Returns

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

# Code Example

 
           use SRE\Engine\CustomEngine;
use SRE\Engine\ReportOptions;
require_once "sre_bootstrap.php"; //Make sure use the correct relative path to this file.
$report = new ReportOptions(SRE_PUBLIC_REPORT);
$report->select_tables(array("items"))
        ->select_all_fields()
        ->set_grouping("country")       
        ->dynamic_filter_less("items","units_in_stock");
          
$engine = new CustomEngine($report);
$report_path = $engine->create_report();
if ($report_path) {
    echo "Report created successfully! Your report URL: $report_path  ";
}

# See Also

filter_is_today
dynamic_filter_equal
dynamic_filter_between