Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Report from history changes
#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


Messages In This Thread
Report from history changes - rslemer - 01-11-2019, 02:16 PM
RE: Report from history changes - rslemer - 01-14-2019, 10:33 AM
RE: Report from history changes - joebordes - 01-14-2019, 10:50 PM
RE: Report from history changes - rslemer - 01-15-2019, 05:42 PM
RE: Report from history changes - rslemer - 01-16-2019, 01:01 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)