Session Relevance that adds Microsoft Patches category filter to existing relevance

I need to add an additional filter to the following relevance statement

(source id of fixlet of it as string,source severity of fixlet of it as string,source of fixlet of it as string,category of fixlet of it as string,name of fixlet of it as string,name of computer of it as string,
last became relevant of it as string, (value of client settings whose(name of it = "Department") of it | "None") of computer of it )of results from (bes fixlets whose (fixlet flag of it and display name of site of it contains "Patches for Windows")) whose (exists first became relevant of it and relevant flag of it = true) of bes computers

that filters the categories to only = Critical updates, Security Advisory, Security Hotfix, Security Update, and Service Pack types and display them in the field “category of fixlet of it as string”

You can try this.

(
    source id of fixlet of it as string,
    source severity of fixlet of it as string,
    source of fixlet of it as string,
    category of fixlet of it as string,
    name of fixlet of it as string,
    name of computer of it as string,
    last became relevant of it as string,
    (value of client settings whose(name of it = "Department") of it | "None") of computer of it
) of results
    (   bes computers,
        bes fixlets whose (fixlet flag of it and 
            display name of site of it contains "Patches for Windows" and
            "|" & category of it & "|" is contained by ("|Critical Updates|Security Advisory|Security Hotfix|Security Update|Service Pack|")
        )
    ) whose (exists first became relevant of it and relevant flag of it = true) 
    

1 Like

Thanks Lee Wei. That works great. How would use the same filter requirements for category on the relevance statement below that runs against a defined “Computer Group”

(source id of fixlet of it as string,source severity of fixlet of it as string,source of fixlet of it as string,category of fixlet of it as string,name of fixlet of it as string,name of computer of it as string,
last became relevant of it as string, (value of client settings whose(name of it = "Department") of it | "None") of computer of it )of results from (bes fixlets whose (fixlet flag of it and display name of site of it contains "Patches for Windows")) whose (exists first became relevant of it and relevant flag of it = true) of members of bes computer groups whose (name of it =
"Windows")

Problem solved. Thanks Lee Wei for your help as always.

(source id of fixlet of it as string,source severity of fixlet of it as string,source of fixlet of it as string,category of fixlet of it as string,name of fixlet of it as string,name of computer of it as string,
last became relevant of it as string, (value of client settings whose(name of it = "Department") of it | "None") of computer of it )of results from 
(bes fixlets whose (fixlet flag of it and display name of site of it contains "Patches for Windows" and "|" & category of it & "|" is contained by ("|Critical Updates|Security Advisory|Security Hotfix|Security Update|Service Pack|")
)) whose (exists first became relevant of it and relevant flag of it = true) of members of bes computer groups whose (name of it =
"AD-BIGFIX")