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"

Id	First name	Last name	Email	Created at	Updated at	Roles	Posts
387	Jame	Kub	jame-kub@example.com	06/10/26 22:05	11/10/26 06:46	user	0
389	Remedios	Towne	remedios-towne@example.com	10/10/26 21:43	17/10/26 07:19	user	0
390	Donovan	Effertz	donovan-effertz@example.com	26/11/26 05:29	27/11/26 04:11	admin	3 Ex. Vitae. Pariatur.
391	Ambrose	Boyer	ambrose-boyer@example.com	27/09/26 23:41	28/09/26 14:19	admin	3 Error. Nisi. Neque.
162	Rick	Kunze	rick-kunze@example.com	11/10/26 08:32	12/10/26 15:39	admin	3 Iusto. Sint. Nihil.
164	Rosendo	Bernhard	rosendo-bernhard@example.com	04/11/26 11:22	10/11/26 15:01	admin	3 Doloribus. Repudiandae. Quia.
165	Manuel	Leannon	manuel-leannon@example.com	14/11/26 08:49	14/11/26 12:43	admin	3 Ut. Alias. Sint.
166	Landon	Spinka	landon-spinka@example.com	30/09/26 11:17	03/10/26 05:31	admin	3 Nemo. Omnis. Commodi.
167	Brianne	Medhurst	brianne-medhurst@example.com	18/11/26 07:15	18/11/26 21:32	admin	3 Itaque. Nostrum. Non.
148	Stephnie	Monahan	stephnie-monahan@example.com	26/10/26 10:40	27/10/26 01:24	admin	3 Aut. Assumenda. Blanditiis.