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	16/11/26 16:19	19/11/26 17:28	admin	3 Illum. Et. Veniam.
41	Abram	Kulas	abram-kulas@example.com	04/12/26 02:27	07/12/26 19:31	user	0
5	Alaina	Runolfsdottir	alaina-runolfsdottir@example.com	09/12/26 14:47	10/12/26 07:49	admin	3 Expedita. Sit. Alias.
207	Albertine	Abshire	albertine-abshire@example.com	06/10/26 16:02	06/10/26 21:14	admin	3 Recusandae. Quis. Deleniti.
358	Alberto	Mann	alberto-mann@example.com	30/11/26 21:42	03/12/26 14:43	admin	3 Aspernatur. Iusto. Ad.
348	Alec	Wunsch	alec-wunsch@example.com	14/10/26 12:45	19/10/26 21:40	user	0
212	Alexandra	McClure	alexandra-mcclure@example.com	10/11/26 16:06	12/11/26 11:27	admin	3 Occaecati. Hic. Velit.
429	Alfredia	Muller	alfredia-muller@example.com	13/10/26 19:42	18/10/26 23:26	admin	3 Voluptate. Aliquid. Vero.
92	Alfredo	Kuhlman	alfredo-kuhlman@example.com	11/10/26 22:23	16/10/26 23:02	user	0
269	Alfredo	Schneider	alfredo-schneider@example.com	13/10/26 08:55	13/10/26 17:03	admin	3 Aspernatur. Ab. Sit.