EEConf 2024 is around the corner! EEConf 2024
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
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}
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}
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.