LiveReport using MS SQL to locate items with specific cat/atts.

Samantha_Whelan

I need to create a LiveReport using MS SQL that will locate items with specific category and attribute data. The report should allow the user to filter data. The attributes are multivalues, Text Lookups and checkboxes. The report would list the latest documents that meet the filter criteria.I am relatively new to MS SQL and Livelink 9.7 and would appreciate any assistance.Thanks, Sam

Appu_Nair

The category/attribute data representation is extremely complicated for a beginner.Here's an easy way to attack ithttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3498953&objAction=ArticleView&viewType=1But the jist of what you will be doing can be surmised by this.Let's say you have a category called myCat with five attributes text,integer,text,integer,date.If you apply this now to a document on llattrblobdata table this structure will be written and for "easy" reporting six rows of data will be written.The article is trying to flatten the 'n' number of rows into a single view.Start with some small data set and you should see light.Once you create a view for your category then other people can use it like a table (select * from myview).Once you get it it is very very easy..Beleive me it is fun....OpenText BI introduces a different approach by uaing a function to do this and is by far the better of the two approaches.If you want to take that route talk to your sales rep for a copy of the OT BI module.