filter_not_null

 
          filter_not_null($table, $column)  
This is one of the filter functions. Applying this function on any column should return records with NO null values in this filtered column.
# This method is available in both the community edition and the commercial edition .

# Note

This filter can be used with any data type.

# 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 any data type.

# 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")
        ->filte_not_null("items", "country");
$engine = new CustomEngine($report);
$report_path = $engine->create_report();
if ($report_path) {
    echo "Report created successfully! Your report URL: $report_path  ";
}