Tuesday, October 2, 2018

Show only the item's parent name on item searches

To expose item's parent name only on searches/saved searches, users may use a Formula in the results tab of their item search as follows:

 

1. Edit the Saved Transaction Search.
2. Go to
Results tab, then go to Columns sub tab.
3. Select
Formula(Text) from the Field dropdown list.
4. Set the following formula:

RTRIM(REGEXP_SUBSTR({name},'[^:]*'))

5. Click Add, then hit Save.

No comments:

Post a Comment