Skip to main content

Query Properties

  • Updated

Previous Topic  Next Topic

Query Properties

The properties of a query are as follows:

Property NameDescription
Data Source FilterSpecifies whether the query can be used in data source filters.

Data type: Boolean

DescriptionSpecifies the description of the query.

Data type: String

Enable SQL Statement CreatorSpecifies whether or not the query uses the dynamic query interface to get the result set. When it is set to true, the query can be re-generated at runtime using the dynamic query interface (for more information, see Dynamic Queries).

Data type: Boolean

Maximum DurationSpecifies the maximum elapsed time allowed to fetch data from the data source when the query runs, measured in seconds. If the value is set to zero or is blank, it means the time will be unlimited.

For usage about the property, see Limiting the Query Run Time and Number of Records.

Data type: Integer

Maximum RowsSpecifies the maximum number of rows that will be fetched from the data source when the query runs. If the value is set to zero or is blank, it means the number will be unlimited.

For usage about the property, see Limiting the Query Run Time and Number of Records.

Data type: Integer

NameSpecifies the name of the query.

Data type: String

Path NameSpecifies the path in pre-join that the query is created on (for more information, see Creating Queries Using Pre-join).

Data type: String

Push Down Group QuerySpecifies whether to push down group level summary computations in reports that are created based on the query to the DBMS at runtime. Choose an option from the drop-down list.
  • default - The setting of the Push Down Group Query property on the JDBC connection where the query is created will be applied.
  • true - Logi JReport will push down the group level summary computations to the DBMS if the DBMS can do the computations, otherwise, Logi JReport will do the computations itself.
  • false - Logi JReport will do the group level summary computations itself.

Data type: Boolean

Read OnlySpecifies whether or not the query will be read only.

Data type: Enumeration

ShareSpecifies whether or not to share the query (for details, see Locking Queries).

Data type: Boolean

Transaction Mode Specifies the transaction mode for the query. Choose an option from the drop-down list.
  • default - Indicates the transaction information cannot be got from JDBC connection.
  • none - Indicates that transactions are not supported.
  • read uncommitted - Dirty reads, non-repeatable reads and phantom reads can occur. This mode will speed up the transaction of the catalog.
  • read committed - Dirty reads are prevented; non-repeatable reads and phantom reads can occur.
  • repeatable read - Dirty reads and non-repeatable reads are prevented; phantom reads can occur.
  • serializable - Dirty reads, non-repeatable reads and phantom reads are prevented.

Data type: Enumeration

A query contains several columns, the properties of which are shown in the following topic: Query Column.

Previous Topic  Next Topic

Related articles