Select remote Aggr elements

Server context name:

Specify name of server context.
When activating the Select button, the name of all defined server contexts will be displayed in the related selection list.

Remote aggregateId:

A numeric aggregateID that uniquely identifies the aggregate of instances in the remote EDMdatabase.

Attributes:

Specify the names of the attributes that will be the columns in the resulting table. In case of more attributes in this argument, the attribute names should be separated with the space or the comma character. The number and the order of the columns in the result table will be according to the number and order of the attributes in this argument. Attribute names are case insensitive.
The default value of this argument is that the result table will have one column for each attribute in the actual entity (including inherited attributes) and the order of the columns will be according to the order of the attributes in the related Entity declaration.
When activating the Select button, the name of all existing attributes in the model specified by the argument <Entity> will be displayed in the related selection list. The item selected from the selection list will be appended to the content of the related input field.

Order by attribute:

Specify the name of the attribute to order the selection by.
When activating the Select button, the name of all existing attributes in the model specified by the argument <Entity> will be displayed in the related selection list.

Filter (entity names):

Specify the name of the entity, i.e. the type of the instance to select. Entity names are case insensitive.
When activating the Select button, the name of all existing instance types in the model(s) specified by the arguments <Repository> and <Model> will be displayed in the related selection list.

First aggr index to check:

Specify an integer value denoting the index of the first instance to be queried. The first instance in aggregate has index zero.
This argument will be automatically updated to the index of the last instance that matched the query plus one, when the option [update indexes] is set. This feature makes it convenient to query all instances of a particular type in several consecutive queries.

Condition:

Specify the condition the actual instance should match. The <Condition> argument can be any legal Express-X logical expression, including function calls. The <Condition> should be written in "symbolic Express-X syntax".
All queried instances will match the query when this argument is empty (blank).

Max number of hits:

The max number of instances that can be returned in one call is limited to 10000. When the number of hits exceeds this limit, the actual operation should be repeated with the option <update indexes> set until all hits are found.
This argument restricts the number of rows to be returned as long as it is less or equal to the maximum 10000. If this argument is set to the string value all and total number of rows is under or equal to the maximum, all the rows are returned.

Remote XML configuration:

The name of the XML configuration to apply to the resulting XML formatted query result when the option [xml format] is used.

Output file:

Specify the name of an optional output file that will receive the result table.
When activating the Select button, a window is opened to allow browsing the directory structure and select/specify the desired file.

accumulating command output:

A global option that appends the command output to the EDMsupervisor output window. Otherwise the output window is refreshed and only the last command output is displayed.

match selected input:

A global option that specifies that only items that partly or exactly matches the string in the related argument input field when activating a Select button, will be in the selection list. An empty (blank) string will match all items.
This option has no effect on file name arguments.

update indexes:

A global option that specifies that the <First instance to check> argument will be updated to the next index after the one currently displayed.

all attributes:

When the argument <attributes> is NULL or an empty string, all attributes of the instances will be included in the query result. However, if the <Attributes> argument is used to add one or more aditional constructed columns or to rename a column in the query result, the return of all the instance attributes will be hindered due to an <Attributes> argument that is no longer NULL or an empty string. Use this option to force the including of all instance attributes even when the <Attributes> argument is not NULL or an empty string. This option is only applicable on aggregates of instances.

include filter:

Only the aggregate elements of types that are explicitly listed in the <Filter> argument will be queried for matching instances. This option is only applicable on aggregates of instances.

exclude filter:

All the aggregate elements, but those of types that are explicitly listed in the <Filter> argument, will be queried for matching instances. This option is only applicable on aggregates of instances.

ascending:

Ascending sorting order. This option is only effective when the <order by> argument is specified. When the result table is displayed on the screen, the table can be sorted according to a column by clicking on the actual column head frame.

Descending:

Descending sorting order. This option is only effective when the <order by> argument is specified. When the result table is displayed on the screen, the table can be sorted according to a column by clicking on the actual column head frame.

Include instance_ids:

Prepend all attribute columns in the query result with an instanceId column.

only instance_ids:

Return only a single column with the instanceIds of the matcing instances.

include element indexes:

Returns a column with aggregate indexes of all the matching elements.

only element indexes:

The query result table will contain only one column with the aggregate index of all the matching elements.

ignore empty columns:

Specifies that empty columns will not be part of the result table.

transfer no data:

No query result will be returned from the remote EDMdatabase. Use this option when the number of matching instances is the only information needed or for testing the query syntax before actually performing it.

html format:

The output file will be created in HTML format. Default file extension is ".htm". This option is only valid when the [result in file] option is set.
Only one of the [html format], [xml format] and [ascii format] can be enabled in the same command execution.

xml format:

The output file will be created in XML format. Default file extension is ".xml". This option is only valid when the [result in file] option is set.
Only one of the [html format], [xml format] and [ascii format] can be enabled in the same command execution.

old xml format:

The result of the query will be returned in a simple wellformed XML formatted file on the local file system.

ascii format:

The output file will be created in ASCII format. Default file extension is ".txt". The tabulator character will be delimiter between each column. This option is only valid when the [result in file] option is set.
Only one of the [html format], [xml format] and [ascii format] can be enabled in the same command execution.

result in file:

Specifies that the result from the command will be written to the file specified in the <Output file> argument.
If the option [file output] is set, then the output from this command will be written to the actual <Output file> if defined, else the output from these functions will be written to the EDMsupervisor output window.
The format in the actual file is specified by enabling one of [html format], [xml format] or [ascii format] options.

zipped file:

The file given by the argument <Output file> will be compressed with gzip.

show file:

The generated output file will be displayed in the available internet browser when the option [file output] is set together with one of the options [html format], [xml format] or [old xml format].