What is the difference between filterable, queryable and searchable?

[best-cloud]

Hi, I'm new to rails admin.

I don't find the definition of filterable, queryable and searchable in wiki, and I'm confused when implementing searching feature in list view.

Can someone explain what is the three xxxable used for?

Thank you so much.

[airled]

Hi there.

Filterable

Filterable defines fields that can be filtered with the menu in the top right corner.

By default all fields are filterable. But you can disable it by such:

config.model 'Feed' do list do configure :name do filterable false end end end

And now my field is gone:

Queryable

Queryable defines fields, values of which can be searched via this search box:

By default rails_admin searches in id and name fields. So if I type there 345 on my feed model page,

rails_admin hits this sql query:

Feed Load (3.3ms) SELECT "feeds".* FROM "feeds" WHERE ((feeds.id = 345) OR (feeds.name ILIKE '%345%')) ORDER BY feeds.id desc LIMIT $1 OFFSET $2 [["LIMIT", 20], ["OFFSET", 0]] 

If I disable name field as queryable:

config.model 'Feed' do list do configure :name do queryable false end end end

rails_admin searches only in id values:

Feed Load (1.5ms) SELECT "feeds".* FROM "feeds" WHERE ((feeds.id = 345)) ORDER BY feeds.id desc LIMIT $1 OFFSET $2 [["LIMIT", 20], ["OFFSET", 0]] 

Searchable
If I get it right, searchable is just an alias for both queryable and filterable.
So

configure :name do searchable false end

is just an alias for

configure :name do filterable false queryable false end

But searchable also allows you to substitute one field with another or with a group of fields. You can read more here