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"."created_at" ASCYour first 10 results out of 364 total
| Id | First name | Last name | Created at ▲ | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 201 | Shawn | Lakin | shawn-lakin@example.com | 01/10/26 11:53 | 01/10/26 21:24 |
admin
|
3
Sed.
Nisi.
Error.
|
| 205 | Clyde | Metz | clyde-metz@example.com | 01/10/26 13:19 | 05/10/26 07:12 |
admin
|
3
Eaque.
Et.
Ratione.
|
| 118 | Jeramy | Abernathy | jeramy-abernathy@example.com | 01/10/26 16:27 | 06/10/26 17:40 |
user
|
0
|
| 423 | Evalyn | Casper | evalyn-casper@example.com | 01/10/26 17:29 | 06/10/26 07:51 |
admin
|
3
Vel.
Provident.
Quia.
|
| 335 | Melvin | Howell | melvin-howell@example.com | 01/10/26 18:40 | 08/10/26 09:07 |
user
|
0
|
| 357 | Elvis | Rodriguez | elvis-rodriguez@example.com | 02/10/26 01:45 | 03/10/26 07:46 |
admin
|
3
Molestiae.
Maiores.
Quia.
|
| 63 | Ismael | Labadie | ismael-labadie@example.com | 02/10/26 04:20 | 08/10/26 23:15 |
admin
|
3
Consequatur.
Perspiciatis.
Velit.
|
| 262 | Frank | Kreiger | frank-kreiger@example.com | 02/10/26 12:23 | 08/10/26 21:05 |
user
|
0
|
| 164 | Rosendo | Bernhard | rosendo-bernhard@example.com | 02/10/26 15:04 | 06/10/26 00:34 |
admin
|
3
Doloribus.
Repudiandae.
Quia.
|
| 329 | Winfred | Jast | winfred-jast@example.com | 02/10/26 17:42 | 08/10/26 06:37 |
admin
|
3
Sit.
Sapiente.
Qui.
|