We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

Is there a SUPER fast way to see all revisions someone has done?

How Do I?

From EE Slack's avatar
From EE Slack
185 posts
about 12 months ago
From EE Slack's avatar From EE Slack

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!

       
dougblackjr's avatar
dougblackjr
34 posts
about 12 months ago
dougblackjr's avatar dougblackjr

With entry revisions enabled (which now I will ALWAYS do), I ran this query to find them:

SELECT entry_id FROM exp_entry_revisions WHERE author_id = X (x being the ID of the user).

Thanks for your help!

       
From EE Slack's avatar
From EE Slack
185 posts
about 12 months ago
From EE Slack's avatar From EE 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}
πŸ‘ 1 πŸš€ 1
       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.