Simple search

A plain search_form_for with predicate-suffixed field names, such as name_cont. Each field's caption names the ransack feature behind it.

User

Name contains

ransack_alias :name, :first_name_or_last_name

Email contains

Roles

roles_name_in searches through the roles association

Created from

created_at_gteq

Created to

custom predicate lteq_end_of_day, see config/initializers/ransack.rb

User's posts

Post Title contains

Another Post Title contains

SQL

SELECT users.*, (SELECT COUNT(*) FROM posts WHERE posts.user_id = users.id) AS posts_count FROM "users" ORDER BY "users"."email" ASC

Id	First name	Last name	Email ▲	Created at	Updated at	Roles	Posts
298	Abram	Donnelly	abram-donnelly@example.com	28/11/26 23:17	02/12/26 01:03	admin	3 Illum. Et. Veniam.
41	Abram	Kulas	abram-kulas@example.com	30/09/26 19:47	04/10/26 02:30	user	0
5	Alaina	Runolfsdottir	alaina-runolfsdottir@example.com	11/10/26 00:29	17/10/26 20:07	admin	3 Expedita. Sit. Alias.
207	Albertine	Abshire	albertine-abshire@example.com	21/10/26 06:44	21/10/26 19:54	admin	3 Recusandae. Quis. Deleniti.
358	Alberto	Mann	alberto-mann@example.com	10/11/26 06:59	12/11/26 11:04	admin	3 Aspernatur. Iusto. Ad.
348	Alec	Wunsch	alec-wunsch@example.com	08/10/26 05:28	12/10/26 00:17	user	0
212	Alexandra	McClure	alexandra-mcclure@example.com	20/10/26 23:04	25/10/26 22:00	admin	3 Occaecati. Hic. Velit.
92	Alfredo	Kuhlman	alfredo-kuhlman@example.com	11/10/26 02:38	16/10/26 22:23	user	0
269	Alfredo	Schneider	alfredo-schneider@example.com	11/11/26 08:35	11/11/26 23:56	admin	3 Aspernatur. Ab. Sit.
289	Allen	Cronin	allen-cronin@example.com	03/10/26 20:06	04/10/26 09:45	user	0