Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported 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 Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |