searching created_at

[elberon5]

I have a search form mostly working with searchlogic. I'm running into
a problem with the created_at field. I want to be able to search
created_at_greater_than_or_equal_to but it does not seem to be
working. The results will show records created before the dates i am
entering in the form.

<%= f.text_field :created_at_greater_than_or_equal_to %>

[Ben Johnson]

Did you check your logs to see the query?

Also you might try

created_at_gte

Its the same thing, just shorter.

Ben Johnson
Binary Logic

W: www.binarylogic.com
E: bjoh...@binarylogic.com

> --
> You received this message because you are subscribed to the Google Groups "Searchlogic" group.
> To post to this group, send email to searc...@googlegroups.com.
> To unsubscribe from this group, send email to searchlogic...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/searchlogic?hl=en.
>
>

[elberon5]

The queries in the log looked fine.When running these generated
queries against sqlite3 they failed to return the correct data. Using
lte or gte on the same date field in sqlite3 failed to return the
correct results as well.

Switching to postgresql resolved the problem. sqlite3 seems to be
broken.

On Jan 28, 8:34 pm, Ben Johnson <bjohn...@binarylogic.com> wrote:
> Did you check your logs to see the query?
>
> Also you might try
>
> created_at_gte
>
> Its the same thing, just shorter.
>
> Ben Johnson
> Binary Logic
>
> W:www.binarylogic.com

> E: bjohn...@binarylogic.com