Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Skip Form data when field matches specific value

Avatar

Level 1

My current form with a table which displays all the Item/Product data for every line, even when an item it deleted giving it an ActionCode of 3. We'd like to only display the Item Data if the Action != 3.

 

Here is the partial XML Data

<Item>
<ID>1</ID>
<ActionCode>03</ActionCode>
<ActionCodeName/>
<Product>
<StandardID schemeAgencyID=" ">614099641183</StandardID>
<StandardID schemeAgencyID="9">614099641183</StandardID>
<BuyerID>ASH10066-AC</BuyerID>
<BillToID>ASH10066-AC</BillToID>
<TypeCode>1</TypeCode>
<TypeName languageCode="EN">Material</TypeName>
</Product>
<ProductCategory>
<BuyerID>11500</BuyerID>
<BillToID>11500</BillToID>
<Description languageCode="EN">HOME ACCESSORIES</Description>
</ProductCategory>
<Price>
<GrossAmount currencyCode="USD">122.70</GrossAmount>
<NetAmount currencyCode="USD">122.70</NetAmount>
<TaxAmount currencyCode="USD">0.00</TaxAmount>
<NetUnitPrice>
<Amount currencyCode="USD">20.45</Amount>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityMeasureUnitName languageCode="EN">ea</BaseQuantityMeasureUnitName>
</NetUnitPrice>
</Price>

 

 

And Here is the current Data binding for the table 

$.PurchaseOrder.Item[*]

2 Replies

Avatar

Level 10

Hi,

 

You can use an expression in the binding, so try

 

$.PurchaseOrder.Item.[ActionCode <> "03"]

 

Note the full stop should be before the opening square bracket.

 

Regards

 

Bruce

 

Avatar

Level 10

Hi,

 

You can use an expression in the binding, so try

 

$.PurchaseOrder.Item.[ActionCode <> "03"]

 

Note the full stop should be before the opening square bracket.

 

Regards

 

Bruce