Help with versions and llattrdata table...

unknown

Message from Sean M Alderman via eLinkGang, I've been working with the llattrdata table to create a custom modulethat displays documents based on their attribute values and whatcategory they belong to. I've run into something that I need someexplanation on...I've noticed that when you change the attribute values assigned to adocument, it appears that a new version of the document is createdwithin the llattrdata table. Is this supposed to happen? My basicproblem is that when I run a query like:select id from llattrdata where defid = andvalstr = '';or evenselect id, max(vernum) from llattrdata where defid = andvalstr = '' group by id;I results that contain several instances of the same ID. In looking atthe database I see that each time I change the attribute value(s) for anode there is a new record in the llattrdata table withllattrdata.vernum incremented. Does anyone know how I might figure out in a sql query how to get themost current version of the document's attributes? BTW, thellattrdata.vernum does not coicide with the dtree.versionnum value (evenif it did, the point of doing the query from the llattrdata table is sothat I can get the ID and then use it to query against the webnodes view(which is mostly dtree fields).-- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795