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 338 total
| Id | First name | Last name | Created at ▲ | Updated at | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 147 | Oscar | Koepp | oscar-koepp@example.com | 22/09/26 13:10 | 25/09/26 18:08 |
admin
|
3
Illum.
Et.
Ut.
|
| 349 | Herb | Jaskolski | herb-jaskolski@example.com | 22/09/26 14:36 | 26/09/26 03:28 |
user
|
0
|
| 71 | Constance | Kohler | constance-kohler@example.com | 22/09/26 15:37 | 25/09/26 06:28 |
admin
|
3
Repudiandae.
Error.
Laboriosam.
|
| 125 | Trevor | Hahn | trevor-hahn@example.com | 23/09/26 00:06 | 28/09/26 21:16 |
admin
|
3
Voluptatem.
In.
Eos.
|
| 126 | Angelo | Stehr | angelo-stehr@example.com | 23/09/26 10:34 | 27/09/26 22:29 |
admin
|
3
Doloribus.
Et.
Ratione.
|
| 114 | Fredric | Farrell | fredric-farrell@example.com | 23/09/26 23:17 | 29/09/26 20:12 |
admin
|
3
Officia.
Aut.
Laboriosam.
|
| 226 | Julian | Pagac | julian-pagac@example.com | 24/09/26 01:45 | 24/09/26 02:04 |
admin
|
3
Libero.
Earum.
Ipsam.
|
| 339 | Santana | Schmidt | santana-schmidt@example.com | 24/09/26 01:57 | 30/09/26 12:34 |
admin
|
3
Sequi.
Et.
Voluptatum.
|
| 276 | Debra | Abernathy | debra-abernathy@example.com | 24/09/26 08:12 | 27/09/26 10:11 |
user
|
0
|
| 203 | Darron | Bailey | darron-bailey@example.com | 24/09/26 08:57 | 28/09/26 11:30 |
admin
|
3
Esse.
Dicta.
Consequatur.
|