I've got a table, 'jobs' with a enum field 'status'. status has the following enum set: enum status: [ :draft, :active, :archived ] using ransack, how do I filter the table for, say, all active...

I'm trying to export a list of Ransack (Railscast) results to a CSV file (Railcast). However, it keeps exporting all of the objects, instead of the results returned by the Ransack search. Can anyon...

Using the 'eq' predicate with a blank value, Ransack will cancel out that predicate. Which is obviously handy to have an "All" option in your select. But what if I want to add an option in my &lt...

I have an app that uses the Ransack gem and I'm converting it from Mysql to Postgres. In an instance where the sort column is from an associated table and the distinct option is set to true, Postg...

How can I implement the equivalent of :name_eq_or_description_cont, which combines _eq and _cont predicates into the same search key, so that I can create a search field in the form as: <%= sea...

I've been wracking my brain over this but can't get it. I feel like the answer is probably obvious. What I'm trying to do is the following: I have an index controller which lists a series of Jobs...

Hi i am using ransack + kalendae_assets gem for searching records in between start date and end date for this i am using ransack PREDICATES by referring https://github.com/ernie/ransack/blob/maste...

I'm using ransack gem for searching in rails application. I need to search an array of email_ids in User table. Referring to this issue at ransacking, I followed the steps and added this to the in...

I was getting this error Controller def index @q = JobSubmission.ransack(search_params[:q]) @job_submissions = @q.result(distinct: true) @job_submissions = @job_submissions.page(params[:page]).p...

A basic questión, but I couldn't find something clear in the project page or the wiki. I have the following code: field = "secre" Position.search( {:description_cont => field, :code_cont => ...

I have a field as json column and i have to search all the phone values inside that column, i have searched for it and i have not found any document using ransack. Is it possible to use ransaack to...

According to Ransack documentation, there is a possibility to pass custom arguments to a ransacker method: class Person < ApplicationRecord ransacker :author_max_title_of_article_where_body_le...

So I put quite a bit of time to write this query, and then found out the hard way that this is returning an array rather than an activerecord relation. DOH. This wouldn't be a problem, but i need t...

Like carvil I have in my model a datetime for created_at although I wanted the "equals" predicate to compare the created_at and a date (like '2012-09-26'). So I added in my model (in order to add ...

How do I make Rails time select to show only the hour part without the minutes? Basically what I want is to show a time filter with start_time and end_time and use Ransack gem to filter the query. ...

I have to perform a search on a database using ransack. A few columns in the database have data stored in serialized arrays. I want to match the exact data stored in the arrays with data sent by us...

I have a HABTM relationship between the Theme and Quote models. The themes index view displays the count of quotes associated with each theme. I'd like to add a Ransack sort_link on that column, so...

Using Railscast and Ransack demo code, I am able to build Advanced Search like this The drop down "all/any" comes from <%= f.combinator_select %> and it works but I need Conditional Groups wi...

I am using advanced search in Ransack which has default AND. I have made it as OR by putting .try(:merge, m: 'or')) @search = Data.search(params[:q].try(:merge, m: 'or')) but I am not able to ge...

I have a boolean attribute (published) in my model book and I wish to filter all books using checkboxes on that value. class Book < ActiveRecord::Base attr_accessible :published end That mea...

I`ve got a model with several taxonomies using acts-as-taggable-on class Film < ActiveRecord::Base attr_accessible :mood_list, :genre_list, :tag_list, :country_list acts_as_taggable_on :count...

I have a recipe model which has_many ingredients and each ingredient belongs to an item. In my advanced search form, I would like a user to select multiple ingredients and let Ransack find a recipe...

I am currently experimenting using the ransack gem to conduct a search on a model in Rails. As it stands I am using the basic setup. Controller: def index @q = Person.search(params[:q]) @people...

I'd like to use ransack (via ActiveAdmin) to do full-text searches on a model. How can I get ransack to use pg_search for its query? I want to run queries that, among other query components, use ...

first time poster. I am trying to sort a table of users using the Ransack gem and Kaminari for pagination. When I use name, id, etc. sorting works but when I try an association with posts_count, so...