Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Report from history changes
#1
My user created a new filter and move many registry to another user

But this action affected more registry him wish

Is possible I generated a report from history changes to help them solved that ?

I wish now registry with changes assigned to ( xxx ) to another user ( yyy ) when date of changes greater than 12/5/2018 ...
Ranieri
eCRM Web
Reply
#2
If you have ModTracker active on the module, try executing something like this directly in the database:

Code:
SELECT *
FROM `vtiger_modtracker_basic`
INNER JOIN `vtiger_modtracker_detail` on vtiger_modtracker_basic.id=vtiger_modtracker_detail.id
WHERE `changedon` > '2019-01-10 00:00:00' and fieldname='assigned_user_id'
Joe
TSolucio
Reply
#3
Works but only information displayed is CRMID, how I can associate a CRMID a another field allowed user find each registry?

The better if I can associate this CRMID ( at specific case a service contracts, field = Subject ), for example.
Ranieri
eCRM Web
Reply
#4
You can join on any module table with the CRMID, for servicecontracts it would something like this:

SELECT *
FROM `vtiger_modtracker_basic`
INNER JOIN `vtiger_modtracker_detail` on vtiger_modtracker_basic.id=vtiger_modtracker_detail.id
INNER JOIN vtiger_servicecontracts on vtiger_servicecontracts.servicecontractid=vtiger_modtracker_basic.crmid
WHERE `changedon` > '2019-01-10 00:00:00' and fieldname='assigned_user_id';

Let me know how it goes.
Joe
TSolucio
Reply
#5
I can use a SQL report for this right? ( instead a use a directly in DB ) ...
Ranieri
eCRM Web
Reply
#6
almost there ...

I wish translate a number of user to a name of user


Attached Files Image(s)
   
Ranieri
eCRM Web
Reply
#7
Join with the user table on whodid

SELECT *
FROM `vtiger_modtracker_basic`
INNER JOIN `vtiger_modtracker_detail` on vtiger_modtracker_basic.id=vtiger_modtracker_detail.id
INNER JOIN vtiger_servicecontracts on vtiger_servicecontracts.servicecontractid=vtiger_modtracker_basic.crmid
INNER JOIN vtiger_users on vtiger_users.id=vtiger_modtracker_basic.whodid
WHERE `changedon` > '2019-01-10 00:00:00' and fieldname='assigned_user_id';
Joe
TSolucio
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)