[TYPO3] creating navigation from records list

[Cate & Peter]

Hi all

Thanks so very much to Jeff of WEC who managed to sort me out with this
problem - posted here for all to benefit.

My original problem:

I am trying to create a dynamic navigation of wiki pages. (Using DR Wiki
extension, wanting to pull the keyword field from the tables and list them,
linked to their relevant uid content.

Jeff's solution

[quote]
lib.myObject = CONTENT
lib.myObject{
  table = tx_drwiki_pages
  select {
    pidInList = this
    selectFields = pid,keyword
  }
  
  renderObj = TEXT
  renderObj {
    required=1
    
    # Displays the keyword inside the <li/> tags
    field = keyword
    
    # Inner wrap around individual rows
    wrap=<li class="leftnav">|</li>
    
    # Wraps the keyword with a link to the correct page
    typolink {
      # Links to the page that the wiki keyword is found on
      parameter.data = field:pid
      
      # Adds the keyword to the query string 
      additionalParams.wrap = &tx_drwiki_pi1[keyword]=|
      additionalParams.data = field:keyword
    }
  }
  
  # Outer wrap around all rows
  wrap = <ul class="nav"> | </ul>
}
[/quote]