This topic contains 0 replies, has 0 voices, and was last updated by Cloud 7 years ago.

  • Author
    Posts
  • #22680 Score: 0

    Cloud
    • Contributions: 0
    • Level 1

    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.

You must be logged in to reply to this topic.