Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Invokes the specified Query function with the given set of arguments. When pushing the OK-button on the Data>ExequteQuery dialog, a new dialog tailored to the actual Query function will appear. The number of input fields and the prompts will be according to the signature of the Query function to execute.
The Query function may allocate virtual memory for the result data. This allocated virtual memory is identified by the "Query result index" written out by this command. The actual virtual memory can later be released by the command Data>Query>ReleaseQueryResults to avoid "out of virtual memory" errors.
Important: The model must be opened for read and write access if the query function is supposed to update the model. See open model for details.
The expressions logging facility and the interactive EDMexpressVM can be used to test and debug a query function.

Info

The maximum number of query input parameters in the  EDMsupervisor is 20

 


Arguments:

Repository:

Specify the name of the repository holding the model to be queried. Repository names are case sensitive.
When activating the Select button, the name of all open repositories will be displayed in the related selection list.

Model:

Specify the name of the model to be queried. Model names are case sensitive.
When activating the Select button, the name of all open models located in the repository(ies) specified by the <Repository> argument will be displayed in the related selection list..

Query Schema:

Specify the name of the Query schema(ta) to use. Query schema names are case insensitive.
When activating the Select button, the name of all Query schemata that exists for the underlying EXPRESS schema of the model specified in the <Model> argument will be displayed in the related selection list.

Query:

Specify the name of the Query Function to be invoked.
When activating the Select button, the name of all existing Query functions in the specified Query Schema will be displayed in the related selection list.

Columns:

Specify which columns to include in the query result table. A column name is an attribute name in an entity instance or in a view entity instance.
When activating the Select button, all available columns will be displayed in the related selection list. The selected item will be added to the current content in the related input field of the actual dialog.
This argument is only valid when the [result as table] option is enabled.

Order by:

Specify which column to sort by. Columns of data types SdaiInteger, SdaiInstance, SdaiString and SdaiEnumeration can be specified in this argument.
When activating the Select button, all available columns will be displayed in the related selection list.
This argument is only effective when the [result as table] option is enabled.

Output file:

Specify the name of a file that will be used to receive the result of executing the Query function in the actual Query schema. The specified file can be an existing file or the name of a file that will be created by the actual Query schema execution. This argument is valid when the [file output] option is set.
When activating the Select button, a window is opened to allow browsing the directory structure and select/specify the desired file.

...