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"."created_at" DESC

Your first 10 results out of 364 total

Id First name Last name Email Created at ▼ Updated at Roles Posts
432 Alva Skiles alva-skiles@example.com 09/12/26 15:35 14/12/26 06:11
admin
3 Voluptates. Qui. Qui.
5 Alaina Runolfsdottir alaina-runolfsdottir@example.com 09/12/26 14:47 10/12/26 07:49
admin
3 Expedita. Sit. Alias.
113 Derick Herman derick-herman@example.com 08/12/26 18:02 11/12/26 17:10
admin
3 Harum. Itaque. Itaque.
139 Vince Pfannerstill vince-pfannerstill@example.com 08/12/26 15:17 13/12/26 18:00
admin
3 Sed. Et. Enim.
2 Callie Jenkins callie-jenkins@example.com 08/12/26 15:06 12/12/26 04:47
user
0
341 Eleanore Becker eleanore-becker@example.com 08/12/26 12:11 14/12/26 18:35
admin
3 Vero. Sequi. Exercitationem.
169 Hobert Rogahn hobert-rogahn@example.com 08/12/26 08:42 12/12/26 18:57
admin
3 Non. Corrupti. Ut.
70 Shenika Kohler shenika-kohler@example.com 08/12/26 06:17 12/12/26 09:18
admin
3 In. Doloribus. Sequi.
43 Van Kilback van-kilback@example.com 07/12/26 20:44 13/12/26 11:47
admin
3 Earum. Et. Ab.
65 Henrietta Ratke henrietta-ratke@example.com 07/12/26 18:55 08/12/26 13:21
admin
3 Harum. Enim. Quibusdam.