Inhaltsverzeichnis

SelectDistinct

The SelectDistinct function allows you to return only one value from duplicate values. The same values must be in the same document. Otherwise, use SelectDistinctValues.

Note: Attributes to be filtered are without @, see example!

Syntax:

SelectDistinct('Node/SubNode', 'Attribut', 'SortAttribute')

Sample:

SelectDistinct('Pricat/Position', 'EAN')
SelectDistinct('Pricat/Position', 'EAN', 'EAN')

Regroup INVRPT with several QTY and LOC specifications on items by location:

SelectDistinctValues('SG_9/SG_11/LOC/DG_C517/@DE_3225')