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 "users"."last_name" DESCYour first 10 results out of 338 total
| Id | First name | Last name ▼ | Created at | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 330 | Ollie | Yundt | ollie-yundt@example.com | 26/09/26 10:52 | 26/09/26 13:58 |
admin
|
3
Accusamus.
Impedit.
Ut.
|
| 230 | Randy | Yost | randy-yost@example.com | 21/10/26 03:52 | 21/10/26 08:14 |
admin
|
3
Hic.
Quibusdam.
Dolores.
|
| 177 | Melvina | Wyman | melvina-wyman@example.com | 15/10/26 11:49 | 16/10/26 23:35 |
admin
|
3
Quisquam.
Est.
Qui.
|
| 279 | Juliane | Wunsch | juliane-wunsch@example.com | 17/11/26 09:32 | 23/11/26 02:33 |
admin
|
3
Numquam.
Quo.
Atque.
|
| 348 | Alec | Wunsch | alec-wunsch@example.com | 08/10/26 05:28 | 12/10/26 00:17 |
user
|
0
|
| 218 | Van | Wunsch | van-wunsch@example.com | 06/10/26 07:18 | 07/10/26 17:31 |
admin
|
3
Neque.
Voluptatum.
Vitae.
|
| 215 | Ila | Wuckert | ila-wuckert@example.com | 27/10/26 04:52 | 28/10/26 01:03 |
admin
|
3
Sint.
Nostrum.
Non.
|
| 131 | Carrol | Wolf | carrol-wolf@example.com | 12/11/26 00:20 | 18/11/26 00:32 |
user
|
0
|
| 38 | Magen | Wiza | magen-wiza@example.com | 12/10/26 01:58 | 15/10/26 12:27 |
admin
|
3
Necessitatibus.
Ratione.
Sint.
|
| 14 | Lashonda | Wisoky | lashonda-wisoky@example.com | 26/09/26 06:23 | 26/09/26 15:49 |
admin
|
3
Incidunt.
Natus.
Non.
|