Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.31 » View Incident Report |
Serious |
Reported By: Roy Lambert [NLH Associates] Reported On: 6/21/2019 For: Version 2.31 Build 6 |
SELECT COALESCE(_Owner,_Code) AS _ACode, IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2018-10-31', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure, 0))), 0) AS "Col_1", IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure, 0))), 0) AS "Col_13" FROM Analysis JOIN Coding ON Analysis._fkCoding = Coding._Code JOIN Transactions ON Transactions._ID = Analysis._fkTransaction WHERE _DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04' GROUP BY _ACode union SELECT 'TOTAL'+_InOut AS _ACode, IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2018-10-31', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure, 0))), 0) AS "Col_1", IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure, 0))), 0) AS "Col_13" FROM Analysis JOIN Transactions ON Transactions._ID = Analysis._fkTransaction WHERE Transactions._DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04' GROUP BY _InOut
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |