Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
Reported By: Piotr Font Reported On: 2/5/2010 For: Version 2.03 Build 8 |
SELECT File.FileID, PathDictionary."Path", FileDictionary."Name", CompanyDictionary."Name" Company FROM File INNER JOIN PathDictionary ON File.PathDictionaryID = PathDictionary.PathDictionaryID INNER JOIN FileDictionary ON File.FileDictionaryID = FileDictionary.FileDictionaryID LEFT JOIN CompanyDictionary ON FileDictionary.CompanyDictionaryID = CompanyDictionary.CompanyDictionaryID WHERE ( NodeId=1 ) AND (File.Deleted = false) AND (File.UserActivity = false) ORDER BY FileDictionary."Name"
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 |