ActiveStorage: select all record with an attachment

[MittchoBaroco]

Is there a way via a scope to only select all records with an attachment?

System configuration

Rails version: 5.2.0.rc1

Ruby version: 2.5

[georgeclaghorn]

Join against the attachment association:

# Assuming a model defined like so:
class Post < ApplicationRecord
  has_one_attached :image
end

# ...you can join against :image_attachment to select posts having attached images:
Post.joins(:image_attachment).where('published_at >= ?', Time.now)

In the future, please ask usage questions on the rubyonrails-talk mailing list or on Stack Overflow. We reserve the issue tracker for bugs.

[MittchoBaroco]

Thank you very much, sorry

[lucascaton]

In case anyone is looking for a way to join against the active_storage_blobs table, this can be achieved by with the *_blob (like image_blob) association.

Here's an example that sum how many bytes are used by the attachments:

Post.joins(:image_blob).sum("active_storage_blobs.byte_size")