Skip to content

A Lobby data set for Distribution Orders already shows which warehouses hold available quantity for each part, via a LISTAGG-based column, but is it possible to filter the whole data set down to only specific named warehouses?

Answer

Add a condition filtering on that same LISTAGG-based warehouse-list expression, checking whether it falls within your allowed warehouse list, for example ... IN ('A1','B2','C3') for the specific warehouses you want to see, in the Condition SQL. Be aware of an inherent limitation with this approach though: since the LISTAGG expression can return several warehouse codes concatenated together for one record (e.g. 'A1^B2'), that combined string won't exactly match any single warehouse code in a plain IN-list — so a record spread across multiple warehouses can be unintentionally excluded even if one of those warehouses is on the allowed list. Resolving that specific edge case reliably generally requires a more tailored condition based on the actual pattern of your warehouse/quantity data, rather than a single one-size-fits-all fix.

← Browse Platform, Aurena, and customization questions