Tuesday, March 9, 2010

Speeding up a Livelink Web Report

Slow-as-molasses Livelink Web Report??? Try using a saved search as your data source. "But I have a bunch of attributes as my starting filters," you say. You can work through that too... Example:

  1. Go to Advanced search.
  2. Do a full text search.
  3. Look for All words
  4. Find out what the actual field name of the attributes you want to search for are (Attr_####_##). This information is found in a table in the database. I'm not going to mention the actual name because I don't know what legal issues this post can cause. It rhymes with fatregionnap.
  5. Build your advanced query like so: Attr_33353557_3:%2 AND Attr_33353557_4:%3 AND Attr_33353557_6:%4 AND Attr_33353557_12:%5 AND Attr_33353557_11:%6 AND Attr_33353557_10:%7 AND Attr_33353557_20:%8 AND Attr_33353557_2:%9 AND Attr_33353557_19:%10 AND OTSubType:144
  6. The above will get you specifically documents that have two categories and the values you pass into attribute parameters. The middle number in those field names are the actual category id.
  7. Optionally, to speed up the results even more, Add a scope to the search. 
  8. Save it.
  9. Reference it in the Web Report.
  10. Format your web report as you would.

I will post more on building an entire web report with this data source pull method later on.

1 comments:

RHYTHM OF LIFE said...

Can you guide me more on this that is a complete example.

Post a Comment