Skip to content

OctoSAM query concepts (preview)

OctoSAM queries are used throughout OctoSAM whenever data needs to be presented in a tabular form.

Naming conventions

Columns in grids keep their database names whenever possible.

PrintableName column

Many tables have a PrintableName column. The values are constructed by OctoSAM based on other key columns of the table. The PrintableName is the name that is often shown for objects outside the grid. Within grids, the column usually has the name of the main object. For example, Machine.PrintableName is displayed as Machine.

CurrentDateTime column

Most queries contain a hidden CurrentDateTime column that contains the start time of the query

Dummy column

Some queries need a Dummy column to make sure the SQL syntax stays valid even with variable number of columns. This column is usually not displayed at all.

Query performance aspects

Performance of a query depends on the amount of data selected, the complexity of the query and the configuration of the database.

Keep indexes current

Consult with your DBA on strategies to keep indexes and statistics up-to-date.