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.
|