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"."first_name" DESC
Your first 10 results out of 338 total
| Id | First name ▼ | Last name | Created at | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 213 | Zoe | West | zoe-west@example.com | 31/10/26 14:59 | 02/11/26 04:29 |
admin
|
3
Quis.
Non.
Quam.
|
| 172 | Zenaida | Toy | zenaida-toy@example.com | 23/10/26 21:45 | 30/10/26 17:46 |
user
|
0
|
| 234 | Zachary | Rau | zachary-rau@example.com | 15/11/26 14:01 | 20/11/26 18:08 |
admin
|
3
Officiis.
Eius.
Vero.
|
| 247 | Yong | Beier | yong-beier@example.com | 11/11/26 07:22 | 14/11/26 10:06 |
admin
|
3
Distinctio.
Ut.
Dolores.
|
| 18 | Yang | Stark | yang-stark@example.com | 15/11/26 19:00 | 17/11/26 15:47 |
admin
|
3
Dolor.
Dolores.
Non.
|
| 16 | Xiomara | Hoeger | xiomara-hoeger@example.com | 21/11/26 10:35 | 27/11/26 14:49 |
admin
|
3
Explicabo.
Animi.
Qui.
|
| 237 | Xavier | Jenkins | xavier-jenkins@example.com | 30/11/26 11:15 | 04/12/26 23:51 |
user
|
0
|
| 136 | Woodrow | Gerlach | woodrow-gerlach@example.com | 17/10/26 03:48 | 20/10/26 08:59 |
admin
|
3
Nisi.
Sequi.
Rem.
|
| 329 | Winfred | Jast | winfred-jast@example.com | 29/10/26 21:54 | 03/11/26 21:07 |
admin
|
3
Sit.
Sapiente.
Qui.
|
| 160 | Wilfredo | Metz | wilfredo-metz@example.com | 07/10/26 14:13 | 14/10/26 12:12 |
admin
|
3
Pariatur.
Dolorem.
Consequatur.
|