UI-ServiceManagementOverview-CustomerContractToRenew
SELECT CustomerContract AS c WHERE c.end_date < DATE_ADD(NOW(), INTERVAL 30 DAY)
|
UI-ServiceManagementOverview-ProviderContractToRenew
SELECT ProviderContract AS c WHERE c.end_date < DATE_ADD(NOW(), INTERVAL 30 DAY)
|