ansaurus

Question

Rails - Searchlogic to search condition as an array of value

Answer 1

A:

Employee.unit_id_equals([1, 2, 3])

PeterWong 2010-09-15 07:33:01

Unfortunately that does not work. I get this error "wrong number of bind variables (2 for 1) in: employees.unit_id IN (?)"

eabhvee 2010-09-15 07:48:21

Could you give more hints about the error message? such as when is the message being generated? I can't get why there were 2 variables......

PeterWong 2010-09-15 08:10:02

In my search view I selected 2 units and passed it as an array, if I select 5 it will say 5 for 1. My params hash is like this --> unit_id_equals"=>["332", "333"]

eabhvee 2010-09-15 08:23:41

BTW, Employee.unit_id_equals([332,333]) works fine in the console

eabhvee 2010-09-15 08:37:58

Yes this should work. Are you sure you are `...equals(["332", "333])` instead of `...equals("332", "333")`? The latter one give the same error message while the former one is correct and worked fine.

PeterWong 2010-09-15 08:49:51

Thanks for the clarification. This is my view code <%= check_box_tag "search[unit_id_equals][]", unit.id %> Is there something wrong here?

eabhvee 2010-09-15 09:20:55

Found the reason. This is an issue in searchlogic Employee.unit_id_equals([1, 2, 3]) works but Employee.search(:unit_id_equals => [1, 2, 3]).all does not work http://github.com/binarylogic/searchlogic/issues/issue/64

eabhvee 2010-09-15 11:37:20

ansaurus

tags:

views:

answers:

Rails - Searchlogic to search condition as an array of value

related questions