MongoID Like query on embedded model

Question

I have User model embeds_one :profile and Profile model has name. I need to run LIKE query on profile name. I tried below as suggested here

User.where("profile.name" => "/.*Senthil.*/")

But above solution not working. I tried lot of stock overflow answers , but no luck. Any help will be highly appreciated.

Screenshot : I am very sure , there is matching record.

enter image description here

Sharvy Ahmed · Accepted Answer · 2015-03-11T20:32:48.363

6

This finds all people with the name senthil (first OR last).

User.where("profile.name" => /.*senthil.*/i )

Here i used to make the query case insensitive.

edited Mar 11 '15 at 20:32

answered Mar 11 '15 at 20:26

Sharvy Ahmed

this is not equivalent to what he's trying to do because it matches any case. – jtmarmon Mar 11 '15 at 20:30
Yes it is, since person name checking should always be case insensitive. – Sharvy Ahmed Mar 11 '15 at 20:38
how to embed verifiable in it... ? – Tushar Niras Dec 05 '17 at 07:21

jtmarmon · Answer 2 · 2015-03-11T20:30:57.773

1

I think you mean to remove the quotes, otherwise the engine will try to match the string exactly, instead of as regex

edit: The correct regexp would be

User.where("profile.name" => /.*Senthil.*/)

edited Mar 11 '15 at 20:30

answered Mar 11 '15 at 20:19

jtmarmon

2 Answers2