SELECT.XML & Allow Multiple Features

Owned by Morten Lindequist Køhler
Feb 14, 2024
1 min read

The purpose of this Action example is to illustrate how to use SELECT.XML and Allow Multiple Features

This example is provided as inspiration only. It must be adapted to your Perfion environment to work. Perfion Support does not assist with such adaptations. Please contact your Perfion Partner or your Perfion consultant if you need assistance.

 

An importable example of the action can be found here: 

Sample data for building Action Map

Data must be adapted to your Perfion enviroment to work 

From

To

Command

Action

Script

Notes

From

To

Command

Action

Script

Notes

.

xml_product

SELECT.PERFION

 

<Query>
<Select languages='EN'>
<Feature id='Multivaluefeature' view='Config' />
<Feature id='itemname' view='Config' />
</Select>
<From id='100' />
<Where>
<Clause id='MultiValueFeature' operator='HAS' />
</Where>
</Query>

Select Products which has MultiValueFeature

xml_product

tbl_product

SELECT.XML

 

 

 

/Product/*

@Context

 

 

 

Use the Product/* as context to get all features as rows

.

 

 

 

 

Get Value of each feature 

./../Value/.

 

 

 

 

Get xml-Value of the Value node (base feature of the select)

tbl_product

tbl_formatted

SELECT.UNIQUE

 

 

Use AppendOutValue(); to format the above result to traditional DataTable

Value

 

 

 

 

Use Value as key

*

 

 

 

AppendOutValue();

Use AppendOutValue(); to format