I’m running into a bit of an issue when trying to get a percentage into my table. The part that is giving me trouble is bolded. The strSites is an additional bit that specifies only certain sites to include.
prodarea.innerHTML = "
Patches Less Than 30 Days Old
Fixlet
Source Release
Days Old
Applicable
Percent
" + EvaluateRelevance(‘concatenation of (trs of ((td of item 0 of it & td of item 2 of it & td of item 3 of it & td of item 1 of it & td of item 4 of it) of (link of it, applicable computer counts of it as string, source release date of it as string, (unique values of (current date - source release date of it)) as string, (number of results of it / applicable computer counts of it) as string)))of (bes fixlets whose (((current date - 30*day) < source release date of it) and (applicable computer count of it > 0) and (false’ + strSites + ‘)))’) + “
”;
Most issues I run in to can be fixed by finishing it up as a string, but I can’t get it to work in this instance. Any help would be greatly appreciated.
You need to make ‘applicable computer counts’ singular.
I also needed additional error checking to make sure that a fixlet had results, a link, a source release date, etc. That might because I have a lot of non-production content in my deployment though.