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"."created_at" DESCYour first 10 results out of 338 total
| Id | First name | Last name | Created at ▼ | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 264 | Marietta | Barrows | marietta-barrows@example.com | 30/11/26 13:35 | 03/12/26 03:32 |
admin
|
3
Quasi.
Odio.
Nobis.
|
| 237 | Xavier | Jenkins | xavier-jenkins@example.com | 30/11/26 11:15 | 04/12/26 23:51 |
user
|
0
|
| 189 | Nadene | Gerlach | nadene-gerlach@example.com | 29/11/26 13:27 | 29/11/26 21:42 |
admin
|
3
Quia.
Velit.
Et.
|
| 140 | Allen | Koss | allen-koss@example.com | 28/11/26 23:32 | 29/11/26 20:01 |
admin
|
3
Ipsam.
Doloremque.
Et.
|
| 298 | Abram | Donnelly | abram-donnelly@example.com | 28/11/26 23:17 | 02/12/26 01:03 |
admin
|
3
Illum.
Et.
Veniam.
|
| 258 | Rupert | Kub | rupert-kub@example.com | 28/11/26 16:40 | 05/12/26 12:25 |
admin
|
3
Qui.
Illum.
In.
|
| 100 | Pok | Hane | pok-hane@example.com | 27/11/26 22:02 | 28/11/26 04:42 |
admin
|
3
Qui.
Eaque.
Harum.
|
| 265 | Marci | Johnson | marci-johnson@example.com | 27/11/26 20:11 | 29/11/26 23:57 |
admin
|
3
Odit.
Doloribus.
Aliquid.
|
| 208 | Sergio | Hane | sergio-hane@example.com | 27/11/26 14:48 | 03/12/26 14:17 |
admin
|
3
Ullam.
Ab.
Culpa.
|
| 333 | Laurine | Miller | laurine-miller@example.com | 26/11/26 23:48 | 30/11/26 01:16 |
admin
|
3
Numquam.
Rerum.
Dolor.
|