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" ASCYour first 10 results out of 338 total
| Id | First name | Last name ▲ | Created at | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 118 | Jeramy | Abernathy | jeramy-abernathy@example.com | 07/10/26 15:14 | 12/10/26 07:20 |
user
|
0
|
| 276 | Debra | Abernathy | debra-abernathy@example.com | 24/09/26 08:12 | 27/09/26 10:11 |
user
|
0
|
| 207 | Albertine | Abshire | albertine-abshire@example.com | 21/10/26 06:44 | 21/10/26 19:54 |
admin
|
3
Recusandae.
Quis.
Deleniti.
|
| 297 | Charles | Ankunding | charles-ankunding@example.com | 25/10/26 03:14 | 25/10/26 10:17 |
admin
|
3
Repellat.
Suscipit.
Illo.
|
| 200 | Meaghan | Ankunding | meaghan-ankunding@example.com | 06/10/26 12:12 | 09/10/26 02:53 |
admin
|
3
Nesciunt.
Mollitia.
Rerum.
|
| 175 | Emilio | Ankunding | emilio-ankunding@example.com | 09/11/26 14:43 | 13/11/26 22:47 |
admin
|
3
Pariatur.
Culpa.
Dolorem.
|
| 60 | Ulrike | Auer | ulrike-auer@example.com | 05/11/26 13:09 | 05/11/26 16:26 |
admin
|
3
Voluptas.
Omnis.
Blanditiis.
|
| 95 | Jewel | Bailey | jewel-bailey@example.com | 27/09/26 10:22 | 27/09/26 10:23 |
admin
|
3
Voluptate.
Ut.
Ipsum.
|
| 203 | Darron | Bailey | darron-bailey@example.com | 24/09/26 08:57 | 28/09/26 11:30 |
admin
|
3
Esse.
Dicta.
Consequatur.
|
| 39 | Elane | Bailey | elane-bailey@example.com | 26/10/26 06:57 | 27/10/26 00:01 |
admin
|
3
Pariatur.
Et.
Sint.
|