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.