Show the author of the last edit of an entry

Thanks for getting in touch about this.

Id take a peek at the {author} tag.

https://docs.expressionengine.com/latest/channels/entries.html#author

Thanks,

-Tom Jaeger

Thanks Tom, I don’t want to show the author of the post I want the author of the most recent edit. I don’t think that tag will work will it?

So something like the Author of the “current” revision?

Yes, I want to show the original author but also the author of the most recent revision

@tom - any help on this one?

Off the top of my head, my gut reaction is that it would be fairly easy to do with the query module (not sure how well you know SQL).

https://docs.expressionengine.com/latest/add-ons/query.html

This is something we would consider adding if you wanted to open an issue on github https://github.com/ExpressionEngine/ExpressionEngine

ok, ya It feels like a nice RFE - I’ll open an issue.

In the meantime I might try the SQL approach

https://github.com/ExpressionEngine/ExpressionEngine/issues/2591

Found this query works pretty well

{exp:query sql="SELECT exp_members.screen_name AS revision_author, exp_entry_versioning.version_date FROM exp_entry_versioning JOIN exp_members ON exp_entry_versioning.author_id=exp_members.member_id WHERE entry_id='{entry_id}' ORDER BY version_date DESC LIMIT 1"}

        <li>Last Edit: {version_date format="%m/%d/%Y"}</li>
        <li>Author: {revision_author}</li>

    {/exp:query}

@tom, not sure how good your SQL is but I’m trying to also pull the avatar url for the revision author, any ideas?

Anyone else able to help with this?

HI Matthew,

I think I saw this one answered in slack.. so I thought I’d drop the answer in here for anyone following along..

{exp:query sql="SELECT exp_members.screen_name AS revision_author, exp_entry_versioning.version_date, exp_members.avatar_filename as avatar FROM exp_entry_versioning JOIN exp_members ON exp_entry_versioning.author_id=exp_members.member_id WHERE entry_id='{entry_id}' ORDER BY version_date DESC LIMIT 1"}
<a href="/avatart-upload-file-path/{avatar}">Avatar</a>
{/exp:query}