PI OLEDB Enterprise query show empty result

Hello Hezleen​ ,

You must not consider the AFDatabase name in the path. Please try "WHERE eh.Path = N'\TEST\'.

When you run into a problem like this with the WHERE condition obviously containing something wrong, it helps to look to just the table which has the WHERE condition column.

Just execute a query against PIFD.Asset.ElementHierarchy and see what the data in column 'Path' looks like. Something like the following comes in pretty handy:

SELECT distinct Path
FROM [PIFD].[Asset].[ElementHierarchy]

Hi Gregor,

Thank you very much for your help.. able to query successfully..