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" ASCYour first 10 results out of 364 total
| Id ▲ | First name | Last name | Created at | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 1 | Ned | Heller | ned-heller@example.com | 05/10/26 03:02 | 09/10/26 18:17 |
user
|
0
|
| 2 | Callie | Jenkins | callie-jenkins@example.com | 08/12/26 15:06 | 12/12/26 04:47 |
user
|
0
|
| 3 | Serena | Howell | serena-howell@example.com | 28/11/26 16:38 | 05/12/26 14:29 |
user
|
0
|
| 4 | Hank | Kuhlman | hank-kuhlman@example.com | 04/12/26 03:10 | 08/12/26 03:58 |
admin
|
3
Dolores.
Reprehenderit.
Aperiam.
|
| 5 | Alaina | Runolfsdottir | alaina-runolfsdottir@example.com | 09/12/26 14:47 | 10/12/26 07:49 |
admin
|
3
Expedita.
Sit.
Alias.
|
| 6 | Leda | O'Hara | leda-o'hara@example.com | 15/10/26 05:54 | 15/10/26 19:59 |
admin
|
3
Temporibus.
Inventore.
Quas.
|
| 7 | Rosendo | Shanahan | rosendo-shanahan@example.com | 09/11/26 03:46 | 10/11/26 04:45 |
admin
|
3
Unde.
Deleniti.
Ut.
|
| 8 | Sharmaine | O'Connell | sharmaine-o'connell@example.com | 21/11/26 12:59 | 22/11/26 13:14 |
admin
|
3
Eum.
Numquam.
Non.
|
| 9 | Marcel | Dickinson | marcel-dickinson@example.com | 31/10/26 17:54 | 05/11/26 10:00 |
user
|
0
|
| 10 | Olen | Leannon | olen-leannon@example.com | 17/11/26 16:46 | 18/11/26 13:28 |
user
|
0
|