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