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"Your first 10 results out of 364 total
| Id | First name | Last name | Created at | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 387 | Jame | Kub | jame-kub@example.com | 27/10/26 09:55 | 01/11/26 09:19 |
user
|
0
|
| 420 | Jeniffer | Rempel | jeniffer-rempel@example.com | 04/12/26 11:09 | 10/12/26 19:05 |
user
|
0
|
| 389 | Remedios | Towne | remedios-towne@example.com | 26/11/26 01:52 | 29/11/26 18:17 |
user
|
0
|
| 390 | Donovan | Effertz | donovan-effertz@example.com | 20/11/26 11:43 | 26/11/26 22:08 |
admin
|
3
Ex.
Vitae.
Pariatur.
|
| 391 | Ambrose | Boyer | ambrose-boyer@example.com | 15/11/26 16:50 | 21/11/26 05:13 |
admin
|
3
Error.
Nisi.
Neque.
|
| 162 | Rick | Kunze | rick-kunze@example.com | 02/12/26 10:44 | 03/12/26 13:49 |
admin
|
3
Iusto.
Sint.
Nihil.
|
| 164 | Rosendo | Bernhard | rosendo-bernhard@example.com | 02/10/26 15:04 | 06/10/26 00:34 |
admin
|
3
Doloribus.
Repudiandae.
Quia.
|
| 165 | Manuel | Leannon | manuel-leannon@example.com | 28/10/26 15:51 | 30/10/26 21:30 |
admin
|
3
Ut.
Alias.
Sint.
|
| 166 | Landon | Spinka | landon-spinka@example.com | 09/10/26 22:21 | 16/10/26 08:16 |
admin
|
3
Nemo.
Omnis.
Commodi.
|
| 167 | Brianne | Medhurst | brianne-medhurst@example.com | 20/11/26 07:28 | 22/11/26 18:15 |
admin
|
3
Itaque.
Nostrum.
Non.
|