Select remote instance references

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 instanceId:

Specify an unsigned integer value denoting the EDMdatabase unique instanceID of the remote instance of interrest.

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.

Order by attribute:

Specify the name of the attribute to order the selection by.

Filter (entity names):

Specify the name of the entities, i.e. the types of the instances to select. Entity names are case insensitive.

First reference index:

Specify an integer value denoting the index of the first instance in the result set to be returned. The first instance in the result set has index zero.
This argument will be automatically updated to the index of the last referencing 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:

Specify the maximum number of instances that matches the condition specified in the argument <Condition> and not filtered by the <Filter> argument. This argument restricts the number of rows to be returned. This argument can be set with the string value all – i.e. to return all rows matching the query as long as it does not exceed 10000 rows.
When the number of hits exceeds the limit of 10000 rows, the actual operation should be repeated with the option <update indexes> set until all hits are found.

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.

include filter:

Only instances of the entities listed in the <Filter> argument will be queried.

exclude filter:

All instances except those of the entities listed in the <Filter> argument will be queried

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.

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 well formed 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] or [xml format].