Commonly used Enovia MQL Queries | MQL Commands | Enovia

MQL (Matrix Query Language) is an interface allows administrators to interact with enovia database. MQL is similar to SQL for 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.




Enovia MQL Commands:

Here we will see commonly used MQL commands in enovia.


Q. MQL query to print business object.

A. pri bus TYPE OBJ_NAME OBJ_REVISION;

MQL<1>pri bus Part A-CV-001 1;

Q. MQL query to print all attribute values in a business object
A. pri bus TYPE OBJ_NAME OBJ_REVISION select attribute.value;

  
MQL<2>pri bus Part A-CV-001 1 select attribute.value;

Q. MQL query to print specific attribute value in a business object.
A. pri bus TYPE OBJ_NAME OBJ_REVISION select attribute[Count].value;


MQL<3>pri bus Part A-CV-001 1 select attribute[Count].value;

Q. Checkin a file into a business object in enovia from mql
A.  checkin bus TYPE NAME REVISION D:\Files\ABC.txt


MQL<4>checkin bus Part A-CV-001 1 D:\Files\ABC.txt;
 
Q. Checkout file from a business object in enovia using mql
A. checkout bus TYPE NAME REVISION D:\Files\ABC;


MQL<5>checkout bus Part A-CD-001 1 D:\Files\ABC;

Q. MQL command to add the license to a user in envoia
A. mod product PRODUCT_NAME add person USER_NAME;


MQL<6>mod product EXE add person Chetan;

Q. Enovia MQL query to add program or jpo into database
A. insert program PROGRAM_NAME (with path)


MQL<7> insert prog D:\JPO\Part_mxJPO.java;

Q. Enovia MQL query to compile program
A. compile prog PROGRAM_NAME force compile;


MQL<8> compile prog Part force compile;
 
Q. MQL query to execute a program in enovia
A. execute program PROGRAM_NAME;

Note:- If you execute the program by using above command by default it will start execution from the mxMain method.

MQL<9>execute program Part;

Q. MQL query to execute a specific method in enovia
A. execute program PROGRAM_NAME -method METHOD_NAME;

Note:-If you execute the program by using the above command by default it will start execution from the desired method and we can pass the command line arguments as well.

MQL<9>execute program Part -method executeTCL;

Q. MQL Query to modify access for a user in enovia
A. mod person PERSON_NAME type ACCESS_TYPE;


MQL<10>mod person Chetan type business;
MQL<11>mod person Chetan type full;


Q. MQL Query to modify access for a user in enovia
A. mod person PERSON_NAME access ACCESS_TYPE;


MQL<12>mod person Chetan type create, read, show;
MQL<13>mod person Chetan type create,read,show,checkin,fromconnect;
 
Q. MQL query to print roles of a user in envoia
A. print person PERSON_NAME select assignment


MQL<14>pri person Chetan select assignment;


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.

Post a Comment

0 Comments