[Koha] SQL report in-case of repeatable tag

[vinod mishra]

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*