Issue_Data has no foregn key to DTree

Eric_Slaghuis_(sasoladmin_-_(deleted))

As part of the Livelink for corporate governance solution, an issue object is delivered. This issue object type is defined in DTree. Reading the administartion guide carefully it states that the primary key for the issue_data table is issue_nr. The issue_data table however also has a dataid field. This dataid field is however not a foriegn key to dtree.dataid. The sample Livereports do however assume this! In some cases is is, but definitely not all cases.The only link I can make from dtree to issue_data is by parsing the ExtendedData field in DTree for issue_nr. Here is a sampleA<1,?,'Category'='Missing Controls','Impact'='Leave may be taken that is not captured on the system leading to financial loss to the company.','IssueNumber'='0000311','Milestone'='TargetDate','mitigatingItemDescription'='GHRSS task team to provide group wide controls.','mitigatingItemExists'=true,'Organization'='Sasol Technology','OutlineResolution'='Awareness campaign to inform management of the importance of proper leave management.','RootCauses'='Underestimation of the importance of proper leave management.'>. Any takers? Is someone willing to assist me to parse the ExtendedData field for Issue_nr, that i can do a join on the result between DTree and issue_data.issue_nrPlease I need help on this one.