Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.07 » View Incident Report |
Serious |
Reported By: Roy Lambert Reported On: 1/15/2008 For: Version 1.07 Build 2 |
SELECT _fkProjects, _LastAccess, (IF(_LastAccess IS NOT NULL THEN CAST((CURRENT_TIMESTAMP - _LastAccess)DAY AS INTEGER) ELSE 99999)) AS _LongAgo, P._Name, P._Type, P._fkOrderBook, IF(P._Status = 'L' THEN 'Live' ELSE IF(P._Status = 'D' THEN 'Dead' ELSE IF(P._Status = 'H' THEN 'Hold' ELSE '')))AS _Status, _fkUsers FROM mruProjects JOIN "NLH-Live"."Projects" P ON _fkProjects = P._ID WHERE _fkProjects <> :Schedule ORDER BY _LongAgo
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 |