Skip Form data when field matches specific value

tarad4225910

03-01-2020

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[*]

Accepted Solutions (0)

Answers (1)

Answers (1)

_Bruce_Robertson

MVP

07-01-2020

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