Expand my Community achievements bar.

Data connection filter

Avatar

Level 1

Hi,

We currently working with a PDF template combined with a data connection to an xsd input file. In the corresponding xml we have the following code:

<ListOfCwiWerkzoekendeKnelpunten>
  <CwiWerkzoekendeKnelpunten>
    <Type>Loonkost</Type>
    <Planned>01-Juni-2011</Planned>
    <PlannedCompletion>31-Juni-2011</PlannedCompletion>     
    <Comment2>Dit is een toelichting</Comment2>
  </CwiWerkzoekendeKnelpunten>
  <CwiWerkzoekendeKnelpunten>
    <Type>Subsidie</Type>
    <Planned>01-Juni-2012</Planned>
    <PlannedCompletion>31-Juni-2012</PlannedCompletion>
    <Comment2>Dit is een extra toelichting bij Subsidie</Comment2>
  </CwiWerkzoekendeKnelpunten>
</ListOfCwiWerkzoekendeKnelpunten>

As you can see we have 2 sets of data. We want to filter only on Type = "Loonkost"

The binding for the Type field is:

$record.Contact[*].ListOfCwiDvp.CwiDvp[*].ListOfCwiWerkzoekendeKnelpunten.CwiWerkzoekendeKnelpunten[*]

Is there a way to do this in script, or in default binding or another solution?

We have tried to change the default binding in:

$record.Contact[*].ListOfCwiDvp.CwiDvp[*].ListOfCwiWerkzoekendeKnelpunten.CwiWerkzoekendeKnelpunten[Type = "Loonkost"]

This doesn't work because we think an integer is expected (because of the array)).

Modify our input xml is no option.

Thanks in advance for helping us out

0 Replies