ExpressionEngine 2024 Quarter 1 Review Quarter 1 Review
Looking for a way to see all entry revisions by a particular user.
Interested in learning more solutions or want to get to know other EE users? Read more about joining the slack here! Join Our Slack!
As was pointed out in Slack, you can do this with a query, but only if you have entry versioning enabled across all of the relevant channels.
You can try the following query in the Utilities- SQL Query Form:
SELECT * from exp_entry_versioning where author_id = x
Where ‘x’ is the member id you’re interested in.
For something a bit easier to read, you could use the Query module- you may need to install it first.
{exp:query sql="
SELECT * from exp_entry_versioning where author_id = 'x' "}
{author_id} {channel_id} {version_date format="%D, %F %d, %Y - %g:%i:%s"}
{/exp:query}
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.