Multi-element View: Schematic Equipment/Pipe Connectivity

The following view contains rows that show the connectivity between schematic Equipment and schematic pipelines. This uses Source Elements to navigate from element to element. All columns could be made writeable.

Example:

NEW DBVW

DESC 'Connectivity between schematic equipment and schematic pipelines'

UDNA 'SCEQUI to SCPLINE connectivity'

ELEL ADD SCNOZZ

NEW ATTFILTER

DBATTRIBUTE CREF

FILTOPERATOR 'DoesNotEqual'

FILTVALUE 'Nulref'

END

NEW ATTCOLUMN

DBATTRIBUTE NAME

UDNA 'Nozzle'

READONLY true

END

NEW SRCELEMENT

DESC 'Schematic Equipment'

EXPRESSION 'OWNER'

EXPTYPE 'PML'

NEW ATTCOLUMN

DBATTRIBUTE NAME

UDNA 'Equipment'

READONLY true

END

END

NEW SRCELEMENT

DESC 'Schematic Branch'

EXPRESSION 'CREF'

EXPTYPE 'PML'

NEW ATTCOLUMN

DBATTRIBUTE NAME

UDNA 'Branch'

READONLY true

END

NEW SRCELEMENT

DESC 'Schematic Pipeline'

EXPRESSION 'OWNER'

EXPTYPE 'PML'

NEW ATTCOLUMN

DBATTRIBUTE NAME

UDNA 'Pipeline'

READONLY true

END

END

END

END

Since the data for this Database View is not available in Lexicon the Database View must be shown by using the Database Views Editor or the Reporting interface in a schematic module. A report is shown below that has been based on the view defined above.