Advanced search
Conditions are built from the form builder's attribute_select,
predicate_select and
combinator_select, and groups can be nested.
Attributes with a known set of values, such as a role or tag name, get a select instead of a text field.
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) DESCYour first 10 results out of 338 total
| Id | First name | Last name | Created at | Updated at | Roles | Posts ▼ | |
|---|---|---|---|---|---|---|---|
| 162 | Rick | Kunze | rick-kunze@example.com | 16/10/26 10:17 | 21/10/26 01:16 |
admin
|
3
Iusto.
Sint.
Nihil.
|
| 164 | Rosendo | Bernhard | rosendo-bernhard@example.com | 25/09/26 10:44 | 29/09/26 11:09 |
admin
|
3
Doloribus.
Repudiandae.
Quia.
|
| 165 | Manuel | Leannon | manuel-leannon@example.com | 21/10/26 06:10 | 23/10/26 10:27 |
admin
|
3
Ut.
Alias.
Sint.
|
| 166 | Landon | Spinka | landon-spinka@example.com | 03/11/26 00:25 | 03/11/26 01:19 |
admin
|
3
Nemo.
Omnis.
Commodi.
|
| 167 | Brianne | Medhurst | brianne-medhurst@example.com | 01/11/26 11:59 | 06/11/26 13:07 |
admin
|
3
Itaque.
Nostrum.
Non.
|
| 148 | Stephnie | Monahan | stephnie-monahan@example.com | 25/11/26 15:03 | 25/11/26 15:19 |
admin
|
3
Aut.
Assumenda.
Blanditiis.
|
| 149 | Sulema | Bernier | sulema-bernier@example.com | 01/10/26 22:17 | 06/10/26 03:28 |
admin
|
3
Quas.
Id.
Sunt.
|
| 69 | Christiane | Hauck | christiane-hauck@example.com | 27/10/26 12:26 | 02/11/26 19:40 |
admin
|
3
Excepturi.
Cum.
Non.
|
| 163 | Jody | Cremin | jody-cremin@example.com | 28/09/26 18:28 | 05/10/26 02:03 |
admin
|
3
Voluptatem.
Quia.
Illum.
|
| 161 | Chantay | Cruickshank | chantay-cruickshank@example.com | 17/10/26 13:19 | 18/10/26 21:12 |
admin
|
3
Quam.
Eos.
Et.
|