I have the following (working relevance) that produces a patch report measured against a baseline.
<?relevance
(html "<table id=resultsTable class=sortable> <colgroup><col style=width:140px;/><col style=width:480px;/><col/><col/><col style=width:120px;/><col/></colgroup>" & html ("<th>Computer Name</th><th>Group</th><th>Applicable Patch</th>
<th>Severity</th><th>Category</th><th>Release Date</th><th>CVE</th>") & (it) & html "</table>" ) of concatenations of trs of (td of (item 0 of item 0 of it as string) & td of (item 1 of item 0 of it as string) & td of (item 1 of it as string) &
td of (item 2 of it as string) & td of (item 3 of it as string) & td of ((year of it as string & "/" & (month of it as two digits) as string & "/" & (day_of_month of it as two digits) as string)) of (item 4 of it as date) & td of (item 5 of it as string))
of(
(if (size of item 1 of it > 0) then ((name of it, concatenation ";" of names of bes computer groups of it) of elements of item 1 of it) else ("<none>", "<none>")),
(if (exists Name of item 0 of it| false) then (concatenations "%0A" of (Name of item 0 of it as string)) else ("<none>")),
(if (exists Source Severity of item 0 of it| false) then (concatenations "%0A" of (Source Severity of item 0 of it as string)) else ("<none>")),
(if (exists Category of item 0 of it| false) then (concatenations "%0A" of (Category of item 0 of it as string)) else ("<none>")),
(if (exists Source Release Date of item 0 of it) then (Source Release Date of item 0 of it as string) else ("Fri, 15 Feb 1980")),
(if (exists CVE ID List of item 0 of it | false) then (concatenations "%0A" of (CVE ID List of item 0 of it as string)) else ("<none>")))
of (item 0 of it , intersection of (applicable computer set of item 0 of it; item 1 of it)) whose (size of item 1 of it > 0) of (elements of item 0 of it , item 1 of it)
of (set of fixlets whose (globally visible flag of it = true)
of results of source fixlets of components of component groups of bes fixlets whose (baseline flag of it and name of it contains "Catchup Win - Apr"),
union of (member sets of bes computer groups whose (name of it as lowercase = "non-prod")))
?>
I would like to add an additional column. A custom property (ie. mysetting). This is what i’ve attempted - it’s not working
<?relevance
(html "<table id=resultsTable class=sortable> <colgroup><col style=width:140px;/><col style=width:480px;/><col/><col/><col style=width:120px;/><col/></colgroup>" & html ("<th>Computer Name</th><th>Group</th><th>Applicable Patch</th>
<th>Severity</th><th>Category</th><th>Release Date</th><th>CVE</th>") & (it) & html "</table>" ) of concatenations of trs of (td of (item 0 of item 0 of it as string) & td of (item 1 of item 0 of it as string) & td of (item 1 of it as string) &
td of (item 2 of it as string) & td of (item 3 of it as string) & td of ((year of it as string & "/" & (month of it as two digits) as string & "/" & (day_of_month of it as two digits) as string)) of (item 4 of it as date) & td of (item 5 of it as string) & td of (item 6 of it as string))
of(
(if (size of item 1 of it > 0) then ((name of it, concatenation ";" of names of bes computer groups of it) of elements of item 1 of it) else ("<none>", "<none>")),
(values of results from (bes property "mysetting") of item 0 of it),
(if (exists Name of item 0 of it| false) then (concatenations "%0A" of (Name of item 0 of it as string)) else ("<none>")),
(if (exists Source Severity of item 0 of it| false) then (concatenations "%0A" of (Source Severity of item 0 of it as string)) else ("<none>")),
(if (exists Category of item 0 of it| false) then (concatenations "%0A" of (Category of item 0 of it as string)) else ("<none>")),
(if (exists Source Release Date of item 0 of it) then (Source Release Date of item 0 of it as string) else ("Fri, 15 Feb 1980")),
(if (exists CVE ID List of item 0 of it | false) then (concatenations "%0A" of (CVE ID List of item 0 of it as string)) else ("<none>")))
of (item 0 of it , intersection of (applicable computer set of item 0 of it; item 1 of it)) whose (size of item 1 of it > 0) of (elements of item 0 of it , item 1 of it)
of (set of fixlets whose (globally visible flag of it = true)
of results of source fixlets of components of component groups of bes fixlets whose (baseline flag of it and name of it contains "Catchup Win - Apr"),
union of (member sets of bes computer groups whose (name of it as lowercase = "non-prod")))
?>