How to filter Audits with auditables not nil?

Question

I am using Audit gem in my Ruby on Rails application. I have auditables like Order, Invoice for my Audits. My orders and Invoice model starts like this:-

 class Order < ApplicationRecord
    audited
    has_associated_audits

Because of has_associated_audits, Audit[i].auditable will give me order/invoice corresponding to ith Audit. Now some of the Orders are deleted afterwards and Audit[i].auditable becomes nil. How do I get only those Audits for which Audit[i].auditable is not nil?

score 1 · Accepted Answer · answered Apr 20 '18 at 21:44

1

Because the Auditable relation is polymorphic, you can't just join the table and be on your way. Instead, you're going to need some raw SQL magic. This is an example using things from my own codebase, adjust to your needs:

Audited::Audit.joins('INNER JOIN titles ON audits.auditable_id = titles.id').where(auditable: nil, auditable_type: 'Title')

That was adapted from this great SO post here: ActiveRecord - querying polymorphic associations

answered Apr 20 '18 at 21:44

Petercopter

1,218
11
16

Thanks, it worked but this way I will have to do inner join on each of Orders, Invoices, Returns. Is there any better way? – Umesh Malhotra Apr 21 '18 at 09:00

How to filter Audits with auditables not nil?

1 Answers1