Got a function stored in the ProjectWise SQL Server Database. Why does the result of the query differ from the direct SQL Server result if i run the query with the ProjectWise module cmdlet Select-PWSQLDataTable?
My result of the direct query:
And the result of the Select-PWSQLDataTable:
So why is the FilePath field empty if i run the query with Select-PWSQLDataTable?
It seems to be a simple issue i just had to put a CAST on my column for the path (CAST(ref.[Path] AS NVARCHAR(4000)))
Answer Verified By: Christian Jührendt
NVARCHAR(4000) and i thought my users created long paths