This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

  1. Forum
  2. FormTools Support
  3. How to get accurate record count?
jvanremoortere
jvanremoortere

How can we get an accurate record count related to the filter(s)?

Octo
Octo

Use something like this

$query = Db::table('your_table')->where('column', 'value')->count();

More docs at Have a read here https://octobercms.com/docs/database/query#aggregates

jvanremoortere
jvanremoortere

I should have been more clear... I mean in the backend list (with filters)...

list count

Displayed records: 1-20 of 34... So 34

hugo.wijdeveld
hugo.wijdeveld

@jvanremoortere: did you ever find the answer to this one?

1-4 of 4

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.