<div dir="ltr">Hi Egbert!<div>Thanks for your reply.</div><div><br></div><div>I want to use this function</div><div><div><img src="cid:ii_ka2zyypj0" alt="image.png" width="305" height="171"><br></div></div><div>to show data of my two databases. When I select a database (in this case ACERVO [catalog]) the report format only shows data of this database. I want to "combine" the data of catalog and tridi in a format.</div><div>I like I said, the ref function only shows the first record of tridi and I would like to show data for all of its records.</div><div><br></div><div>I hope I was clear now.</div><div>Thanks!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em seg., 11 de mai. de 2020 às 17:40, Egbert De Smet <<a href="mailto:egbert.desmet@uantwerpen.be">egbert.desmet@uantwerpen.be</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div id="gmail-m_-9116797418747260820divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);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="gmail-m_-9116797418747260820Signature">
<div><font size="2"><span style="font-size:10pt">
<div>Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr style="display:inline-block;width:98%">
<div id="gmail-m_-9116797418747260820divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> isis-users <isis-users-bounces+egbert.desmet=<a href="mailto:ua.ac.be@iccisis.org" target="_blank">ua.ac.be@iccisis.org</a>> on behalf of Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" target="_blank">soyferrazlima@gmail.com</a>><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>
</div>
</blockquote></div>