dynamic_filter_between

 
          dynamic_filter_between($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 sales report by date range where each end user can define the date range they want to see. And, you can combine many filters in the same report.
This method filters any specific column between two numbers or two dates entered by the end user(s) of the report. Therefore, all you need to specify is just the filtered column and the table containing it. You don't need to specify filter values, this will be done by your end user in a dialogue box before displaying the report.
# This method is exclusive to the commercial edition and is not supported in the community edition .

# Note

This filter can be applied on either numerical, date, time or datetime columns.

# Parameters

Parameter Description
$tableThe table to be filtered.
$columnThe filter-by column (The column by which you want to filter the report). This filter can be used with numeric, date, time, and date-time columns.

# 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_between("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  ";
}