Query Some Mandatory

Previous Next

Force the use of a search condition for at least one column of a set of data columns.

Background

You can force the user to enter a query condition for at least one of a subset of columns but leave it to the user, which of the columns is to receive the condition.

When to use

Force the use of a search condition for those columns for which at least one query condition has to be entered. This way you can, for instance, force the user to query at least one foreign key field without specifying the exact value.

To force the use of a search condition for at least one column of a set of specific data columns:

1.Use the Class Catalog to select and open the appropriate window.
2.Navigate to one of the appropriate column objects.
3.Open the Property Inspector, and click the Behavior tab page.
4.Change the Query Some Mandatory property to Yes.
5.Repeat steps 2-4 for each of the subset columns.
6.Save your changes.

Limitations

If you limit query activity using this setting, it will still be possible for the user to use the %-wildcard.