Mapper Properties - backend field

Rhythmyx Technical Discussion
1

Hi there,

Is there a way of concatenating two field in the xml mapper properites using ‘sys_Lookup/PSXEntry/PSXDisplayText’?
At the moment i am pulling through a title but would like to display the content id aswell.

This is for a lookup application (support_ce) used in a dropdown on the content editor.

Thanks in advance

Lisa

2

Lisa,
When I want to concatenate two fields in an XML application, rather that using the mapper, I do it in the SQL statement itself. e.g. Select field1 + field2 as myField, field3, field4… etc. Then in the mapper i work with “myField”

Duane

3

Hmm - ok thanks - i will give that a go.

4

In the end i found a user defined ‘sysConcat’ function that allowed me to display two backend fields in the dropdown.