MONGOOSE find a document using a string (LIKE %SQL)

Question

I want to find a document using the date field contained in the collection

//Document Exemple: MODEL : MY_EVENT

event_time_produce: '2018-01-03T11:00:00.201Z',
event_name : 'show'

I would like to find all the documents starting with '2018-01-03T11:00:'

I want to ignore the part of Millesecobde & ISOtype ..etc

Like in SQL :

SELECT * from MY_EVENT where event_time_produce LIKE '2018-01-03T11:00:%'

I have tried this but not working ( Mongoose)

MY_EVENT.find({event_time_produce : {
                        $regex: new RegExp('^2018-01-03T11:00:00.*$')
                    }})
         .exec(....)

Simple search work :

MY_EVENT.find({event_time_produce : '2018-01-03T11:00:00.201Z'})
         .exec(....)

but I want to get all the documents from 03 Janury 2018 at 11:00:XX

no matter the second just verify the date, hours & minute.

Possible duplicate of [Mongoose.js: Find user by username LIKE value](https://stackoverflow.com/questions/9824010/mongoose-js-find-user-by-username-like-value) — s7vr, Jan 04 '18 at 15:54
I have seen this post but not working for me ! may bee the date & time ? — Anis Mokeddes, Jan 04 '18 at 16:00
No, it shouldn't matter. Are you sure you have the dates stored as string in mongodb ? — s7vr, Jan 04 '18 at 16:05
that is your problem right there. Change them to strings for regex to work. — s7vr, Jan 04 '18 at 16:11
ISODate("2018-01-03T11:00:00.201Z") is the format in MONGOdb ! — Anis Mokeddes, Jan 04 '18 at 16:15
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/162531/discussion-between-anis-mokeddes-and-veeram). — Anis Mokeddes, Jan 04 '18 at 16:19

Rogelio Tonatihu Rodriguez Rod · Accepted Answer · 2018-01-04T16:41:20.237

2

Isn't it an issue on your regular expression?

On your example for SQL you have 2018-01-03T11:00:% When on mongo you got ^2018-01-03T11:00:00.*$ (2 additional zeros after 11:00:)

Update: If your data on the actual document is ISODate instead of a regular string, better to use ranges like this: {event_time_produce:{$gte:ISODate("2018-01-03T11:00:00.000+0000"),$lte:ISODate("2018-01-03T11:00:59.999+0000") }}

edited Jan 04 '18 at 16:41

answered Jan 04 '18 at 16:32

Rogelio Tonatihu Rodriguez Rod

116
1
8

i searchc a function in Mongoose Like DATEPART() function in SQL ! – Anis Mokeddes Jan 04 '18 at 16:37
SELECT * FROM record WHERE (DATEPART(yy, register_date) = 2009 AND DATEPART(mm, register_date) = 10 AND DATEPART(dd, register_date) = 10) – Anis Mokeddes Jan 04 '18 at 16:38
how about using a range on the date? (updated my answer to reflect that) – Rogelio Tonatihu Rodriguez Rod Jan 04 '18 at 16:43

MONGOOSE find a document using a string (LIKE %SQL)

1 Answers1