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 (SELECT COUNT(*) FROM posts WHERE posts.user_id = users.id) ASC
Your first 10 results out of 364 total
| Id | First name | Last name | Created at | Updated at | Roles | Posts ▲ | |
|---|---|---|---|---|---|---|---|
| 131 | Carrol | Wolf | carrol-wolf@example.com | 10/11/26 21:53 | 12/11/26 11:06 |
user
|
0
|
| 198 | Micah | Friesen | micah-friesen@example.com | 27/10/26 21:35 | 03/11/26 04:29 |
user
|
0
|
| 158 | Merrill | Morissette | merrill-morissette@example.com | 09/11/26 19:19 | 15/11/26 13:44 |
user
|
0
|
| 159 | Casey | Orn | casey-orn@example.com | 25/11/26 02:54 | 26/11/26 19:26 |
user
|
0
|
| 389 | Remedios | Towne | remedios-towne@example.com | 26/11/26 01:52 | 29/11/26 18:17 |
user
|
0
|
| 3 | Serena | Howell | serena-howell@example.com | 28/11/26 16:38 | 05/12/26 14:29 |
user
|
0
|
| 420 | Jeniffer | Rempel | jeniffer-rempel@example.com | 04/12/26 11:09 | 10/12/26 19:05 |
user
|
0
|
| 157 | Tyler | Murphy | tyler-murphy@example.com | 04/10/26 00:10 | 05/10/26 09:54 |
user
|
0
|
| 387 | Jame | Kub | jame-kub@example.com | 27/10/26 09:55 | 01/11/26 09:19 |
user
|
0
|
| 105 | Reyes | Lubowitz | reyes-lubowitz@example.com | 07/11/26 11:13 | 13/11/26 01:23 |
user
|
0
|