I’m trying to move a SQL report from our old application to a WebReport, but am having trouble with the final piece. I created the needed properties including “SSLTask - Raw Values” which may have multiple values. Because of this, I’m basing my session rel on that property.
That property is set like the following -> “;;”, so I’d like to split it.
I’d like to do something like this, but I’m getting singular expression refers to nonexistant object (Makes sense)
( name of computer of it, (value of results (computer of it,bes property
"SSLTask - Last Run")|
""), (preceding text of first
";" of it) of values of it, (preceding text of first
";" of (following text of first
";" of values of it)), (following text of first
";" of (following text of first
";" of values of it)) ) of results of bes properties whose (name of it =
"SSLTask - Raw Values")
I’m not sure on how to fix it, but I’ve gotten this far:
( name of computer of it, (value of results (computer of it,bes property
"SSLTask - Last Run")|
""), (
if (exists values whose (it contains
";") of it) then ((preceding text of first
";" of it) of values of it)
else (
"") ) ) of results of bes properties whose (name of it =
"SSLTask - Raw Values")
As soon as I set the other substrings with an if/then I start getting extra results.
Thanks Noah, Lee Wei surprised me to help me out with this and I got it working!
To make a long story short, I just about had it but had some problems with concatenating multiple values.
For completion sake, the final HTML is below:
(html
"<table border=1>" & it & html
"</table>") of concatenations of trs of (item 0 of it & item 1 of it & item 2 of it) of ( td of name of computer of it, td of (value of results (computer of it,bes property
"SSLTask - Last Run")|
""), (
if (length of concatenations of values of it != 0) then ( (td of preceding text of first
";" of it & td of preceding text of first
";" of following text of first
";" of it & td of following text of last
";" of it) of values of it )
else (td of
" " & td of
" " & td of
" ")) ) of results of bes properties whose (name of it =
"SSLTask - Raw Values")
Had to do some trickery with tuples to get it to format properly on a 1:1:1 value for properties.