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"."updated_at" DESCYour first 10 results out of 338 total
| Id | First name | Last name | Created at | Updated at ▼ | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 258 | Rupert | Kub | rupert-kub@example.com | 28/11/26 16:40 | 05/12/26 12:25 |
admin
|
3
Qui.
Illum.
In.
|
| 237 | Xavier | Jenkins | xavier-jenkins@example.com | 30/11/26 11:15 | 04/12/26 23:51 |
user
|
0
|
| 208 | Sergio | Hane | sergio-hane@example.com | 27/11/26 14:48 | 03/12/26 14:17 |
admin
|
3
Ullam.
Ab.
Culpa.
|
| 264 | Marietta | Barrows | marietta-barrows@example.com | 30/11/26 13:35 | 03/12/26 03:32 |
admin
|
3
Quasi.
Odio.
Nobis.
|
| 298 | Abram | Donnelly | abram-donnelly@example.com | 28/11/26 23:17 | 02/12/26 01:03 |
admin
|
3
Illum.
Et.
Veniam.
|
| 83 | Lavern | Leffler | lavern-leffler@example.com | 26/11/26 12:49 | 01/12/26 20:46 |
admin
|
3
Sint.
Aut.
Non.
|
| 323 | Ralph | Trantow | ralph-trantow@example.com | 26/11/26 00:42 | 01/12/26 04:52 |
user
|
0
|
| 176 | Autumn | Greenfelder | autumn-greenfelder@example.com | 24/11/26 21:57 | 01/12/26 00:32 |
admin
|
3
Sint.
Autem.
Pariatur.
|
| 185 | Lois | Howell | lois-howell@example.com | 26/11/26 04:42 | 30/11/26 21:52 |
user
|
0
|
| 347 | Cheryl | Ebert | cheryl-ebert@example.com | 25/11/26 09:52 | 30/11/26 11:52 |
user
|
0
|