Find version where specific attribute has changed in papertrail

Question

I'm using the Papertrail gem in my project and have searched extensively to try and find how to do the following.

What I'd like to do is find the version of my object where a specific attribute came to be a specific value i.e.

object.versions.where(attribute: "value")

Does anyone know if this is even possible with Papertrail?

deprecated · Answer 1 · 2015-01-14T10:33:35.967

11

The following gets all the versions where attribute became value (which in most apps is probably around 1):

object.versions.
       map(&:object_changes).
       map{|a| YAML::load a}.
       select{|a| (a[:attribute] || [])[1]=='value'}

Result would be something like:

[{"attribute"=>[nil, "value"],
  "updated_at"=>[2015-01-02 12:20:36 UTC, 2015-01-02 12:20:56 UTC]}]

The updated_at[1] value indicates when attribute became value.

Getting the id of the Version can be built upon the provided code snippet.

edited Jan 14 '15 at 10:33

answered Jan 02 '15 at 17:51

deprecated

5,142
3
41
62

Thanks, this does answer my original question. Though for speed of processing (i.e. database queries etc.) my original approach remains my favoured one. – Betjamin Richards Jan 03 '15 at 08:31

score 6 · Answer 2 · edited Jun 04 '19 at 09:14

6

Well, I've concluded this is not possible out-of-the-box in paper_trail.

What I ended up doing was, when one of the specific attributes was updated, save a flag in a separate metadata column in the Versions table.

Then I can search against these columns in the future to find out when that specific attribute changed.

Hopefully this helps someone else.

edited Jun 04 '19 at 09:14

Martin Bjeldbak Madsen

170
3
7

answered Jun 13 '14 at 08:28

Betjamin Richards

1,071
2
12
34

score 5 · Answer 3 · answered Jan 29 '18 at 13:20

Here's another option for those who don't want to use a separate metadata column:

def version_where_attribute_changed_to(attribute_name, attribute_value)
  versions.select do |version|
    object_changes = YAML.load version.object_changes
    (object_changes[attribute_name.to_s] || [])[1] == attribute_value
  end
end

score 1 · Accepted Answer · answered Apr 22 '22 at 12:49

1

As of PaperTrail 12.1 you can do

object.versions.where_object_changes_to(attribute: "value")

answered Apr 22 '22 at 12:49

Maxim Krizhanovsky

26,265
5
59
89

score 0 · Answer 5 · answered Jul 30 '23 at 04:53

0

If you are looking for versions where a specified attribute changed to or from any value, you can use the below:

@object.versions
  .map(&:changeset)
  .select{|a| a["attribute"].present?}

answered Jul 30 '23 at 04:53

Jeremy Lynch

6,780
3
52
63

Find version where specific attribute has changed in papertrail

5 Answers5