Hello
Please help, how to generate sql reports if there is repeatable field
having 2 or more data and get the report under two different rows for the
repeatable field?
Example: If there are more than two URL is given and i wish to get report
in two columns and rest of the data in one column only:
Tag 245a Tag 100a Tag856u Tag856y Tag8563
Tag856u Tag856y Tag8563
Tag856u Tag856y Tag8563
<datafield tag="856" ind1="4" ind2="0">
<subfield code="3">ScienceDirect</subfield>
<subfield code="u">
http://www.sciencedirect.com/science/book/9780123694157</subfield>
<subfield code="y">testing link</subfield>
</datafield>
<datafield tag="856" ind1="4" ind2="0">
<subfield code="3">test</subfield>
<subfield code="u">
http://www.sciencedirect.com/science/book/9780123694157</subfield>
<subfield code="y">ok test</subfield>
</datafield>
With Regards,
Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
ORCID ID: http://orcid.org/0000-0003-4666-7874
*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
