Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.26 » View Incident Report |
Serious |
Reported By: Michael Bleijerveld Reported On: 10/27/2017 For: Version 2.26 Build 5 |
Query: SELECT * FROM VW_CHECK_COMPLETED_JOBS WHERE NotProcessed is null Underlying view: CREATE VIEW "VW_CHECK_COMPLETED_JOBS" AS SELECT JJ.OrderID, ( SELECT count(orderid) FROM jobtracking JT INNER JOIN jobtrackingdetails JTD ON JTD.orderid=JT.orderid WHERE JTD.status < 2 AND JTD.orderid=JJ.orderid GROUP BY orderid ) AS NotProcessed FROM jobtracking JJ
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 |