;

Skip to main content

 

  • arrow icon

 

Planview Customer Success Center

ORDER BY statement not allowed in UDF entity based v2012

There is a UDF entity based with an 'order by' statement in the SQL filter (existing before the upgrade to Changepoint v2012).
Modifying the entity based UDF, result in this popup message : "The ORDER BY statement is not allowed in the SQL filter."

Before version 2012, it was possible to add “ORDER BY” statement for UDF entity based in SQL filter.


Some validation checks have been added in v2012 on the SQL Filter of the Entity based UDF fields.

Remove the ’order by’ statement of the filter. Changepoint sorts correctly results alphabetically.