When a user works with filters in the Find dialog and views, Aptify can automatically populate the filter's Value field with a suggested value list of the first 100 possible values that exist in the database. However, in some situations, this feature may not be valuable or decrease the performance of the system. Therefore, Aptify allows an administrator to configure this behavior on a global or per-entity basis. This behavior is controlled by two entity attributes for the Entities entity (found on the Configuration > Attributes tab):

• GlobalViewFiltersSuggestedValueLists: This attribute is set to On by default. It is a system-wide setting to control whether or not the Filter Control Value Drop Down Lists will be filled with up to 100 values pulled from the database. The possible values for this attribute are Off (do not retrieve suggested values), Per Entity (only retrieve suggested values when a particular Entity has the ViewFiltersSuggestedValueLists attribute defined with a value of On.), and On (always attempt to retrieve suggested values).
• GlobalFindSuggestedValuesLists: This attribute is a system-wide setting to control whether or not the Find Filters Drop Down Lists will be filled with up to 100 values pulled from the database. The possible values for this attribute are Off (do not retrieve suggested values), Per Entity (only retrieve suggested values when a particular Entity has the FindSuggestedValueLists attribute defined with a value of On.), and On (always attempt to retrieve suggested values). This attribute is set to Per Entity by default but no entities have a corresponding FindSuggestedValueLists attribute by default so it is effectively disabled.

You can modify these two global attributes as necessary based on the system functionality desired. In addition, when one or both of the attributes is set to Per Entity, you can add the following attributes to one or more entities to limit the locations where this functionality is available:

• ViewFiltersSuggestedValueLists: This is an entity-specific attribute you can add to any Entities record's Configuration > Attributes tab to turn on the Filter Control Value Drop Down list for views of that particular entity. When adding this attribute to an entity, set the value to On. Note that using this attribute assumes that GlobalViewFiltersSuggestedValueLists attribute is set to Per Entity.
• FindSuggestedValueLists: This is an entity-specific attribute you can add to any Entities record's Configuration > Attributes tab to turn on the Find Filters Value Drop Down list for Find dialog filter operations for that particular entity. When adding this attribute to an entity, set the value to On. Note that using this attribute assumes that GlobalFindSuggestedValuesLists attribute is set to Per Entity.