LEXICON Command
Reference Manual
Database Views
: Example Database Views
Example Database Views
UDA Administration View : Real UDAs without Dimension
The following view contains a list of UDAs that have UTYPE set to REAL but have no dimension assigned for unit of measure qualification.
Example:
NEW DBVW
UDNA 'UDAs : Reals without Dimension'
ELEL ADD UDA
NEW ATTFILTER
DBATTRIBUTE UTYP
FILTOPERATOR 'Equals'
FILTVALUE 'REAL'
END
NEW ATTFILTER
DBATTRIBUTE UUNI
FILTOPERATOR 'Equals'
FILTVALUE 'NONE'
END
NEW ATTCOLUMN
DBATTRIBUTE UDNA
END
NEW ATTCOLUMN
DBATTRIBUTE NAME
END
NEW ATTCOLUMN
DBATTRIBUTE OWNER
UDNA 'UGROUP'
READONLY true
END
END
Since the Data content of this example is available from within LEXICON the results can be seen immediately using the Database Views Editor.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
