Category & Attributes LiveReport

Mary_Slane_Corona

I have recently modified an existing Category. I added new attributes to it and deleted several existing attributes that were no longer needed. Also the required attributes are different from the earlier version. I have modified a livereport that I found on the Knowledge center to bring certain documents that have the Category applied to it that meet certain attribute requirements.Problem:It will only find new documents—it will not pull up any existing documents from the upgraded category. I can run another existing Livereport and it will pull up documents where the category hasn’t been upgraded yet, documents that the category has been upgraded and the new documents that have been added. I am including an attachment that shows the Livereport edit page. Note: I also did an Advance Search using the Category and it brought up all of the documents that fit the query--not just new documents.SQL for the LiveReportSELECT dtree.dataid, dtree.SubType, dtree.GIF, dtree.PermID, dtree.Reserved, dtree.ReservedBy, dtree.name, kuaf.name "Owner", a.valdate "Docreview", b.valstr "Docnum", c.valstr "Facility", d.valint, e.valint "Number", f.valstr "Dept" FROM dtree, kuaf, llattrdata a, llattrdata b, llattrdata c, llattrdata d, llattrdata e, llattrdata f WHERE kuaf.id = d.valint and (a.valdate >= %1 and a.valdate <= %2 and a.defid = 862314 and a.attrid = 10 and dtree.subtype = 144 and a.id = dtree.dataid and a.vernum = dtree.versionnum) and (b.defid = 862314 and b.attrid = 12 and dtree.subtype = 144 and b.id = dtree.dataid and b.vernum = dtree.versionnum) and (c.defid = 862314 and c.attrid = 6 and c.valstr = 'Corporate' and dtree.subtype = 144 and c.id = dtree.dataid and c.vernum = dtree.versionnum) and (d.defid = 862314 and d.attrid = 22 and dtree.subtype = 144 and d.id = dtree.dataid and d.vernum = dtree.versionnum) and (e.defid = 862314 and e.attrid = 26 and dtree.subtype = 144 and e.id = dtree.dataid and e.vernum = dtree.versionnum) and (f.defid = 862314 and f.attrid = 5 and dtree.subtype = 144 and f.id = dtree.dataid and f.vernum = dtree.versionnum) ORDER by a.valdate

Martin_Gäckler

You are using several attribute ids. If these ids did not exist in the old version of your category, you will never find any old document.Without knowing your category definitions, its hard to find a solution.