How does one report on custom Enumerated Lists (Medium Strings) in RRDI, coming from RTC?
I'm working on queries in RRDI to pull out custom enumerated lists; they're multi-select values that end up as Medium Strings. This is on 4.0.3 of RTC.
The field values come out of the database like this: "|val.1|val.2|val.3|" and so on. "val.1" further corresponds to a nice Literal Name over in the Request Enumeration table. I need a way to tease apart the multiple values and look up their Literal Names. How best to do this?
The field values come out of the database like this: "|val.1|val.2|val.3|" and so on. "val.1" further corresponds to a nice Literal Name over in the Request Enumeration table. I need a way to tease apart the multiple values and look up their Literal Names. How best to do this?
2 answers
Thanks, Rafik. For my subtotaling needs, I think I can do this in a very non-optimal way by searching for each instance of the enumeration in my workitems and tallying those up with a "like '%val.1%'" sort of expression. As I said, very non-optimal, and I'll need to know the literal substitution values ahead of time, but it's better than nothing.
Comments
Rama SCM
Nov 25 '13, 2:40 p.m.sam detweiler
Nov 25 '13, 2:43 p.m.Rama SCM
Nov 26 '13, 10:56 a.m.sam detweiler
Nov 26 '13, 11:04 a.m.Rama SCM
Nov 26 '13, 11:50 a.m.David Schmidt
Nov 26 '13, 2:09 p.m.sam detweiler
Nov 26 '13, 4:03 p.m.