Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.25 » View Incident Report |
Serious |
Reported By: Adam Brett Reported On: 10/25/2016 For: Version 2.24 Build 3 |
Works: SELECT '1. Late Sales' as "Heading", NiceDate(SI.DateWanted) + '<a HREF = ' + COALESCE(CAST(SI.ID AS VARCHAR), '') + '>' + ' FMID:' + COALESCE(CAST(SI.FMID as VARCHAR), '') + ' ' + COALESCE(O.FullName, '-no customer-') + '</a> ' + COALESCE(REPLACE(',' WITH ', ' IN CAST(LIST(DISTINCT ORDERED P.FullName) as VARCHAR(500))), '') as "Content", DateWanted FROM SalesInvoices SI LEFT JOIN Organisations O ON O.ID = SI.CustomerPayingID LEFT JOIN SalesInvoiceItems SII ON SII.SalesInvoicesID = SI.ID LEFT JOIN Products P ON P.ID = SII.ProductsID WHERE StatusID IN (43, 44, 45) AND CAST(DateWanted as Date) BETWEEN Current_Date - INTERVAL '14' DAY AND Current_Date - INTERVAL '1' DAY GROUP BY SI.ID ORDER BY Heading, Content, DateWanted Doesn't work: SELECT '1. Late Sales' as "Heading", NiceDate(SI.DateWanted) + '<a HREF = ' + COALESCE(CAST(SI.ID AS VARCHAR), '') + '>' + ' FMID:' + COALESCE(CAST(SI.FMID as VARCHAR), '') + ' ' + COALESCE(O.FullName, '-no customer-') + '</a> ' + COALESCE(REPLACE(',' WITH ', ' IN CAST(LIST(DISTINCT ORDERED P.FullName) as VARCHAR(500))), '') as "Content" FROM SalesInvoices SI LEFT JOIN Organisations O ON O.ID = SI.CustomerPayingID LEFT JOIN SalesInvoiceItems SII ON SII.SalesInvoicesID = SI.ID LEFT JOIN Products P ON P.ID = SII.ProductsID WHERE StatusID IN (43, 44, 45) AND CAST(DateWanted as Date) BETWEEN Current_Date - INTERVAL '14' DAY AND Current_Date - INTERVAL '1' DAY GROUP BY SI.ID ORDER BY Heading, Content
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 |