Hi!
I'm trying to embed specific information from CaseComplete into a specific table template, and I'm not having much luck. Here's a copy of the table format:
|
|
Impact
|
Probability
|
|
High
|
|
|
|
Medium
|
|
|
|
Low
|
|
|
|
Legend
|
|
Impact:
|
|
Probability:
I have a specific requirement (in my Summary Package) which is named "Risk", and I want to display an entry in the cells of the table (Impact and Probability) based on the description of the requirement and its priority.
I have tried using "if Requirements Exist", "repeatRequirements", and "listRequirments" and none of them seem to work. What code, similar to this, can I use to display a specific value in each cell, based on the requirement attributes:
$if Requirements Exist where [Package = Summary and Name = Risk and Description contains High] High $endif
(This is intended to fill the "Impact" cell in the "High" row with the value "High")
$if Requirements Exist where [Package = Summary and Name = Risk and Priority = 2] Medium $endif
(This is intended to fill the "Probability" cell in the "Medium" row with the value "Medium")
Any thoughts?????
Thanks!
Tom
|
Please sign in to leave a comment.
I think it would be quite helpful if we had your actual table to work with, Tom, in order to see the formatting and just where you'd like the data from CaseComplete to populate. Would you mind sending me your template? You can email it to support@serlio.com if you'd prefer it not be public.
I've also taken the liberty of moving your request over to the Custom Reporting forum, so others can benefit from it once we get this sorted out.
Hey Jason!
How are you?
I included a copy of the table in my initial request. You just can't really see that it's a table. In the document, it's all blank the columns are labelled "Impact" and "Probability" and the rows are labelled "High", "Medium" and "Low". The trick is to get the appropriate cell in the matrix populated, based on the values in the specific requirement.
Does that help?
I will also email a copy of the table to you. The key is that the table is not a part of any specific CC code. I just want to use code to populate it.
Thanks!
Tom
I'm doing great Tom! Thanks for asking. And yourself? I'll look for your table to come in; I think we should be able to do what you're looking for, it will just be much easier to get the cell locations right to have something to work with (our ticketing system is notorious for stripping out formatting and making things look, well, odd). I could probably generate one, but why duplicate the effort if you've already got one made, right?
Email was sent. I included some code to give you the general idea.
Thanks for sending in your template, Tom.
Since this table will only ever apply to a single requirement, you can surround the entire thing with a conditional statement:
$repeatRequirements where Name = 'Risk'
(table goes here)
$endrepeatRequirements
Then, for each cell in the table, you can insert a simpler conditional statement that will fill in the appropriate data when those conditions are met. For instance, to insert the text "Medium" in the Impact column (following your guidelines), you'd use this:
$if Description contains 'Medium'
Medium
$endif
...And you would use similar statements in all of the other cells. For another example, to fill in the Low / Probability cell:
$if Priority = 3
Low
$endif
