Considerations for Advanced Search

Use the Appears on searches for this table option on Options Tab of the Field Property Editor to specify that a field should appear on the Advanced Search page. Here are some things to remember as you specify fields for Advanced Search:

• Fields you select for Advanced Search are visible by all users who can use this feature.
• The Keyword(s) and Project(s) options are always available on the Advanced Search page.
• For newly created tables, no fields are set to display on the Advanced Search page.
• The field order for the Advanced Search page is determined by the default field order of the first project in the table in the project hierarchy. You can change the field order in SBM Application Administrator.
• The project selected by your users determines which values are available for selection field types, such as User fields, but project selection has no effect on relational fields.
• Selection field types are automatically set to searchable if the number of selections exceeds the number specified in SBM System Administrator.
• To improve performance, you should limit the number of selection fields you include on the Advanced Search page.
• While you can include Text fields to the Advanced Search page, it could improve usability to include them in keyword searches instead, because this is their default setting. See Text Field Options for information about the Include field in keyword searches option.
• To improve performance, you could limit the number of Text fields you allow for keyword searching. You can add individual Text fields to the Advanced Search page, but they are treated a bit differently than keyword searching. Items containing the search criteria are returned, but users must search for exact phrases. In addition, wildcard characters do not apply.