How to fix <statement> expected, got 'NOT' warning.

could you please share code block with full query and <<-SQL usage?

This code is used for select `Company` models where that have no `QuickResource` model.

class Company < ApplicationRecord
  has_many :quick_resources
  scope :has_no_quick_resource, -> {
    where(<<-SQL)
      NOT EXISTS (SELECT * FROM quick_resources q WHERE q.company_id = companies.id)
    SQL
  }
end

class QuickResource < ApplicationRecord
  belongs_to :company
end

Looks like a bug. I've created the issue on our tracker, please follow and vote.

Thanks! I've voted up.

A typical if () statement looks like this. Depending on what you are checking for, the else if and else blocks may not be needed. Note how the { }, ( ) and ; are used. If you are searching for an article that can help you with the app development must visit spdload.com.