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"."updated_at" ASCYour first 10 results out of 338 total
| Id | First name | Last name | Created at | Updated at ▲ | Roles | Posts | |
|---|---|---|---|---|---|---|---|
| 226 | Julian | Pagac | julian-pagac@example.com | 24/09/26 01:45 | 24/09/26 02:04 |
admin
|
3
Libero.
Earum.
Ipsam.
|
| 71 | Constance | Kohler | constance-kohler@example.com | 22/09/26 15:37 | 25/09/26 06:28 |
admin
|
3
Repudiandae.
Error.
Laboriosam.
|
| 344 | Chas | Conroy | chas-conroy@example.com | 25/09/26 01:43 | 25/09/26 07:31 |
admin
|
3
Rerum.
Blanditiis.
Sint.
|
| 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
|
| 330 | Ollie | Yundt | ollie-yundt@example.com | 26/09/26 10:52 | 26/09/26 13:58 |
admin
|
3
Accusamus.
Impedit.
Ut.
|
| 14 | Lashonda | Wisoky | lashonda-wisoky@example.com | 26/09/26 06:23 | 26/09/26 15:49 |
admin
|
3
Incidunt.
Natus.
Non.
|
| 332 | Fumiko | Fisher | fumiko-fisher@example.com | 24/09/26 23:16 | 26/09/26 19:32 |
admin
|
3
Impedit.
Beatae.
Reprehenderit.
|
| 276 | Debra | Abernathy | debra-abernathy@example.com | 24/09/26 08:12 | 27/09/26 10:11 |
user
|
0
|
| 95 | Jewel | Bailey | jewel-bailey@example.com | 27/09/26 10:22 | 27/09/26 10:23 |
admin
|
3
Voluptate.
Ut.
Ipsum.
|