Introduction › Most Frequently Referenced Views › MODEL View

MODEL View

Every model contains a row in the MODEL view that can be joined to all other Public Interface views within the model. The MODEL view is used for model identification. In each database query, you must identify the model that contains the information you want to retrieve. The two columns in the MODEL view are:

• ID-A unique identifier of the model across the encyclopedia.
• Name-Encyclopedia name of the model.

To restrict the query selection to objects in a single model, join the unique identifier of the model-ID-and the Model_ID of the objects desired.

The following query selects all rows from a view for model “my model name.”

SELECT *
FROM
MODEL M,
viewname V
WHERE
M.NAME='my model name'
AND V.MODEL_ID=M.ID;