Hello,
I'm trying to show me the Top Sellers for 2017 (Grouped) via a Transaction search. I've got a few item fields and well they're not working correctly or I don't know how to make them show correctly.
I'm trying to –
1. Show me Parent Internal ID and Internal ID.
I've tried this FORMULA – nvl({parent.internalid}, {internalid}) and used Maximum
This is a working code from an Item Saved Search. The one I'm running is a Transaction Saved Search.
2. Show me Display Name.
I've tried this FORMULA – NVL(REGEXP_REPLACE({parent.caption},'<[^<>]*>',' '), REGEXP_REPLACE({caption},'<[^<>]*>',' ')
This is a working code from an Item Saved Search. The one I'm running is a Transaction Saved Search.
3. Show me Product/Matrix URL Component
I've tried these FORMULA – {item.urlcomponent} – This shows me URL for Inventory items but not Matrices. I tried to create a formula {item.parent.urlcomponent} but it's not working.Obviously, it's going to be incorrect.
4. Show me Image/Matrix Image URL
I've tried this FORMULA – {item.imageurl} but it's saying I can't group this field.
Can anyone help?
Thanks
This is a cached copy. Click here to see the original post.