Enovia MQL Queries
MQL (Matrix Query Language) is an interface allows administrators to interact with enovia database. MQL is similar to SQL for enovia database.
We can use MQL commands to create, modify and extract the data from enovia database.
In enovia Objects are referred to as Business Objects. Each business object is identified with TYPE, NAME, and REVISION. Here TYPE means an object of a type. TYPE is similar to CLASS in java. NAME is the name of the business object and REVISION is similar to the version of the object.
Each business object identified with an object id. We can use object id instead of TYPE NAME REVISION.
Here we will see commonly used MQL commands in enovia.
MQL Commands:
MQL<1>print bus TYPE NAME REVISION;The print bus query is used to print business object details in mql console. It is used to print the properties of the business object.
MQL<2>print bus TYPE NAME REVISION select attribute.value;
This query is used to display all attribute values from the business object.
MQL<3>print bus TYPE NAME REVISION select attribute[ATTRIBUTE_NAME].value;
This query is used to display specific attribute value from the business object. Here you need to replace 'ATTRIBUTE_NAME' with actual attribute name.
MQL<4>temp query bus TYPE NAME REVISION;
temp query bus Query is used to get the multiple business objects details on mql console.
MQL<5>temp query bus Part * *;
Above query displays all the Part objects present in the database irrespective of name and revision.
MQL<6>expand bus TYPE NAME REVISION;
It is used to display the connected business objects. In this query, we can filter the connected object using type as well.
MQL<7>add bus TYPE NAME REVISION policy [POLICY_NAME] valut [VAULT_NAME];
This query is used to create a business object in enovia. Here policy governs the type and controls the behavior of the business object. Vault is the logical storage location for the business object.
MQL<8>mod bus TYPE NAME REVISION [ATTRIBUTE_NAME] [ATTRIBUTE_VALUE];
This query is used to modify the business object details like attribute values, owner, Originator and so on.
This query is used to display specific attribute value from the business object. Here you need to replace 'ATTRIBUTE_NAME' with actual attribute name.
MQL<4>temp query bus TYPE NAME REVISION;
temp query bus Query is used to get the multiple business objects details on mql console.
MQL<5>temp query bus Part * *;
Above query displays all the Part objects present in the database irrespective of name and revision.
MQL<6>expand bus TYPE NAME REVISION;
It is used to display the connected business objects. In this query, we can filter the connected object using type as well.
MQL<7>add bus TYPE NAME REVISION policy [POLICY_NAME] valut [VAULT_NAME];
This query is used to create a business object in enovia. Here policy governs the type and controls the behavior of the business object. Vault is the logical storage location for the business object.
MQL<8>mod bus TYPE NAME REVISION [ATTRIBUTE_NAME] [ATTRIBUTE_VALUE];
This query is used to modify the business object details like attribute values, owner, Originator and so on.
MQL<9>eval expression 'count true' on temp query bus TYPE * *;
This query is used to count the number objects for a particular type in enovia database.
👉ALL Interview Questions and Answers 💥
Click Here For All MQL Queries - Click Here
Please feel free to leave a comment below OR write us at plmdeveloper05@gmail.com for any MQL or Enovia related questions and Problems.
0 Comments