Is there a way to add the “Item On Any Line” as an...
# general
l
Is there a way to add the “Item On Any Line” as an Available Filter in a transaction saved search? I tried using the said field but it does not allow me to check the Show In Filter Region box. I also tried to use Formula (Text) for the said “field” both in the Criteria subtab and in the Available Filter subtab but it doesn’t show the internal ID of the “Item On Any Line”.
question not answered 1
d
also can't even do this as a summary search, as the 'formula(text) criteria as an available filter' doesn't work for summary criteria. Also tried with sneaking an analytic function into a regular criteria formula (like
LISTAGG/*comment*/({item}, '|') WITHIN GROUP (ORDER BY {item}) OVER (PARTITION BY {internalid})
) but this didn't work (maybe the SQL function is wong?) LMK if you find out how to do this
l
Thanks for the additional info. As of now, I haven't found a way.