like Operator in ahoy events

Question

I started code rails recently and I need to figure out this problem.

%td
  = Ahoy::Event.where(name: "viewed_brochure").where_properties(brochure_id: brochure.id, time: like 'Mon%').count

this should be show the number of Mondays in database. But it doesn't work and give syntax error.

I wonder how to use like operator in this line.

Ahoy::Event.where(time: "2017-10-30 14:50:35.361999").where_properties(brochure_id: brochure.id).count

This line works fine but i need to use like operator or something similar.

But 'time' is a datetime type.. what would you achieve comparing it with string 'Mon%'? — Anton, Nov 07 '17 at 08:08
I need to determine this datetime data convert to day of week. — Emre, Nov 07 '17 at 08:11

score 0 · Answer 1 · answered Nov 07 '17 at 08:42

0

You can try to use built in postgres function for that:

Ahoy::Event.where("EXTRACT(DOW FROM time) = 1").where_properties(brochure_id: brochure.id).count

answered Nov 07 '17 at 08:42

Nikita Misharin

score 0 · Accepted Answer · answered Nov 07 '17 at 08:43

0

 Ahoy::Event.where("date_part('dow', time) = 1").count

This will return the count of all events created at Monday.You can add more filters.

answered Nov 07 '17 at 08:43

Anton

2 Answers2