Query Options Command

Use the Query Options command from the Report menu to set the concurrency strategy and current resource limit option values that are applied to the report in the query phase of the report run.

You can specify strategies to isolate the report results during report output from the effects of concurrently updating transactions. Isolating report results during output ensures that the data obtained is consistent and not affected by transactions or updates in the database that occur during the report query process. The default concurrency strategy is a repeatable read optimistic, which resynchronizes every object accessed, locks objects needed later, and checks the edition.

When the report uses database fields from collections within the report root collections or view joins, the Query Options command from the reports menu can also be used to set the inclusion option for reporting on these collections.

The following subsections describe the sheets of the Report Query Options dialog.

• Using the Options Sheet

• Using the Types Sheet