Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.04 » View Incident Report |
Serious |
Reported By: Piotr Front Reported On: 8/24/2010 For: Version 2.04 Build 1 |
SELECT fx.FileId, ax.ApplicationTemplateId, ftx.FileTemplateID, ax.ApplicationID, fdx."Name" fdxName, ftx."Name" ftxName, fdx."Version" fdxVer, ftx."Version" ftxVer, fdx."Description" fdxDescr, ftx."Description" ftxDescr, cdx."Name" cdxName, ftx.Company ftxCompany, fdx.OriginalFileName fdxOFName, ftx.OriginalFileName ftxOFName FROM File fx LEFT JOIN FileDictionary fdx ON (fdx.FileDictionaryId = fx.FileDictionaryId) LEFT JOIN CompanyDictionary cdx ON (fdx.CompanyDictionaryID = cdx.CompanyDictionaryId) INNER JOIN Application ax ON (ax.NodeId = 2 AND ax.ApplicationId = fx.ApplicationId) LEFT JOIN FileTemplate ftx ON ( ftx.TemplateId = ax.ApplicationTemplateId AND ( (ftx."Name"='*' OR (ftx."Name"<>'' AND fdx."Name" LIKE REPLACE('*' WITH '%' IN ftx."Name") )) OR (ftx."Version"='*' OR (ftx."Version"<>'' AND fdx."Version" LIKE REPLACE('*' WITH '%' IN ftx."Version") )) OR (ftx."Description"='*' OR (ftx."Description"<>'' AND fdx."Description" LIKE REPLACE('*' WITH '%' IN ftx."Description") )) OR (ftx.Company='*' OR (ftx.Company<>'' AND cdx."Name" LIKE REPLACE('*' WITH '%' IN ftx.Company) )) OR (ftx.OriginalFileName='*' OR (ftx.OriginalFileName<>'' AND fdx.OriginalFileName LIKE REPLACE('*' WITH '%' IN ftx.OriginalFileName) )) ) ) WHERE fx.NodeId = 2 AND fdx."Name" = 'Uninstall.exe' AND fx.Deleted = false AND ftx.FileTemplateId IS NOT NULL
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 |