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