Advanced Reporting - link to detailed item

0
Created an advanced reporting "view" and from the view created a list report. When selecting an item it displays an "aux" table view of the item (with the fields in the advanced query view) and not to the detailed SBM item. Is there a way to make the item link be directed to the detailed SBM item view and not be directed to the "Aux" item view?
Responses (2)
  • Accepted Answer

    Wednesday, August 09 2017, 12:01 PM - #Permalink
    0
    Joe,

    Keep in mind that the point of these advanced views is you might be joining multiple tables together or tables not even related to sbm so there is a good chance a link to an item wouldn't make sense. Saying that though if your view pulled a relational field you should be able to get it to show an icon so you can open the item.

    See if this link helps at all.

    http://knowledgebase.serena.com/InfoCenter/index?page=content&id=S141342
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 11 2017, 01:52 PM - #Permalink
    0
    I think you may want a "many relational". Check the docs for a description of the tag.

    In the SQL it looks like:

    (note: "sp" is an alias to the "USR_SHIPPING_PACKAGES" table

    {MANYRELATIONAL((Select ts_Id from ts_Tables where ts_DbName='USR_SHIPPING_PACKAGES'),sp.TS_ID)} as [TS_PKG_REF] ,


    In the "fields" section it's:

    <field name='Ship Pkg Item' dbname='PKG_REF' type='many-relational' ></field>
    The reply is currently minimized Show
Your Reply

Recent Tweets