The Advanced tab in the Properties pane allows you to specify more options for filter results.
Option |
Description |
---|---|
Display as Class |
If a filter is created for a standard or extended Class, all related classes are available for selection in the Display as class drop-down list. If a filter is created for an Association Class, the associated classes are available for selection in the Display as class drop-down list. When a user opens the object, the class selected will be the class that objects returned by the filter will display as. If <<Default>> is selected for an Associated Class filter, only the History and Documents tabs or dialog boxes will display for opened objects. Note:
When an association filter is used as an embedded filter, the Display as class setting is ignored and the appropriate class is displayed when the object is opened from within the embedded filter. For example, if you have three classes: Employee, Issue, and EmployeeXIssue and you configure an embedded filter of Class ‘EmployeeXIssue' on a view for an Employee to display all ‘Issues' that are associated to that ‘Employee', when you open an object from the embedded filter, the Display as class setting is ignored and the object that is opened is the ‘Issue' object and not the ‘EmployeeXIssue' object regardless of the Display as class setting. When a class is selected in the Display as class drop-down list, the Return distinct items option is available. When this option is selected, only unique objects are displayed. Uniqueness is determined by the Display Columns configured for the filter. Note:
When the Return distinct items option is selected, in the Unity Client, the Delete button is disabled when using the filter. Note:
When using an Oracle database and a filter uses the Return distinct items option and a text or formatted text attribute is configured as a display column, the filter configuration is not supported. Note:
The Open in new window button available in an embedded filter will not be available for relationships in a filter that is configured with the Display as Class option. |
Screen displayed when creating an object | Screen selected here will be used when new objects are created from a filter. |
Screen displayed when opening an object | Screen selected here will be used when objects are opened from a filter. |
Group Like Constraints |
If the Group Like Constraints check box is selected for a filter configured with User Prompts or Fixed Constraints, when multiple values for the same attribute are included in the search, parentheses enclose multiples values of the same attribute to group those together, although the parentheses are not visible in the interface. For example, if you have a Name attribute and Department attribute and you specify two values for the Name attribute and one for that Department attribute, the search will be structured in the following way: This search would return objects with the Name Sam and the Department Accounting or objects with the Name Sally and the Department Accounting. In this way, the parentheses are grouping values of the same attribute to create more complex searches. |
Ability to Select Multiple Rows |
If the Ability to Select Multiple Rows option is selected, a column containing check boxes is added to the filter in the Web Client, allowing multiple objects to be selected and deleted at once. |
Show Entire Text Values |
When the Show Entire Text Values option is selected, attributes with long text values exceeding 256 characters will not be truncated in the filter's results. When this is selected, all text will be displayed for attributes configured as view attributes. Note:
If you want to allow users to export filter results to Microsoft Excel that contain values with more than 255 characters, select Show Entire Text Values to ensure values are not truncated in the export. |
Show Only Deleted Objects in Filter |
When this option is selected, only objects that have been deleted, but not purged from the system, that meet the search criteria of the filter are displayed in the filter's results. |
Display as Dashboard |
When this option is selected, filter results will be displayed in a dashboard view by default. Note:
This is only supported in the Unity Client. |
Enable Maximum Results |
When this option is selected, you can enter the maximum number of results you want returned for the selected filter in the Maximum Results field. Warning:
A high number of the displayed results may impact performance negatively. |
Enable Text Search |
If you want to allow full text searching from the filter, select Enable Text Search. When this is selected, full text searching is available in the Client for the filter. The full text catalog that is defined as the application's default catalog will be used by the filter search by default. If no catalog is configured as the default, the first catalog listed is used. Note:
When the Enable Text Search option is selected, the Show Count option will not be available for the filter within the Unity Client. Note:
This feature requires the Context Search Framework (WorkView) license when using legacy licensing. If a filter on a shared class has been configured with the Enable Text Search option selected and this same filter is added to the filter bars for multiple applications, filters may not execute correctly upon the system reconnecting after a server restart unless:
|
Default Full Text Catalog |
When the Enable Text Search option is selected, you can specify the default full text catalog that will be used when searching using the selected filter. Select the appropriate filter from the drop-down list. If a full text catalog is not specified here, the full text catalog defined as the application's default catalog will be used. In addition, you can create a New full text catalog or Modify an existing full text catalog by selecting the appropriate option from the drop-down list to the right of the full text catalog selection drop-down list. See Configuring Full Text Catalogs for more information. |
Enable reportable view |
The option allows you to create a database view that will displays all the data retrieved by the filter. Select the Enable reportable view check box and enter the Name you want to use in the field. This name cannot have any spaces, special character, or start with a number. When using an Oracle database, the name is limited to 27 characters. When using a SQL database, the name is limited to 50 characters. If you enter View550, the view in the database will be named hsi.rm_View550. Note:
This is not supported for external classes that use an ODBC connection or Unity Script. Note:
Database views created for a filter that makes use of date/time, user, or other session-based macros in constraints will use the current values for these macros in the Reportable View as they exist at the time of view creation and may not provide the desired results. In addition, filters for classes that are secured by Security Attributes will not respect any security context during view creation and may not provide desired results. Also, calculated attributes are not included in the reportable view due to the fact they are calculated at runtime and values are not stored in the database. |