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