Axapta : Query Properties
|If set Configuration keys and Security keys will be validated at runtime.
|Specifies the Axapta form used for the query dialog. This is normally not
|Specify whether the query dialog is shown to the user.
|Choose either default, forceliterals or forceplaceholders. All statements
|which are frequently executed should use forceplaceholders and
|forceliterals can be used against non-frequent skewed data.
|AOT name of the query.
|Caption for the query.
|Defines whether user settings to the query are saved.
|If disabled, the user can not add or delete table ranges. The same applies for
|Fetch data from a specify company. It is normally not used, as the user
|expect data to be fetched from the active company.
|Should the data source be enabled or disabled. If disabled, it will be ignored
|in the sql statement.
|Only joined data sources has this property. Can be used to change a one to
|many relation to one to one relation. This property is not used very often. In
|the most cases the property JoinMode will be sufficient.
|Should the first record be fetched faster than the remaining records.
|Only select the first record.
|How should the data sources be joined.
|AOT name of the data source.
|Choose either order by or group by. This will influence the way data is
|ordered or grouped from the database.
|If enabled, relations between this data source and the data source one level
|above will be added using the actual data model.
|If set to yes, the record will be fetched forupdate allowing the record to be
|Show default all fields for the table. If the reports order mode is group by,
|the property will be set to no, and only aggregated values can be chosen for
|the Fields node.
|Should a group title be printed each time the value in this field changes.
|Only used by report queries.
|Should a sum be printed each time the value in this field changes. Only
|used by report queries.
|Used in report queries by the property AutoHeader. Default a header is
|printed when the value of the sorting field changes. The property can be
|used to determine for which part of a field an index break should occur.
|Fields using the characters dot, space, dash, back slash forward slash
|consists of several sub fields. If the value of customer account is
|“CUST100.10 “, the field value consists of two subfields. Setting
|HeaderDetailLevel to 2 will cause an index break to occur, when the value
|after the dot is changed.
|Set the ordering to either ascending or descending.
|Used in report queries by the property AutoSum. Default a header is printed
|when the value of the sorting field changes. The property can be used to
|determine for which part of a field an index break should occur. Fields
|using the characters dot, space, dash, back slash forward slash consists of
|several sub fields. If the value of customer account is “CUST100.10 “, the
|field value consists of two subfields. Setting SumDetailLevel to 2 will
|cause an index break to occur, when the value after the dot is changed.
|If disabled, the range will be ignored.
|This is the label of the range field.
|AOT name of the range.
|Choose either open, locked or hide. If open, the range can be modified and
|deleted. If locked, the range can not be modified or deleted. If hidden, the
|range will not be shown in the query dialog.
|Fixed value for the range.