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"."id" DESCYour first 10 results out of 351 total
| Id ▼ | First name | Last name | Created at | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 399 | Annalisa | McCullough | annalisa-mccullough@example.com | 28/10/26 03:04 | 28/10/26 16:44 |
admin
|
3
Omnis.
Est.
Sint.
|
| 398 | Deandrea | Goodwin | deandrea-goodwin@example.com | 16/11/26 14:51 | 22/11/26 02:03 |
admin
|
3
Eveniet.
Quod.
Distinctio.
|
| 397 | Donnetta | Frami | donnetta-frami@example.com | 06/10/26 10:59 | 09/10/26 09:19 |
admin
|
3
Maxime.
Modi.
Nihil.
|
| 396 | Ken | Thompson | ken-thompson@example.com | 03/12/26 15:49 | 08/12/26 07:44 |
admin
|
3
Deserunt.
Recusandae.
Culpa.
|
| 395 | Beatrice | Kassulke | beatrice-kassulke@example.com | 08/10/26 22:58 | 14/10/26 16:57 |
admin
|
3
Quam.
Totam.
Quasi.
|
| 394 | Percy | Kuhic | percy-kuhic@example.com | 02/10/26 17:32 | 03/10/26 06:54 |
admin
|
3
Et.
Deleniti.
Repellat.
|
| 393 | Miki | Bayer | miki-bayer@example.com | 04/10/26 20:31 | 09/10/26 13:48 |
admin
|
3
Laudantium.
Distinctio.
Dolorem.
|
| 392 | Dewayne | Bosco | dewayne-bosco@example.com | 25/09/26 20:42 | 01/10/26 20:52 |
admin
|
3
Consequatur.
Occaecati.
Rerum.
|
| 391 | Ambrose | Boyer | ambrose-boyer@example.com | 27/09/26 23:41 | 28/09/26 14:19 |
admin
|
3
Error.
Nisi.
Neque.
|
| 390 | Donovan | Effertz | donovan-effertz@example.com | 26/11/26 05:29 | 27/11/26 04:11 |
admin
|
3
Ex.
Vitae.
Pariatur.
|