How to Filter a Subquery in Ransack Without Affecting Performance?

[migueloporto]

Hi,

I am using the Ransack gem to perform filters in my application, and I have a specific issue with a ransacker that uses a subquery. The problem is that Ransack is appending = TRUE to the generated query, which is negatively impacting performance.

Here is the ransacker code that I am using in the Job model:

class Job < ApplicationRecord
  ransacker :period_between, args: [:parent, :ransacker_args] do |parent, args|
    start_date, end_date = args
    Arel::Nodes::In.new(
      parent.table[:id],
      Arel.sql(between(start_date, end_date).select(:id).to_sql),
    )
  end

  scope :between,
        -> (start_date, end_date) {
          where("jobs.start_date >= ? AND jobs.end_date <= ?", start_date, end_date)
        }
end

And here is the JSON I am using to apply the filter:

job_parsed_fq = {
  "g" => {
    "0" => {
      "m" => "and",
      "c" => [{
        "a" => {"0" => {name: "jobs_period_between", ransacker_args: ["2020-08-01", "2024-08-31"]}},
        "p" => "true",
        "v" => ["true"],
      }],
    },
  },
}

When I run the query with Employee.ransack(job_parsed_fq).result.select(:id).to_sql, I get the following SQL:

SELECT "employees"."id"
FROM "employees"
LEFT OUTER JOIN "jobs" ON "jobs"."employee_id" = "employees"."id"
WHERE "jobs"."id" IN
    (SELECT "jobs"."id"
     FROM "jobs"
     WHERE (jobs.start_date >= '2020-08-01'
            AND jobs.end_date <= '2024-08-31')) = TRUE

As you can see, Ransack is appending = TRUE at the end of the subquery, which is causing performance issues.

I have tried various predicates without success. Is there a way to prevent Ransack from adding = TRUE at the end of the subquery? I am looking for a solution that allows me to apply the filter without negatively impacting the query's performance.

Any help or advice would be greatly appreciated.

Thank you!