LEXICON Command
Reference Manual
Database Views
:
Example Database Views
: Multi-element View : Schematic Equipment/Pipe Connectivity
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.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
