an advice for search.

rubyonrails-talk
1

I have a Shop model with some attributes:

role_number :integer(10) role_date :date name :string(255) ssn :string(255) nationality :string(255) address :string(255) number :string(255) website :string(255) district :integer(10) sector :string(255) square_meters :integer(131089) duaap :integer(10) description :string(255) state :string(255) notes :text

I want to create a form for searching on one field or on two fields or on three fields...............or on all fields. There is a gem that facilitate this work? I'm thinking about meta_search, what do you think about?

2

I use searchlogic. This gem is very easy. Look this page ‘https://github.com/binarylogic/searchlogic’

3

I have a Shop model with some attributes:

role_number :integer(10)

role_date :date

name :string(255)

ssn :string(255)

nationality :string(255)

address :string(255)

number :string(255)

website :string(255)

district :integer(10)

sector :string(255)

square_meters :integer(131089)

duaap :integer(10)

description :string(255)

state :string(255)

notes :text

I want to create a form for searching on one field or on two fields or

on three fields…or on all fields.

There is a gem that facilitate this work?

I’m thinking about meta_search, what do you think about?

I just used MetaSearch for the first time last month and love it. I found it very easy to work with and quite powerful.

4

What solution do you adopt? A form with all fields in it?

5

I have a Shop model with some attributes:

role_number :integer(10)

role_date :date

name :string(255)

ssn :string(255)

nationality :string(255)

address :string(255)

number :string(255)

website :string(255)

district :integer(10)

sector :string(255)

square_meters :integer(131089)

duaap :integer(10)

description :string(255)

state :string(255)

notes :text

I want to create a form for searching on one field or on two fields or

on three fields…or on all fields.

There is a gem that facilitate this work?

I’m thinking about meta_search, what do you think about?

I just used MetaSearch for the first time last month and love it. I found it

very easy to work with and quite powerful.

What solution do you adopt?

A form with all fields in it?

If you use MetaSearch, it helps you build your form – see the readme: https://github.com/ernie/meta_search

Now, the app I was working on was more complicated so I did actually create a class so that I could use form builder on my own, and then wrap metasearch behind that. The form consisted of a number of filters. But even if I went straight to metasearch, yes, I would use a form with the fields I want to search which may or may not map to the actual fields I am searching.

6

In this asciicast http://asciicasts.com/episodes/251-metawhere-metasearch is said that searchlogic doesn't work with rails 3.

7

If I want to search base on values on all fields I must create a long form. I've found http://www.2dconcept.com/jquery-grid-rails-plugin it seems nice, what do you think about?

8

Sorry, i went at my gemfile and i saw what i use for search is meta_search. Execuse me.

9

I'm trying meta_search now. :slight_smile:

10

+1 for meta_search, I <3 that thing

11

Also, and I should have said this before, I noticed that in your property list it looks like you're storing social security numbers (SSN). I just want to add a friendly word of advice - encrypt them if you can. I can see a lot of havoc happening if some hacker got his hands on a list of unencrypted (or weakly encrypted) SSN's, both from the standpoint of the person who's identity might be stolen, and for your organization, who may end up fielding a LOT of lawsuits as a result if something like that happens.

Here's a link to one approach that I've used myself before, and I thought it worked rather well: http://stuff-things.net/2007/06/11/encrypting-sensitive-data-with-ruby-on-rails/

Good luck!

12

+1 for meta_search, I <3 that thing

You know I almost cried the first time I used meta_search… in the past I have written my own searches

13

Thank you very much for your important advice.

14

Hi, I also using meta search I have one question how to use meta search for more than two fields ? and if the fields has different data type …will it work?

@David kahn Could u please give some direction how u create a class and used meta search in behind

Please share code to do this if possible.

Regards, Shyam

15

You can do:

    <%= f.text_field :field1_or_field2_equals %>

Needless to say, if you get to the point where you're doing something like...

    <%= f.text_field :field1_or_field2_or_field3_or_field4_or_field5_equals %>

...then you really don't want to be using something like MetaSearch -- you want to go with a fulltext search gem like Thinknig Sphinx.