Hi there... I'm just a newbie in CI4 and I'm having a problem in terms of results produced by query builder. Here's the scenario:
My table_1 in postgres has 6763 rows but the query builder produces only 6540 rows....
This is my sample code base on the documentation
$db = \Config\Database::connect();
$builder = $db->table('table_1');
$bus_permit_info2 = $builder->get()->getResult();
dd($bus_permit_info2);
Please help its been almost a week searching for the right answer for this problem.
Thank you in advance....