table "border=all" of concatenation of trs of
(
td of item 0 of it & td of item 1 of it & td of item 2 of it & td of item 3 of it & td of item 4 of it
)
of
(
(
b of "ID" as html, b of "Link" as html, b of "Type" as html, b of "Site Name", b of "Content" as html
)
;
(
(
id of item 0 of it as string as html
)
, link of item 0 of it,
(
if analysis flag of item 0 of it then "Analysis" else if baseline flag of item 0 of it then "Baseline" else if fixlet flag of item 0 of it then "Fixlet" else if group flag of item 0 of it then "Group" else if task flag of item 0 of it then "Task" else "Unknown"
)
as html ,name of site of item 0 of it as html, item 1 of it as html
)
of
(
it,
(
concatenations of ps of
(
(
"Name:" &
(
if exists name of it then name of it else ""
)
)
;
(
if exists relevance clauses of it then
(
"Relevance:" & it
)
of relevance clauses of it else ""
)
;
(
if exists scripts of actions of it then
(
"Script:" & it
)
of substrings separated by "%0a" of scripts of actions of it else ""
)
;
(
if exists scripts of actions of components of component groups of it then substrings separated by "%0a" of scripts of actions of components of component groups of it else ""
)
)
whose
(
it as string as lowercase contains "MY_SEARCH_TERM" as lowercase
)
)
)
whose
(
item 1 of it as string !=""
)
of
(
fixlets of
(
bes sites; bes custom sites; operator sites of bes users
)
)
)
table "border=all" of concatenation of trs of (td of item 0 of it & td of item 1 of it & td of item 2 of it & td of item 3 of it & td of item 4 of it) of
((b of "ID" as html, b of "Link" as html, b of "Type" as html, b of "Site Name", b of "Content" as html) ; ((id of item 0 of it as string as html) , link of item 0 of it, (if analysis flag of item 0 of it then "Analysis" else if baseline flag of item 0 of it then "Baseline" else if fixlet flag of item 0 of it then "Fixlet" else if group flag of item 0 of it then "Group" else if task flag of item 0 of it then "Task" else "Unknown") as html ,name of site of item 0 of it as html, item 1 of it as html) of (it, (concatenations of ps of (("Name:" & (if exists name of it then name of it else "")) ;(if exists relevance clauses of it then ("Relevance:" & it) of relevance clauses of it else "") ; (if exists scripts of actions of it then ("Script:" & it) of substrings separated by "%0a" of scripts of actions of it else "") ; (if exists scripts of actions of components of component groups of it then substrings separated by "%0a" of scripts of actions of components of component groups of it else "")) whose (it as string as lowercase contains "MY_SEARCH_TERM" as lowercase))) whose (item 1 of it as string !="") of (fixlets of (bes sites; bes custom sites; operator sites of bes users)))
