Document and RM attributes within a report

Craig_Stanley

I have a requirement to pull together both document attributes and record details for a set of documents covered by our records management project. The requirement is to create a view showing all Attribute details and some selected RM details. We are going to then use this view for a custom search requirement. Where do I find the tables that shows which RSI is attached to each document? I cannot seem to see where this found. Does RM_MULTICLASS refer only to those items with multiple classifications ? This is the code so far. The missing bits are the relevent RSI details. Any assistance is much appreciatedSELECT MAX( case when llattrdata.attrid = 8 then llattrdata.valstr end) As Business_ID,MAX( case when llattrdata.attrid = 2 then llattrdata.valstr end) As Business_Function,MAX( case when llattrdata.attrid = 3 then llattrdata.valstr end) As Activity,MAX( case when llattrdata.attrid = 4 then llattrdata.valstr end) As Transaction_,MAX( case when llattrdata.attrid = 5 then llattrdata.valstr end) As Document_Type,MAX( case when llattrdata.attrid = 6 then llattrdata.valstr end) As Reference_,MAX( case when llattrdata.attrid = 9 then llattrdata.valstr end) As Detail,dtree.name,trunc (dtree.createdate) Date_Created,dtree.dataidFROM llattrdata, dtree where subtype=144 anddtree.dataid = llattrdata.id and defid=48617205GROUP BY llattrdata.id,dtree.createdate,dtree.name,dtree.dataidorder by 2,3,4,5,6,7,9 ascCraig Stanley Information ServicesNorthumbrian Water craig.stanley@nwl.co.uk