loop over subjects (in SQL report)
11 Dec
2016
11 Dec
'16
7:14 p.m.
Hi, I would like to list records by subject (in a SQL report). I can isolate the first subject in a record with ExtractValue(biblioitems.marcxml,'//datafield[substring(@tag,1,1) = "6"][1]/subfield[@code>="a"]') But then I need to perform a UNION DISTINCT with another SELECT addressing the second subject (with 2 replacing 1 between square brackets above), etc, when records can have a much larger number of subjects (MARC field starting with 6). Any suggestion? Thanks, Giuseppe.
3433
Age (days ago)
3433
Last active (days ago)
0 comments
1 participants
participants (1)
-
Giuseppe Angilella