-
1. Re: Trying to get different data from worklog and multiple rows for each item,
If each type of Note is unique for an entry, then encapsulating your calculated field using MAX() would do the trick.
i.e.
MAX (CASE WHEN .... ELSE .... END)
-
2. Re: Trying to get different data from worklog and multiple rows for each item,
Hi Swamy,
Thank you for this feedback,
MAX() do not work with text field, I get an error when I tried your solution,
Regards,
Bertrand,
-
3. Re: Trying to get different data from worklog and multiple rows for each item,
I believe there is a known error with the current version of smart reporting when trying to use Max() on anything other than a number.
-
4. Re: Trying to get different data from worklog and multiple rows for each item,
Please check with BMC on the same, as the version that we are using supports such use case with text fields too.
-
5. Re: Trying to get different data from worklog and multiple rows for each item,
1 of 1 people found this helpfulIs it possible to have more than one note of the same type attached to the same incident? That would complicate matters.
Otherwise, if you define separate calculated fields for each type of note using something like MAX (CASE WHEN Note type = <note type> THEN 1 ELSE 0 END), you should be able to use them to decide whether to show contents of appropriate note or use placeholder for unused note.