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

Your first 10 results out of 364 total

Id First name Last name Email ▼ Created at Updated at Roles Posts
213 Zoe West zoe-west@example.com 10/11/26 05:07 16/11/26 15:37
admin
3 Quis. Non. Quam.
172 Zenaida Toy zenaida-toy@example.com 01/12/26 02:47 07/12/26 00:40
user
0
234 Zachary Rau zachary-rau@example.com 20/11/26 04:50 24/11/26 01:02
admin
3 Officiis. Eius. Vero.
247 Yong Beier yong-beier@example.com 01/12/26 21:09 06/12/26 02:39
admin
3 Distinctio. Ut. Dolores.
18 Yang Stark yang-stark@example.com 29/11/26 16:35 05/12/26 21:30
admin
3 Dolor. Dolores. Non.
16 Xiomara Hoeger xiomara-hoeger@example.com 15/10/26 10:23 17/10/26 12:48
admin
3 Explicabo. Animi. Qui.
237 Xavier Jenkins xavier-jenkins@example.com 02/11/26 16:22 04/11/26 10:31
user
0
136 Woodrow Gerlach woodrow-gerlach@example.com 13/11/26 00:56 18/11/26 06:36
admin
3 Nisi. Sequi. Rem.
329 Winfred Jast winfred-jast@example.com 02/10/26 17:42 08/10/26 06:37
admin
3 Sit. Sapiente. Qui.
160 Wilfredo Metz wilfredo-metz@example.com 23/10/26 07:49 30/10/26 04:20
admin
3 Pariatur. Dolorem. Consequatur.