dokuwiki

   <table>
    <tr height="100px">
      <td colspan="2" valign="top" style="padding-right:10px">
         <a target="_blank" tal:attributes="href python:'./'+here.filename+'/zogilib_zsql?fn='+here.ImageViewerPath+'/'+here.filename">	
            <span tal:replace="structure here/REQUEST/SESSION/string"/>
         </a>
      </td>
      
      <!-- see note 1 -->
      <tal:block tal:repeat="foundMD python:here.ZSQLInlineSearch(_table='tablename',idfield=here.filename,_op_idfield='eq')">
      <span tal:condition="not:python:here.ZSQLisEmpty(foundMD.text)">
         <td valign="top" tal:content="python:here.decode(foundMD.text)"/>
      </span>
      <!-- /note 1 -->
      
      <!-- see note 2 
      <tr tal:condition="not:python:here.ZSQLisEmpty(foundMD.object_title)">
         <td class="fieldname">Title: </td>
         <td tal:content="python:here.decode(foundMD.object_title)"/>
      </tr>
      <tr tal:condition="not:python:here.ZSQLisEmpty(foundMD.inscription)">
         <td  class="fieldname">Description: </td>
         <td tal:content="python:here.decode(foundMD.inscription)"/>
      </tr>
      <tr tal:condition="not:python:here.ZSQLisEmpty(foundMD.property)">
         <td class="fieldname">Copyright: </td>
         <td tal:content="python:here.decode(foundMD.property)"/>
      </tr>
      -->
      <!-- this is a second database query, use this section if you want a secondary search in another database
      <tr tal:repeat="foundBooks python:here.ZSQLInlineSearch(_table='vision_lit',id=foundMD.id_book,_op_id='eq')" >
         <td>
            <a tal:condition="python:here.checkResource(foundBooks.ordnername)" tal:attributes="href python:here.checkResource(foundBooks.ordnername)[0][1].absolute_url()" target="_blank">show source</a>
         </td>
      </tr>
      -->
      </tal:block>
    </tr>
   </table>

Note 1

The function ZSQLInlineSearch searches in the table given (here tablename) in the field given (here idfield) for the specified expression (here here.filename). If you don't change the specified expression, the given field is searched for the name of the image.

Replace tablename with the name of your table.
Replace idfield with the name of the field that holdes the image names/ image ids.
_op_idfield specifies the type of comparison (e.g. equals (eq), contains (ct), …)
In foundMD.text replace text with the name of the field you want to be displayed.

Note 2

If you want more than one field to be displayed, comment in this section and replace foundMD.whatever with the appropriate fieldnames of the fields.