List of items - two different values in one column of a table

0

Hello Sandra,

I think you need to use the UNPIVOT. Something along these lines should do:

SELECT AttributeName, AttributeValue
FROM (
SELECT WFD_AttText1, WFD_AttText2
FROM WFElements
) AS Source
UNPIVOT (
AttributeValue FOR AttributeName IN (WFD_AttText1, WFD_AttText2)
) AS UnpivotedData;

I haven't tested it but it should at least give you the direction.

Hi Sandra,

I read your question a few times, but I'm still not sure that I got it.

What I understood is the parent instance has:
Phone: +49 1347 541687
Mail: someone@example.com
and other fields

You want to populate an item list in a sub workflow with this data like this
Contact type | Value
_________________
Mail | someone@example.com
Phone | +491347

This makes more sense after you have looked at the picture.
select '1#Mail' as ContactType, {WFCONCOL:1798} as Value from WFElements where WFD_ID = PARENTWORKFLOWID
union
select '2#Phone' as ContactType, {WFCONCOL:1797} as Value from WFElements where WFD_ID = PARENTWORKFLOWID

@Martin
I have to look into this UNPIVOT function as I have no real idea what it does. :)

Best regards,
Daniel

Thanks, it works :)