Queries Repositories

Overview

This generic description is valid for the following repositories:

  • Metrics

  • Conventions

  • Dependency (Filter) Queries

  • Dependency (Select) Queries

For details, refer to the respective chapters.

You can organize and create queries and query chains for all repository categories. A query chain consists of one or more queries.

Each repository provides a list of pre-defined queries and query chains that can be used as templates for user-defined queries/query chains. The pre-defined queries and query chains can also be modified directly.

The main window of a repository provides three parts:

  • Query chains (left-hand side)

    List of available query chains. For metrics and conventions the synchronization status with Machine Advisor Code Analysis is provided.

  • Queries (right-hand side)

    List of available queries.

  • Results (bottom)

    Results of the selected and executed query chain.

The rightmost repository editor provides the Parameters Editor.

Query Chains

The Query Chains tree contains query chains that are available by default (by EcoStruxure Machine Expert installation) and the user-defined query chains created with the Query Chain Settings Editor.

The predefined query chains provided by Schneider Electric can be modified and also be reset to their initial values.

Toolbar

Element

Description

Execute

Click this button to execute the selected query chain.

The result is displayed in the Results window at the bottom.

Edit

Click this button to edit the selected query chain. You can edit only the user-defined query chains. Edit opens the Query Chain Editor.

Duplicate

Click this button to duplicate the selected query chain and enter a name for the new query chain. Double-click the duplicated query chain to open the Query Chain Settings Editor.

New

Click this button to add a new query chain. New opens the Query Chain Settings Editor

Remove

Click this button to remove the selected query chain.

You can remove only the user-defined query chains.

Restore

Click this button to restore the selected rule set. You are prompted to confirm. Confirm with Yes or cancel with No.

If you confirm, the customized rule set is restored to the original rule used for customization.

Refresh

Click this button to start the comparison for rule sets between EcoStruxure Machine Expert and Machine Advisor Code Analysis.

If EcoStruxure Machine Expert is not logged into Machine Advisor Code Analysis, the Cloud Connection tab is opened to enter your user credentials.

Download missing

Click this button to download the rule sets from Machine Advisor Code Analysis that are not available on EcoStruxure Machine Expert.

If EcoStruxure Machine Expert is not logged into Machine Advisor Code Analysis, the Cloud Connection tab is opened to enter your user credentials.

Download selected

Click this button to download the selected rule sets from Machine Advisor Code Analysis to EcoStruxure Machine Expert.

If EcoStruxure Machine Expert is not logged into Machine Advisor Code Analysis, the Cloud Connection tab is opened to enter your user credentials.

Upload selected

Click this button to upload and update the selected rule sets to Machine Advisor Code Analysis.

If EcoStruxure Machine Expert is not logged into Machine Advisor Code Analysis, the Cloud Connection tab is opened to enter your user credentials.

Assign and Order Queries to Chains

Element

Description

Arrow buttons

Use the Arrow buttons between the Query Chains and the Queries to add a query to or to remove a query from a selected query chain. You can also use these buttons to modify the order of queries in a selected query chain.

You can edit only the user-defined query chains.

Drag-and-drop

You can also use drag-and-drop to add a query to or to remove a query from a user-defined query chain.

Queries

The queries list shows queries available by default (installed with EcoStruxure Machine Expert), and the user-defined queries.

You cannot remove or edit the predefined queries. You can only duplicate these queries.

Toolbar

Element

Description

Edit

Click this button to edit the selected query. You can edit only the user-defined queries. Edit opens the Query Editor.

Duplicate

Click this button to duplicate the selected query and enter a name for the new query. Double-click the duplicated query to open the Query Editor.

New

Click this button to add a new query. New opens the Query Editor.

Remove

Click this button to remove the selected query.

You can remove only the user-defined queries.

Restore

Click this button to restore the selected query. You are prompted to confirm. Confirm with Yes or cancel with No.

If you confirm, the customized query is restored to the original query.

Parameters Editor

The Parameters Editor displays the parameters for the selected query / query chain.

Refer to Parameters Editor.