blocks|key|1086462|text|Note.
++where(:user_id+=>+current_user.id,+:notetype+=>+p[:note_type]).
++where("date+>+?",+p[:date]).
++order('date+ASC,+created_at+ASC')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1086463|或者，您也可以将所有内容转换为SQL表示法|unstyled|1086464|Note.
++where("user_id+=+?+AND+notetype+=+?+AND+date+>+?",+current_user.id,+p[:note_type],+p[:date]).
++order('date+ASC,+created_at+ASC')|1086465|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>Note.
 where(:user_id =&gt; current_user.id, :notetype =&gt; p[:note_type]).
 where("date &gt; ?", p[:date]).
 order('date ASC, created_at ASC')
</code></pre>

or you can also convert everything into the SQL notation

<pre><code>Note.
 where("user_id = ? AND notetype = ? AND date &gt; ?", current_user.id, p[:note_type], p[:date]).
 order('date ASC, created_at ASC')
</code></pre>

blocks|key|871762|text|如果遇到列名不明确的问题，可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|871763|date_field+=+Note.arel_table[:date]
Note.where(user_id:+current_user.id,+notetype:+p[:note_type]).
+++++where(date_field.gt(p[:date])).
+++++order(date_field.asc(),+Note.arel_table[:created_at].asc())|code-block|syntax|javascript|871764|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you hit problems where column names are ambiguous, you can do:

<pre><code>date_field = Note.arel_table[:date]
Note.where(user_id: current_user.id, notetype: p[:note_type]).
 where(date_field.gt(p[:date])).
 order(date_field.asc(), Note.arel_table[:created_at].asc())
</code></pre>

blocks|key|871815|text|您可以尝试使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|871816|where(date:+p[:date]..Float::INFINITY)|code-block|syntax|javascript|871817|sql中的等效语句|871818|WHERE+(`date`+>=+p[:date])|871819|结果是：|871820|Note.where(user_id:+current_user.id,+notetype:+p[:note_type],+date:+p[:date]..Float::INFINITY).order(:fecha,+:created_at)|871821|我也变了|871822|order('date+ASC,+created_at+ASC')|871823|为|871824|order(:fecha,+:created_at)|871825|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

You can try to use:

<pre><code>where(date: p[:date]..Float::INFINITY)
</code></pre>

equivalent in sql

<pre><code>WHERE (`date` &gt;= p[:date])
</code></pre>

The result is:

<pre><code>Note.where(user_id: current_user.id, notetype: p[:note_type], date: p[:date]..Float::INFINITY).order(:fecha, :created_at)
</code></pre>

And I have changed too

<pre><code>order('date ASC, created_at ASC')
</code></pre>

For

<pre><code>order(:fecha, :created_at)
</code></pre>

blocks|key|871902|text|如果您不喜欢传入字符串，我更喜欢@sesperanto这样做，但为了使它更简洁，您可以在日期范围内去掉Float::INFINITY，而只需使用created_at:+p[:date]..|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|871903|Note.where(
++++user_id:+current_user.id,
++++notetype:+p[:note_type],
++++created_at:+p[:date]..
).order(:date,+:created_at)|code-block|syntax|javascript|871904|请注意，这将把查询改为>=而不是>。如果需要考虑这一点，您可以通过运行p[:date]+%2B+1.day..之类的命令向日期添加一个时间单位|871905|entityMap^0|1F|F|20|M|0|0|B|2|G|1|Z|I|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|N|$]]

If you aren't a fan of passing in a string, I prefer how @sesperanto has done it, except to make it even more concise, you could drop <code>Float::INFINITY</code> in the date range and instead simply use <code>created_at: p[:date]..</code>
<pre><code>Note.where(
 user_id: current_user.id,
 notetype: p[:note_type],
 created_at: p[:date]..
).order(:date, :created_at)
</code></pre>
Take note that this will change the query to be <code>&gt;=</code> instead of <code>&gt;</code>. If that's a concern, you could always add a unit of time to the date by running something like <code>p[:date] + 1.day..</code>

I have this search in Rails 3:

<pre><code>Note.where(:user_id =&gt; current_user.id, :notetype =&gt; p[:note_type], :date =&gt; p[:date]).order('date ASC, created_at ASC')
</code></pre>

But I need the <code>:date =&gt; p[:date]</code> condition to be equivilent to <code>:date &gt; p[:date]</code>. How can I do this? Thanks for reading.

Can you do greater than comparison on a date in a Rails 3 search?

我在Rails 3中进行了这样的搜索：Note.where(:user_id => current_user.id, :notetype => p[:note_type], :date => p[:date]).order('date ASC, created_at ASC')但我需要与:date > p[:date]...

问你能在Rails 3搜索中对日期做大于比较吗？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问你能在Rails 3搜索中对日期做大于比较吗？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问你能在Rails 3搜索中对日期做大于比较吗？
EN