Saved Searches for Custom Sublists
To be used for a custom sublist, a saved search must have at least one list/record type field defined as an available filter. Custom sublist results are joined to the form record based on this field's values. That is, the first item listed on the Available Filters subtab of the saved search must be a list/record type. The custom sublist results that are displayed on each form have the same value for the available filter field as the record currently displayed on the form.
For example, in a saved search for a transactions sublist on a customer record, you could set an available filter of Name (the customer name) so that all transactions for the customer show in the sublist.
For details about available filters, see Selecting Available Filters for Saved Searches.
Be aware of the following when you choose a field to be the available filter for a custom sublist search:
-
If the saved search has more than one available filter, only the first one listed on the Available Filters subtab is used to filter the custom sublist.
-
The available filter field must be of the List/Record type, meaning it is displayed in the user interface as a list. Constant value fields and numeric fields do not work.
Note that the searches you can select for custom sublists do not include searches where the type of the first available filter is check box or date, because these types of fields do not work.
-
If the sublist represents a different record than the form record, the available filter field should be a logical choice to produce joins with the form record. Many fields that are listed on a search's Available Filters subtab are not logical choices for this type of join.
For example, in a saved search for a transactions sublist on customer record, it would not work to set an available filter of Type. This choice would most likely result in no joins with the customer record, and a blank sublist would display.
To be a good choice as an available filter, a field should identify a record type.
-
The filter field can be the same as the form record. For example, use the Name field for a transactions sublist on a customer record that displays all of that customer's transactions.
-
Or, the filter field can be a field on the form record that is a list of records. For example, use the Location field for a transactions sublist on a customer record that displays the customer's transactions for a particular location only.
-
To create a saved search:
-
Go to Reports > Saved Searches > New Saved Search. Click the record type you want to display in the custom sublist.
The results of this search should include the information you want to show on your sublist.
For information about creating saved searches, see Defining a Saved Search.
-
Enter a name for the search.
-
Set criteria for the search.
-
On the Available Filters subtab, add at least one available filter to the search, and ensure that the first filter listed is a List/Record type. Otherwise, the saved search is not available to assign as a sublist.
You can attach a saved search as a sublist only if the search has at least one available filter. The sublist shown is filtered by the first filter listed on the saved search. Be sure that the search and the filter both apply to the record you are attaching the sublist to.
For information about setting available filters, see Selecting Available Filters for Saved Searches.
-
Click Save.