Skip to main content
Planview Customer Success Center

In a custom report, how to add lookup list for features in runtime filters, if the Features do not have a FeatureID in the database, only a FeatureCode (2010)

ANSWER:
To use the feature code as ID field in a lookup list, it must be an internal field. Then define a lookup list of type static using this query:

SELECT featurecode, description FROM featuredescription

If you also want to display the feature code itself in the report, add the feature code column twice into the custom view. One column will be a regular text column that can be displayed in the report. Set the second featurecode column to be hidden/internal so you can use it in the lookup list.