Linking Fields

Avatar

Avatar

davidl14970702

Avatar

davidl14970702

davidl14970702

08-03-2018

I would like to set one field with an enumeration (on the left, below (@campaign_ministry_area)), and then have the selection be populated in another filed (on the right,webAnalytics/@tag1). I'm not 100% sure where to start.

But both fields are on my extension of the delivery table, in my own namespace.

The purpose of having both fields to is to set one within campaign, while the other gets processed to out web analytics account.

I feel like I can do something like this

<element externalJoin="true" label="Tag1" name="webAnalytics/@tag1" revLink="Delivery"

             target="lw:delivery" type="link">

      <join xpath-dst="@id" xpath-src="@Campaign_Minisitry_Area"/>

Any suggestions would be helpful.

Link Data.png

Replies

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

15-03-2018

Hey,

I did a quick test and you have used incorrect XPath for tag1, use this and it will work!

<postSave>

   <set expr="Coalesce(@Campaign_Minisitry_Area, '')" xpath="/ignored/writer/delivery/webAnalytics/@tag1"/>

      <set value="nms:delivery" xpath="/ignored/writer/delivery/@xtkschema"/>

      <set value="update" xpath="/ignored/writer/delivery/@_operation"/>

      <set expr="[@id]" xpath="/ignored/writer/delivery/@id"/>

      <soapCall name="Write" service="xtk:persist">

        <param exprIn="[/ignored/writer/delivery]" type="DOMDocument"/>

      </soapCall>

  </postSave>

Regards,

Amit

Avatar

Avatar

davidl14970702

Avatar

davidl14970702

davidl14970702

18-03-2018

I tried adding it and Im still not seeing it populate. Does the namespace matter at all? Should it be lw:delivery? Am I looking in the wrong spot?

Avatar

Avatar

pradeep_07

Avatar

pradeep_07

pradeep_07

13-07-2020

@Amit_Kumar - Even I have similar scenario and having same issue. were this issue solved ? Would you able to share the solution?

Avatar

Avatar

ManojK_Epsilon

Avatar

ManojK_Epsilon

ManojK_Epsilon

16-07-2020

Hello @davidl14970702 ,

 

Just use the below code to auto populate the tag1 value with Campaign Ministry Value

<enter>
    <set expr="Iif(@Campaign_Minisitry_Area==''),@Campaign_Ministry_Area ,'DEFAULT_VALUE_HERE')"   xpath="webAnalytics/@tag1"/>
</enter>

Let me know if this works.

 

Avatar

Avatar

syamsundaramara

Avatar

syamsundaramara

syamsundaramara

27-07-2020

@pradeep_07  is your issue solved?