usershistory

 this is that query:

select u.username, uh.changelog as attribute_change, uh.updatedate as update_timestamp, uh.updatedby from usershistory uh join users u on uh.userkey = u.userkey where uh.updatedate > now() - interval 7 day order by uh.updatedate desc;

 

1. select u.username, uh.changelog as attribute_change, uh.updatedate as update_timestamp, uh.updatedby from usershistory uh join users u on uh.userkey = u.userkey where uh.updatedate > now() - interval 7 day order by uh.updatedate desc;

2. Further customized query, here's how maybe you can filter the logic:

select u.username, uh.changelog as attribute_change, uh.updatedate as update_timestamp, uh.updatedby, case when uh.changelog like '%customer%' then 'trigger first call' else 'trigger second call' end as update_action from usershistory uh join users u on uh.userkey = u.userkey where uh.updatedate > now() - interval 7 day order by uh.updatedate desc;