Issue with below relevance query

Hi , I am working on below relevance query which is partially working -

Below Query working fine -

(ids of it as string , names of it as string , detailed statuses of results of it as string,names of  targeted computers of it as string ) of members actions of bes actions whose (id of it = <ACTIONID>)

where as if I tried to look particular target server it fails - What is wrong with below query?

 (ids of it as string , names of it as string , detailed statuses of results of it as string,names of  targeted computers of it as string ) of members actions of bes actions whose (id of it = <ACTIONID> and name of targeted computers of it as uppercase = "SERVER1")

What is difference between targeted computers and targeted lists

what’s the error you’re getting

No result from second query , though server name listed in first query output.

it throws error “Singular expression required”

The it in the targeted computers of it refers to the bes action object and not the member actions so it might be that you need to move the targeted computer clause to refer to the member actions ?

member actions whose (names of targeted computers of it as uppercase = "SERVER1") of bes actions ...