2 Replies Latest reply on Nov 3, 2010 5:29 PM by buzzwork

    NPM and Filter Nodes (SQL) ?



      I have a created a custom report and assigned it to "node details", witch works perfectly and want to do a SQL Filter based on a custom field property (lokation) on the node ??

      Filter Nodes (SQL) - Nodes.NodeID = ${NodeID} works but Nodes.Lokation = ${Lokation} doesnt work, gives me an SQL error.

      "System.Data.SqlClient.SqlException: Invalid column name 'ASV'.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)    at ......."