Simple search

A plain search_form_for with predicate-suffixed field names, such as name_cont. Each field's caption names the ransack feature behind it.

SQL

SELECT users.*, (SELECT COUNT(*) FROM posts WHERE posts.user_id = users.id) AS posts_count FROM "users" ORDER BY "users"."last_name" ASC

Your first 10 results out of 364 total

Id First name Last name ▲ Email Created at Updated at Roles Posts
118 Jeramy Abernathy jeramy-abernathy@example.com 01/10/26 16:27 06/10/26 17:40
user
0
276 Debra Abernathy debra-abernathy@example.com 08/10/26 13:43 14/10/26 16:09
user
0
207 Albertine Abshire albertine-abshire@example.com 06/10/26 16:02 06/10/26 21:14
admin
3 Recusandae. Quis. Deleniti.
200 Meaghan Ankunding meaghan-ankunding@example.com 10/10/26 16:48 11/10/26 11:05
admin
3 Nesciunt. Mollitia. Rerum.
297 Charles Ankunding charles-ankunding@example.com 11/10/26 15:05 17/10/26 14:11
admin
3 Repellat. Suscipit. Illo.
175 Emilio Ankunding emilio-ankunding@example.com 04/10/26 02:19 05/10/26 03:51
admin
3 Pariatur. Culpa. Dolorem.
60 Ulrike Auer ulrike-auer@example.com 04/11/26 14:59 06/11/26 20:43
admin
3 Voluptas. Omnis. Blanditiis.
39 Elane Bailey elane-bailey@example.com 25/10/26 04:02 26/10/26 23:30
admin
3 Pariatur. Et. Sint.
203 Darron Bailey darron-bailey@example.com 30/11/26 10:05 02/12/26 10:31
admin
3 Esse. Dicta. Consequatur.
95 Jewel Bailey jewel-bailey@example.com 04/10/26 17:58 08/10/26 16:44
admin
3 Voluptate. Ut. Ipsum.