For this scenario, you can use a semicolon to create plurals: https://developer.bigfix.com/relevance/guide/basics/singular-and-plural.html
For instance, here’s a simple example that starts with some data:
Q: ("1","2","3","4")
A: 1, 2, 3, 4
T: 0.126 ms
I: singular ( string, string, string, string )
Then adds a ‘header’ row:
Q: ("h1","h2","h3","h4");("1","2","3","4")
A: h1, h2, h3, h4
A: 1, 2, 3, 4
T: 0.079 ms
I: plural ( string, string, string, string )
Given the above, and leveraging an efficient form of relevance to pull multiple property values based on @brolly33’s awesome blog post, here’s a sample bit of relevance that should achieve the desired output:
("Computer Name","AIX Full OS Level","Technology Level","ServicePack","Build Date");
(
name of item 0 of it | "missing name"
, (concatenation ";" of values of results (item 0 of it, elements of item 1 of it))
, (concatenation ";" of values of results (item 0 of it, elements of item 2 of it))
, (concatenation ";" of values of results (item 0 of it, elements of item 3 of it))
, (concatenation ";" of values of results (item 0 of it, elements of item 4 of it))
) of (
elements of item 0 of it
,item 1 of it
,item 2 of it
,item 3 of it
,item 4 of it
) whose (exists values of results (item 0 of it, elements of item 1 of it)) of (
set of BES computers
, set of bes properties whose (name of source analysis of it = "AIX OS Level" AND name of it as lowercase = ("AIX Full OS Level") as lowercase)
, set of bes properties whose (name of source analysis of it = "AIX OS Level" AND name of it as lowercase = ("Technology Level") as lowercase)
, set of bes properties whose (name of source analysis of it = "AIX OS Level" AND name of it as lowercase = ("Service Pack") as lowercase)
, set of bes properties whose (name of source analysis of it = "AIX OS Level" AND name of it as lowercase = ("Build Date") as lowercase)
)