Skip to main content
Planview Customer Success Center

UDF code value saved for an entity is no longer displayed

Question
A certain value for an entity based UDF code has been selected and saved into a field for e.g. a request. But when the request is displayed now, the value no longer shows up?

 


 

Answer
This can happen with entity based UDF code when the SQL filter formula is not in the right format.

The right format is when all filtering is done within the WHERE clause. In that case, even if the query no longer returns a value selected for an entity, the value will still show up for those entities that have been saved this value before.

If however filtering is done before the WHERE keyword, e.g. through inner joins, then a previously selected and saved value might now longer be displayed on existing entities if the value is no langer valid for new entities.