SQL statements that will be used to retrieve data for the grid have to be placed in the DBC class in hidden/inc/classes/user/user_dbc.class.php.
public static function get_sql_for_grid() {
$sql = "select id, username from users order by username asc";
return $sql;
}
public static function get_sql_count_for_grid() {
$sql = "select count(id) as total_rows from users";
return $sql;
}
Note:
get_sql_for_grid()andget_sql_count_for_grid()are "standard" names for methods that prepare SQL for usage by grid.