Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.18 » View Incident Report |
Serious |
Reported By: Volker Nabholz [gripsware gmbh] Reported On: 4/28/2015 For: Version 2.18 Build 4 |
SELECT PL.*, (select ANF.NameAndFunction from p3md.vw_AddressNameAndFunction ANF where ANF.GUID_ID = PL.ProjectLeader_GUID) AS ProjectLeaderName, (SELECT LIST('P' + RIGHT('0' + CAST(CDD.CEDevice_ID AS VarChar(2)), 2)) AS CEList FROM p3md.CEDevice CDD WHERE CDD.ProjectLeader = PL.ProjectLeader_GUID) AS CE_ID FROM Prj0000001."ProjectLeader" PL WHERE PL.Project_GUID = 'Prj0000001' AND COALESCE(PL.Project_GUID, '') <> '' ORDER BY RowPos
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 |