I try to read the values of a category.
It works fine, if I read text fields, integer fiels etc.
For example a textvalue with category attribute=7
select distinct
d.name as "Dokumentname",
d.Dataid AS "DataID",
d.versionnum as "Current version number Dok",
dv.version as "Version number",
dv.Filename as "Filename of version",
ll_01.ValStr as "Categoryvalue" from DTree d
left join dversdata dv on d.dataid = dv.docid
left JOIN llattrdata ON d.Dataid=llattrdata.ID AND llattrdata.defid=65018633 /* Category XYZ*/
LEFT JOIN llattrdata ll_01 ON d.dataID = ll_01.ID AND ll_01.VerNum=dv.version and ll_01.attrid = 7 AND ll_01.defid=65018633
where [...]
but I don't know, how to read a multivalue field...
I have tried it with ll_01.ValLong but there is only "null" written, although there are text inside.
Has anybody a helpful hint how to print out the the whole multivalue?
Thank you in advance
Isa