-
Title
I am using the ODBC query tool to try to query the Notes and Extended Notes metadata. Do you have any queries we can use for that? -
Description
I am using the ODBC query tool to try to query erwin Metamodel for the Notes and Extended Notes metadata. Do you have any queries we can use for that? -
Cause
question -
Resolution
For Notes:
/* ***********************************************
THIS WILL GET ONLY THE ENTITIES AND ATTRIBUTES
WHERE THEY HAVE NOTES
*********************************************** */
SELECT
E.NAME 'Entity Name',
TRAN(A.NAME) 'Attribute Name',
NL1.User_Text 'Entity Notes' ,
NL2.USER_TEXT 'Attribute Notes'
FROM
M0.NOTE_LIST NL1,
M0.NOTE_LIST NL2,
Entity E,
Attribute A
WHERE
E.ID@ = A.OWNER@ AND
E.ID@ = NL1.ID@ AND
A.ID@ = NL2.ID@
/* ***********************************************
THIS WILL GET ALL THE ENTITIES AND ATTRIBUTES
WHETHER THEY HAVE NOTES ARE OR NOT
*********************************************** */
SELECT DISTINCT
E.NAME 'Entity Name',
TRAN(A.NAME) 'Attribute Name',
NL1.User_Text 'Entity Notes' ,
NL2.USER_TEXT 'Attribute Notes'
FROM
Entity E
Left JOIN Attribute A
ON A.OWNER@ = E.ID@
Left JOIN NOTE_LIST NL1
ON E.ID@ = NL1.ID@
Left JOIN NOTE_LIST NL2
ON A.ID@ = NL2.ID@
============
For Extended Notes:
/* ***********************************************
THIS WILL GET ONLY THE ENTITIES AND ATTRIBUTES
WHERE THEY HAVE EXTENDED NOTES
*********************************************** */
SELECT
E.NAME 'Entity Name',
TRAN(A.NAME) 'Attribute Name',
EN1.COMMENT 'Entity Extended Notes' ,
EN2.COMMENT 'Attribute Extended Notes'
FROM
M0.EXTENDED_NOTES EN1,
M0.EXTENDED_NOTES EN2,
Entity E,
Attribute A
WHERE
E.ID@ = A.OWNER@ AND
E.ID@ = EN1.OWNER@ AND
A.ID@ = EN2.OWNER@
/* ***********************************************
THIS WILL GET ALL THE ENTITIES AND ATTRIBUTES
WHETHER THEY HAVE EXTENDED NOTES ARE OR NOT
*********************************************** */
SELECT DISTINCT
E.NAME 'Entity Name',
TRAN(A.NAME) 'Attribute Name',
EN1.COMMENT 'Entity Extended Notes' ,
EN2.COMMENT 'Attribute Extended Notes'
FROM
Entity E
Left JOIN Attribute A
ON A.OWNER@ = E.ID@
Left JOIN EXTENDED_NOTES EN1
ON E.ID@ = EN1.Owner@
Left JOIN EXTENDED_NOTES EN2
ON A.ID@ = EN2.OWNER@