How To Use The SQL Interpreter in Cube-IQ

Overview

SQL commands are useful to get customized information from Cube-IQ's database.

Requirements

One of the following:

1. Cube-IQ license.
2. Cube-IQ web license.

Procedure

Main Tables would consist of the following:

• Loads
• Products
• Containers
• ContainersToLoad
• ProductsToLoad
• LoadedContainers
• Settings
• Stages
• StackMatrix
• Blocks

SQL Interpreter

1. To open the SQL Interpreter:
   1. Open Cube-IQ.
   2. Log in.
   3. Select Options > Other > SQL Interpreter
       
2. Write and Execute commands:
   1. Commands are entered at the top.
   2. Then click the Execute button.
       
3. Results are shown below.
    
4.  All the usual text commands are available on a right-click (select, copy, delete).
    

NOTE:

Results can be saved as a csv file using the delimiter selected, just click on the the Save Results button.

Assistance

If any further assistance is needed, please contact our Support team.

Related Articles