<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Hi,</p>
<p><br>
</p>
<p>I is not fully clear to me what you want, at least not from you description. But what you are doing is this : you use the 'L'(ookup) function to identify in the TRIDI database the first posting (and only the first) for the key 'BASE=TRIDI' and from that
record you retrieve some fields like v245 and v650 (title and descriptors).</p>
<p>Normally the key used with the L-function would not be a fixed one, but one constructed by a value (preceded by your prefix) from the actual record (in the catalog database). Now, with a fixed key, all REF-operations will go to the same (first) posting of
the TRIDI-database.</p>
<p><br>
</p>
<p>Could you perhaps explain better what you want ?</p>
<p><br>
</p>
<div id="Signature">
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> isis-users <isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org> on behalf of Soraya Ferraz Lima <soyferrazlima@gmail.com><br>
<b>Sent:</b> Monday, May 11, 2020 8:40 PM<br>
<b>To:</b> Lista Isis<br>
<b>Subject:</b> [Isis-users] Print report for multiple databases</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hello all!<br>
<br>
I have two databases (catalog and tridi) and I would like to print a report with the data from the two databases using the print feature.<br>
<br>
I tried to use the ref feature, but only the first record of the base is displayed.<br>
Here is the format I used from the catalog base:<br>
<br>
'<tr>'<br>
<div>'<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then ' ',fi,'</td>'/<br>
'<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/</div>
<div>'</tr>'</div>
<div><br>
</div>
<div>ref->tridi(l->tridi('BASE=TRIDI'),<br>
'<tr>'<br>
<div>'<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then ' ',fi,'</td>'/<br>
'<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/</div>
<div>'</tr>')</div>
<div><br>
</div>
OBS. I have the 'BASE=TRIDI' configured in the fst of tridi database.</div>
<div><br>
Is there any way to make the ref recursive or some other way to build this format?<br>
</div>
<div><br>
</div>
<div>Thanks!</div>
</div>
</div>
</div>
</div>
</body>
</html>