Find mapping between attributes of agile schema and ODM
Hi All,
I have been working on finding a way via an sql query to show which attribute is being mapped on which column in ODM database. So far I was able to write the following query.
SELECT *
FROM (SELECT DISTINCT oe.class_id,
oe.att_name,
oe.att_type,
oe.maxlength,
oe.tab,
pt.parentid,
pt.description
FROM ODM_ATTR_METADATA OE, nodetable@agile9 pt
WHERE OE.CLASS_ID = pt.parentid)
WHERE 1 = 1
My question is, how can I check that the query’s result is correct and if it is not can anybody tell me where I am doing it wrong.
BurhanBKB,
Did you resolve this? And if yes, what did you find out? Could you leave some insight for us here?
