[Isis-users] Print report for multiple databases

[Piet De Keyser]

Soraya,

I am afraid it still is not very clear what you want to do. Do you want:


  *   to list all data from two databases in one list?
  *   to make a list from e.g. which records contain the word “water” in the title in both databases?
  *   to list data from database A and for each record retrieve some corresponding data from database B (comparable with what happens in relational databases)?
  *   …

Piet de Keyser
Belgium


Van: isis-users <isis-users-bounces+piet.dekeyser=ucll.be at iccisis.org> Namens Soraya Ferraz Lima
Verzonden: maandag 11 mei 2020 23:33
Aan: Egbert De Smet <egbert.desmet at uantwerpen.be>
CC: Lista Isis <isis-users at iccisis.org>
Onderwerp: Re: [Isis-users] Print report for multiple databases

Hi Egbert!
Thanks for your reply.

I want to use this function
[image.png]
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.
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.

I hope I was clear now.
Thanks!

Em seg., 11 de mai. de 2020 às 17:40, Egbert De Smet <egbert.desmet at uantwerpen.be<mailto:egbert.desmet at uantwerpen.be>> escreveu:

Hi,



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).

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.



Could you perhaps explain better what you want ?


Egbert de Smet
Universiteit Antwerpen

________________________________
From: isis-users <isis-users-bounces+egbert.desmet=ua.ac.be at iccisis.org<mailto:ua.ac.be at iccisis.org>> on behalf of Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>>
Sent: Monday, May 11, 2020 8:40 PM
To: Lista Isis
Subject: [Isis-users] Print report for multiple databases

Hello all!

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.

I tried to use the ref feature, but only the first record of the base is displayed.
Here is the format I used from the catalog base:

'<tr>'
'<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then ' ',fi,'</td>'/
'<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/
'</tr>'

ref->tridi(l->tridi('BASE=TRIDI'),
  '<tr>'
'<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then ' ',fi,'</td>'/
'<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/
'</tr>')

OBS. I have the 'BASE=TRIDI' configured in the fst of tridi database.

Is there any way to make the ref recursive or some other way to build this format?

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20200512/a81c4deb/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9316 bytes
Desc: image001.png
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20200512/a81c4deb/attachment.png>