Sorry appnair, I must appear awfully stupid, but can't quite understand the Opentext doc.
Iv'e done the query
select catid, catname, attrname, regionname from catregionmap where catname = 'Dokumetregistering';
and get:
CATID CATNAME ATTRNAME REGIONNAME
467122 Dokumetregistering Dokument ID nr. Attr_467122_2
467122 Dokumetregistering Titel Attr_467122_4
467122 Dokumetregistering Dokument dato Attr_467122_5
467122 Dokumetregistering Version nr. Attr_467122_6
467122 Dokumetregistering Forµldet dato Attr_467122_7
467122 Dokumetregistering Dokument udarbejder Attr_467122_8
467122 Dokumetregistering Medie Attr_467122_9
467122 Dokumetregistering Leveringsform Attr_467122_10
467122 Dokumetregistering Referance (f°lgebrev nr.) Attr_467122_11
467122 Dokumetregistering Kommentar Attr_467122_12
467122 Dokumetregistering Omfang /eksemplar/antal sider Attr_467122_13
467122 Dokumetregistering Dokument Type Attr_467122_14
then it says 'create or replace view newcattbl (dataid, Location, Rating, Coop, Skill, SkillYears, Education) as
select a.id, a.valstr, b.valstr, c.valint, d.valstr, e.valint, f.valstr from LLAttrData a, LLAttrData b, LLAttrData c, LLAttrData d, LLAttrData e, LLAttrData f, DTree t where
(t.DataID=a.ID and a.DefID=467122 and a.AttrID=2 and t.VersionNum=a.VerNum) and
(t.DataID=b.ID and b.DefID=467122 and b.AttrID=3 and t.VersionNum=b.VerNum) and
(t.DataID=c.ID and c.DefID=467122 and c.AttrID=4 and t.VersionNum=c.VerNum) and
(t.DataID=d.ID and d.DefID=467122 and d.AttrID=8 and t.VersionNum=d.VerNum) and
(t.DataID=e.ID and e.DefID=467122 and e.AttrID=9 and t.VersionNum=e.VerNum) and
(t.DataID=f.ID and f.DefID=467122 and f.AttrID=6 and t.VersionNum=f.VerNum);
Replace the "467122" with the value of CATID from the query you did in step 1 (done this).
but I'm stuck what it meams when it says:
"Replace the attribute Ids with those from your query."
Could anyone show me how this should appear in the above query?