There are some attributes that do not show up for configuration in the filter section nor in the [Build Power Filter] page. There are some attributes that are available for configuration in the filter section and not in the [Build Power Filter] page. Here is one example. Can you please explain why the attributes cannot be configured and used in filtering?
Creating a user-defined custom calculated attribute on any object is not showing as an available attribute for configuration in a power filter. The example below is given for the Project Object, but the issue can be reproduced on other objects too.
Steps to Reproduce:
- Login to the application as an administrator user
- Administration, Studio: Objects: Project, Attributes Tab
- Click 'New' button
Attribute Name = 'My Calculated Number Attribute'
Attribute ID = 'my_calc_number'
Data Type = Calculated
Result Data Type = Number
Click 'Save' and configure the calculation
Current Expression Absolute(12345)
(it does not matter how the calculation is defined)
- Add the attribute to the following views
Views > Project List : [Layout]
Views > Project Filter : [Layout]
Be sure that the 'Allow Power Filter' option is selected
- Home, Projects
Note: you can see the field in the Project List View and in the Filter Section
- Click [Power Filter]
Select 'Project' in the Left : Object field
From the 'Field' pull-down look for 'My Calculated Number Attribute'
Expected Result: The calculated attribute should appear as an available attribute.
Actual Result: The calculated attribute is not available for selection.
Calculated, Formula and Virtual attributes are not to be used in a power filter.
These attribute data types can be used on the Filter Layout in conjunction with a power filter (defined with other attribute data types) as an 'AND' condition.
Note: Large String, Time-Varying and Attachment attribute data types are not available for use in filter or sorting actions.