Query Parameters

Query.OptionalColumns

Description: Allows you to specify additional field ids to display in query selector results list. For example, specifying {'ID': [11,12,0] } displays the additional fields: Last Name, First Name, and Rep/Group ID.

Default: Empty

Type: JSON

Query.BackgroundExecutionStart

Description: Allows you to define a start time for processing asynchronous queries on the server. For further details, see Background Queries. This allows the processing of background queries to be scheduled for off-peak hours to avoid performance issues.

Enter the desired start time using the format hh:mm e.g. "23:00".

Default: Empty

Type: Character

Query.CountRecords

Description: The count feature does not execute the query itself but counts the rows that would be returned. This operation is resource-consuming for the server and thus Query.CountRecords should be activated with care and set to a sensible limit e.g. "500".

If this parameter is set to 0, the count feature is disabled, i.e. the button is not available.
If set to any value > 0 (e.g. "500"), the button is available in the Query and QueryFooter headers and the message "> x rows" is displayed if more rows exist.
Use this setting to restrict the number of result rows. If fewer result rows are returned, they are displayed. If more result rows are returned, a message is displayed instead of the rows.
Enter –1 for no limit.

Default: 0

Type: Number

Query.FieldsSortOrder

Description: Determines the sort order of the field selection dialogs when defining filters and queries in Aurea CRM.Web: "alphanumeric" or "by id". This setting defines the default behavior and is overruled by the user's sort and column order settings.

Default: Alphanumeric

Type: Combobox

Note: Order clause (sort) in queries is parsed based on the info areas order in the query so, Order (sort) fields is rearranged by CRM if it is not in the correct order. For instance, in the following query :

select ('FI.SAP-No', AddressType, CompanyName, Country, ZipCode) 
from (ZA)
plus (FI)
orderby ('FI.SAP-No', AddressType)

The actual sort order is "AddressType" then "FI.SAP-No" because "AddressType" is from the first info area (ZA) and "FI.SAP-No" from the second one.

Query.HideSystemFields

Description: By default, system fields (Created on, DelCd etc.) are not visible when defining filters and queries. For further details, see System Fields in the CRM.Core Administrator Guide.

If you define Query.HideSystemFields and set it to false (= unchecked), system fields are displayed when defining filters and queries.

This parameter is not part of UPDATE_DEFAULT but needs to be created if required.

Default: Unchecked

Type: Checkbox

Query.ImportantInfoAreas

Description: Defines the info areas and their order that are displayed as Quick Links in the info area selection dialog when creating new queries.

Default: "FI,KP,MA,Y1" in the BTB vertical, "FI,KP,MA" for the OTC and FS verticals

Type: List

Query.LoadFrom

Description: Defines from which databases – Aurea CRM and/or CRM.Designer – Aurea CRM.Web loads queries. For further details, see Storing Queries.

Available values:

Aurea CRM: Aurea CRM.Web loads queries from the Aurea CRM database only.
CRM.Designer: Aurea CRM.Web loads queries from the CRM.Designer database only.
both: Aurea CRM.Web loads queries first from the Aurea CRM database and then from the CRM.Designer database.
both, CRM.Designer first: Aurea CRM.Web loads queries first from the CRM.Designer database and then from the Aurea CRM database.

Default: both, CRM.Designer first

Type: Combobox

Query.MaxRecords

Description: Defines the maximum number of records that can be returned by a query.

Enter "-1" for "All".

Default: 1000

Type: Number

Query.NumberOfResults.Default

Description: Number of records of the query result that are displayed at once. Possible values: any number (e.g. 20,50,100...), "search" or "all".

This setting affects the QueryResult in the query editor, the QueryRun page and the QueryResultPresenter widget in forms. (Restriction for QueryRun: Query.NumberOfResults.Default overrules the maxRows argument, i.e. its value is used for calculating the page size.)

If undefined, the value of the Web Configuration parameter Search.MaxResults is used. For further information, see Search.MaxResults.

Default: 50

Type: Number

Query.NumberOfResults.DefaultForRun

Description: Defines the default value for the number of records Max. Rows drop-down list returned by a query execution. Enter "-1" for "All".

Default: 100

Type: Number

Query.NumberOfResults.Steps

Description: Steps for record count returned by a query. Users can choose between these steps when they execute queries. Enter "-1" for "All".

Default: 20,50,100,1000,10000

Type: List

Query.Parameters

Description: With this parameter, you can prevent users from exporting and/or saving the results of a query. Available values:

Disable exporting of query results
Disable saving of query results

Default: Undefined

Type: Checkboxes

Query.Rights

Description: Defines the user's rights for loading, saving and executing queries. Available values:

disabled: Queries are not available.
readonly: Allows the user to execute predefined queries.
read+define: Allows the user to edit and create queries and save them as private queries.
all (default): Grants full access rights. The user can also create and save public queries.

Default: all

Type: Combobox

Query.SaveDateExpressionWithoutEvaluation

Description: Enable this parameter to ensure that data expressions in a UQL statement are not evaluated, before saving the UQL statement to the database. This is useful when you are using expressions in a date condition. For example, with this option enabled, the expression $??##+1m is not evaluated and is stored as it is in the FT table.

Note: Date expressions are not directly supported by the CRM.Core. You can use these queries only with .Net framework components.

Default: Unchecked

Type: Checkbox

Query.SaveTo

Description: Defines to which databases a query defined in Aurea CRM.Web is saved. For further details, see Storing Queries. Available values:

Aurea CRM: Aurea CRM.Web loads queries from the Aurea CRM database only.
CRM.Designer: Aurea CRM.Web loads queries from the CRM.Designer database only.
both databases: Aurea CRM.Web loads queries first from the Aurea CRM database and then from the CRM.Designer database.
both, CRM.Designer first: Aurea CRM.Web loads queries first from the CRM.Designer database and then from the Aurea CRM database.

Default: Aurea CRM

Type: Combobox

Query.ShowParameterMissingWarning

Description: Enable this parameter to validate a query’s fields for required values. If a query’s field is missing a value a warning message pops up informing the user about the empty fields.

Default: Checked

Type: Checkbox

Query.ShowVirtualFields

Description: If checked, fields flagged as VirtualCore (i.e. virtual fields with fixed IDs from 4200 to 4230, e.g. Created by ID) are available for filter and query definitions in Aurea CRM.Web. For further details, see Fields with Fixed IDs in the CRM.Core Administrator Guide (2nd table).

If unchecked, those fields are hidden.

Note: Regardless of this setting, the Number of records (RecCount) field (4230) is always displayed for queries of type WITH SUMMED, PLUS SUMMED and HAVING. Reference fields (Z-fields) are never available for filter and query definitions in Aurea CRM.Web. However, they can be defined as output fields in queries.

The Query.ShowVirtualFields setting also applies to the fields displayed in the ViewAllFields dialog. For further details, see ViewAllFields.

Default: Checked

Type: Checkboxes

Query.DisableAutoAddArrayFields

Description: Check this option to prevent all the fields present in an array field to show up in a query result. This ensures that only the array fields specified in a query filter are diplayed.

Note: By default, queries are automatically adapted to include all associated fields of the specified array field.

Default: Unchecked

Type: Checkboxes