Setting Limits on Advanced Lookup Tool Results

The Lookup Results options enable you to specify limits for results the Advanced Lookup Tool in the SBM User Workspace.

To set limits on Advanced Lookup Tool results:

  1. From the Options menu, select Settings or click the Settings icon on the toolbar.
  2. Select the Display tab.
  3. In the Max Total Rows setting, specify the number of rows that appear in the Lookup Results frame. For example, if you enter 2 as the maximum number of rows and perform a lookup for companies, only the first two companies in the list are returned in Advanced Lookup Tool searches and users must constrain their search criteria to return the correct results. The range for this setting is 1 to 1,000.
  4. In the Max Primary Items Per Group setting, specify the number of items returned in sub-groups in Advanced Lookup Tool search results. This setting only applies if the Fields for Organizing Browser Results Frame option has been configured in SBM Composer. You can view this setting on the Advanced tab of the Edit Table dialog box. The number entered for this setting cannot exceed the Max Total Rows setting. The range for this setting is 1 to 500.
  5. Click OK.