Count Relationship Types for an Item Type

Peter Kim
Peter Kim Member, Data Exchange, Functional Safety Kit (FSK) Posts: 15

I would like to find out what relationship types are being used for a specific item type.

When I use a filter to list a specific item type with upstream relationship of any relationship type, the result does not show relationship types. Therefore I cannot count them.

Is there a way to count Relation Types for an item type?

Thanks.

------------------------------
Peter Kim
------------------------------

Comments

  • Alex Frain
    Alex Frain Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 27
    edited February 29

    If you're talking in general as far as finding out what Relationship Types exist between items, the Jama Admin should be able to get you a screen shot of the Relationships for a given project which will list Upstream -> Downstream item type relationship mappings and the Relationship Type being used between them.

    image

    If you're looking to get counts of relationship types being used between specific items in a project, you'd have to go into each specific item from your filter results and then click on the Relationships widget in each item to see the Relationship Type for the existing relationships.  I'm sure this can be done via script as well.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-28-2024 12:56
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    I would like to find out what relationship types are being used for a specific item type.

    When I use a filter to list a specific item type with upstream relationship of any relationship type, the result does not show relationship types. Therefore I cannot count them.

    Is there a way to count Relation Types for an item type?

    Thanks.

    ------------------------------
    Peter Kim
    ------------------------------
    Alex
    Fujifilm Sonosite
  • Peter Kim
    Peter Kim Member, Data Exchange, Functional Safety Kit (FSK) Posts: 15
    edited February 29

    Hi Alex,

    What I tried to do was to count how many times how many times each relationship type was used for upstream relationships for software requirement item type. So I created a filter like:

    image

    I then tried to view all fields hoping that the relationship type field will show relationship type for each software requirement.
    However there was no relationship type field in the output or in the list of fields I can select from.
    Excel report did not show relationship type for each software requirement.

    Let me know if this is doable. Thanks.

    ------------------------------
    Peter Kim
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-29-2024 09:13
    From: Alex Frain
    Subject: Count Relationship Types for an Item Type

    If you're talking in general as far as finding out what Relationship Types exist between items, the Jama Admin should be able to get you a screen shot of the Relationships for a given project which will list Upstream -> Downstream item type relationship mappings and the Relationship Type being used between them.

    image

    If you're looking to get counts of relationship types being used between specific items in a project, you'd have to go into each specific item from your filter results and then click on the Relationships widget in each item to see the Relationship Type for the existing relationships.  I'm sure this can be done via script as well.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------

    Original Message:
    Sent: 02-28-2024 12:56
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    I would like to find out what relationship types are being used for a specific item type.

    When I use a filter to list a specific item type with upstream relationship of any relationship type, the result does not show relationship types. Therefore I cannot count them.

    Is there a way to count Relation Types for an item type?

    Thanks.

    ------------------------------
    Peter Kim
    ------------------------------
  • Alex Frain
    Alex Frain Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 27
    edited March 1

    Hi Peter,

    The only way I know of to see that information in Jama is to go into each individual item from your filter results, click the Relationship widget button to show all relationships that item has which will include the Relationship Type, and count them there (screenshot below is from the user guide).   I'm guessing this is something that can probably be done via a script although I've never done it.  It may be worth investigating if there are a lot of items you have to go through to get counts or you have to repeat this periodically.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 02-29-2024 10:44
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    Hi Alex,

    What I tried to do was to count how many times how many times each relationship type was used for upstream relationships for software requirement item type. So I created a filter like:

    image

    I then tried to view all fields hoping that the relationship type field will show relationship type for each software requirement.
    However there was no relationship type field in the output or in the list of fields I can select from.
    Excel report did not show relationship type for each software requirement.

    Let me know if this is doable. Thanks.

    ------------------------------
    Peter Kim
    ------------------------------

    Original Message:
    Sent: 02-29-2024 09:13
    From: Alex Frain
    Subject: Count Relationship Types for an Item Type

    If you're talking in general as far as finding out what Relationship Types exist between items, the Jama Admin should be able to get you a screen shot of the Relationships for a given project which will list Upstream -> Downstream item type relationship mappings and the Relationship Type being used between them.

    image

    If you're looking to get counts of relationship types being used between specific items in a project, you'd have to go into each specific item from your filter results and then click on the Relationships widget in each item to see the Relationship Type for the existing relationships.  I'm sure this can be done via script as well.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite

    Original Message:
    Sent: 02-28-2024 12:56
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    I would like to find out what relationship types are being used for a specific item type.

    When I use a filter to list a specific item type with upstream relationship of any relationship type, the result does not show relationship types. Therefore I cannot count them.

    Is there a way to count Relation Types for an item type?

    Thanks.

    ------------------------------
    Peter Kim
    ------------------------------
    Alex
    Fujifilm Sonosite
  • Peter Kim
    Peter Kim Member, Data Exchange, Functional Safety Kit (FSK) Posts: 15
    edited March 4

    Hi Alex, What do you mean by script? You mean using REST API? Or is there a scripting language for Jama?

    ------------------------------
    Peter Kim
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-01-2024 09:35
    From: Alex Frain
    Subject: Count Relationship Types for an Item Type

    Hi Peter,

    The only way I know of to see that information in Jama is to go into each individual item from your filter results, click the Relationship widget button to show all relationships that item has which will include the Relationship Type, and count them there (screenshot below is from the user guide).   I'm guessing this is something that can probably be done via a script although I've never done it.  It may be worth investigating if there are a lot of items you have to go through to get counts or you have to repeat this periodically.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------

    Original Message:
    Sent: 02-29-2024 10:44
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    Hi Alex,

    What I tried to do was to count how many times how many times each relationship type was used for upstream relationships for software requirement item type. So I created a filter like:

    image

    I then tried to view all fields hoping that the relationship type field will show relationship type for each software requirement.
    However there was no relationship type field in the output or in the list of fields I can select from.
    Excel report did not show relationship type for each software requirement.

    Let me know if this is doable. Thanks.

    ------------------------------
    Peter Kim

    Original Message:
    Sent: 02-29-2024 09:13
    From: Alex Frain
    Subject: Count Relationship Types for an Item Type

    If you're talking in general as far as finding out what Relationship Types exist between items, the Jama Admin should be able to get you a screen shot of the Relationships for a given project which will list Upstream -> Downstream item type relationship mappings and the Relationship Type being used between them.

    image

    If you're looking to get counts of relationship types being used between specific items in a project, you'd have to go into each specific item from your filter results and then click on the Relationships widget in each item to see the Relationship Type for the existing relationships.  I'm sure this can be done via script as well.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite

    Original Message:
    Sent: 02-28-2024 12:56
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    I would like to find out what relationship types are being used for a specific item type.

    When I use a filter to list a specific item type with upstream relationship of any relationship type, the result does not show relationship types. Therefore I cannot count them.

    Is there a way to count Relation Types for an item type?

    Thanks.

    ------------------------------
    Peter Kim
    ------------------------------
  • Alex Frain
    Alex Frain Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 27
    edited March 4

    Hi Peter,

    Yes, I was referring to using Jama's REST API or possibly creating a context sensitive Velocity template to generate a report that provides link counts by type.

    ------------------------------
    Alex
    Fujifilm Sonosite
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-04-2024 10:33
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    Hi Alex, What do you mean by script? You mean using REST API? Or is there a scripting language for Jama?

    ------------------------------
    Peter Kim
    ------------------------------

    Original Message:
    Sent: 03-01-2024 09:35
    From: Alex Frain
    Subject: Count Relationship Types for an Item Type

    Hi Peter,

    The only way I know of to see that information in Jama is to go into each individual item from your filter results, click the Relationship widget button to show all relationships that item has which will include the Relationship Type, and count them there (screenshot below is from the user guide).   I'm guessing this is something that can probably be done via a script although I've never done it.  It may be worth investigating if there are a lot of items you have to go through to get counts or you have to repeat this periodically.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite

    Original Message:
    Sent: 02-29-2024 10:44
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    Hi Alex,

    What I tried to do was to count how many times how many times each relationship type was used for upstream relationships for software requirement item type. So I created a filter like:

    image

    I then tried to view all fields hoping that the relationship type field will show relationship type for each software requirement.
    However there was no relationship type field in the output or in the list of fields I can select from.
    Excel report did not show relationship type for each software requirement.

    Let me know if this is doable. Thanks.

    ------------------------------
    Peter Kim

    Original Message:
    Sent: 02-29-2024 09:13
    From: Alex Frain
    Subject: Count Relationship Types for an Item Type

    If you're talking in general as far as finding out what Relationship Types exist between items, the Jama Admin should be able to get you a screen shot of the Relationships for a given project which will list Upstream -> Downstream item type relationship mappings and the Relationship Type being used between them.

    image

    If you're looking to get counts of relationship types being used between specific items in a project, you'd have to go into each specific item from your filter results and then click on the Relationships widget in each item to see the Relationship Type for the existing relationships.  I'm sure this can be done via script as well.

    image

    ------------------------------
    Alex
    Fujifilm Sonosite

    Original Message:
    Sent: 02-28-2024 12:56
    From: Peter Kim
    Subject: Count Relationship Types for an Item Type

    I would like to find out what relationship types are being used for a specific item type.

    When I use a filter to list a specific item type with upstream relationship of any relationship type, the result does not show relationship types. Therefore I cannot count them.

    Is there a way to count Relation Types for an item type?

    Thanks.

    ------------------------------
    Peter Kim
    ------------------------------
    Alex
    Fujifilm Sonosite