Need help with SQL query

Atiya_Sultana

Hi,I use the below SQL query for a LiveReport which gives me the files added to Livelink from a local drive on the server:select AuditDate, DataID, Value1 as Location, Value2 as 'Objects Uploaded (File & Folder)', CASE SubType WHEN 0 THEN 'Folder' WHEN 144 THEN 'Document' ELSE 'File with Incorrect MIME Type' END AS ObjectType from dauditnew (nolock) where ((auditdate >= %1) and (auditdate <= %2)) and (auditstr='create' OR auditstr='Addversion') and subtype!=630We drag and drop files from local drive on the server to Livelink folders using Livelink Explorer. Using this LiveReport I can know what all files and folders have been uploaded along with their full location. But when an existing file gets uploaded, a new version is added and in the Value1 column I get the version number (2,7,etc) instead of the path. Whereas for the new files, it gives me the full path of the file or folder.Can anyone please help me in modifying the query so that in Value1 I could see the full path for existing files same as with new files?Many Thanks,Atiya.