anyone know if it's possible to display Company Bu...
# general
u
anyone know if it's possible to display Company Business Units properly in Saved Search Filters? for context, we have Business Units set up in
Setup > Company > Business Units
and have Items configured with those. Now when making a Saved Search for all Items, we wanted to be able to display all of them and have an Available Filter for Business Units displayed. The problem is that BU's that have Parent Business Units don't display properly. An example is if I have the BU's "_Paint_", "_Thinner_", and "_Dispersion_", in the BU List (and in other drop-down fields that source Business Units as a List) they would appear as:
Copy code
Paint
Paint : Thinner
Paint : Dispersion
However, when checking through the Saved Search Available Filter they simply show up as individual words instead of being grouped up like that, which makes it less accessible for end-users. I've attached a picture of how it looks like. Would appreciate any input, thanks!
😂 1
m
Is there a business units (no hierarchy) field in the saved search results?
Otherwise use SUBSTR to find the colon in the name and start from there
Well SUBTR and INSTR