Skip to main content

Query Properties

  • Updated

BackPrevious Topic  Next TopicNext

Query Properties

This topic describes the properties of a Query object in a catalog.

Property NameDescription
Data Source FilterSpecifies whether to allow using the query to filter multiple queries. For more information, see Using a Query to Filter Multiple Queries.

Data type: Boolean

DescriptionSpecifies the description of the query.

Data type: String

Enable SQL Statement CreatorSpecifies whether the query uses the dynamic query interface to get the result set. When you set this property to "true", Logi Report Engine can regenerate the query 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. By default, the property value is blank, meaning, the time is unlimited. For more information, see Limiting the Query Run Time and Number of Records.

Data type: Integer

Maximum RowsSpecifies the maximum number of rows to be fetched from the data source when the query runs. By default, the property value is blank, meaning, the number is unlimited. For more information, see Limiting the Query Run Time and Number of Records.

Data type: Integer

NameSpecifies the mapped name of the query in the catalog.

Data type: String

Path NameSpecifies the pre-join path the query applies. 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 the reports that use the query to the DBMS at runtime. Choose an option from the drop-down list.
  • default - Select to apply the setting of the same property for the JDBC connection based on which you create the query.
  • true - Select to push down the group level summary computations to the DBMS if the DBMS can perform the computations; otherwise, Logi Report Engine do the computations itself.
  • false - Select to have Logi Report Engine perform the group level summary computations itself.

Data type: Boolean

Read OnlySpecifies whether the query is read only. Choose an option from the drop-down list.
  • default - Select to apply the setting from the database.
  • read & write - Select to allow users to access the database in read-write mode.
  • read only - Select to allow users to access the database in read-only mode. This option can speed up the transaction of the catalog.

Data type: Enumeration

ShareSpecifies whether to share the query. For more information, see Locking Queries.

Data type: Boolean

Transaction ModeSpecifies the transaction mode for the query. Choose an option from the drop-down list.
  • default
    Select to apply the setting from the database.
  • none
    Select to not use transactions for the query.
  • read uncommitted
    Select to allow dirty reads, non-repeatable reads, and phantom reads to occur for the query. This mode can speed up the transaction of the catalog.
  • read committed
    Select to prevent dirty reads, and allow non-repeatable reads and phantom reads to occur for the query.
  • repeatable read
    Select to prevent dirty reads and non-repeatable reads, and allow phantom reads to occur for the query.
  • serializable
    Select to prevent dirty reads, non-repeatable reads, and phantom reads for the query.

Data type: Enumeration

BackPrevious Topic  Next TopicNext