I am Relevance newbie. Try to get data using the following relevance. There are 15 records returned which include 2 records with installed application starts with “Adobe”
(
item 0 of it,
item 1 of it,
item 2 of it,
item 3 of it,
item 4 of it,
item 5 of it,
item 6 of it
) of
(
values of results (it, bes property “Department”) whose (value of it = “ITTech” ),
values of results (it, bes property “Branch”) whose (value of it = “IMB” ),
values of results (it, bes property “Division”) whose (value of it = “SSA” ),
values of results (it, bes property “Sector”) whose (value of it = “MIT” ),
name of it as string,
values of results (it, bes property “Installed Applications - Windows”)
)
of
(bes computers whose (name of it as lowercase starts with “wks1000”))
However, when adding extra filter “whose (value of it as lowercase starts with “adobe”)”. I got no record return.
… name of it as string,
values of results (it, bes property “Installed Applications - Windows”) whose (value of it as lowercase starts with “adobe”)
)
of
(bes computers whose (name of it as lowercase starts with “wks1000”))
Please help. I would like to get 2 records with 2 installed applications name start with “Adobe”, NOT all installed applications on the device.
I can’t test the statement because I don’t have the properties you have.
The relevance statement will look something like this.
( item 0 of it, item 1 of it, item 2 of it, item 3 of it, item 4 of it, (
if (item 5 of it contains
" |") then (preceding text of first
" |" of item 5 of it)
else (item 5 of it)), (
if (item 5 of it contains
"| ") then (following text of first
"| " of item 5 of it)
else (
"None")) ) of ( values of results (it, bes property
"Department") whose (value of it =
"ITTech" ), values of results (it, bes property
"Branch") whose (value of it =
"IMB" ), values of results (it, bes property
"Division") whose (value of it =
"SSA" ), values of results (it, bes property
"Sector") whose (value of it =
"MIT" ), name of it as string, values whose (it as lowercase contains
"adobe") of results (it, bes property
"Installed Applications - Windows") ) of (bes computers whose (name of it as lowercase starts with
"wks1000"))