unique values of
(
it as trimmed string
)
of node values of selects "a:ServiceLevelDescription/text()" of selects "/GetAssetWarrantyResponse/GetAssetWarrantyResult/a:Response/a:DellAsset/a:Warranties/a:Warranty" whose
(
exists
(
it
)
whose
(
it > current date
)
of
(
(
it as date
)
of
(
last 2 of it & " " &
(
substring
(
4,2
)
of it as integer as month as three letters
)
& " " & first 4 of it
)
of it
)
of
(
it as trimmed string
)
of
(
concatenations of substrings separated by "-" of it
)
of
(
preceding text of first "T" of it
)
of node values of selects "a:EndDate/text()" of it
)
of xml documents of files "results_Dell_GetAssetWarranty.xml" of folders "__BESData\__Global\Logs" of parent folder of client
unique values of (it as trimmed string) of node values of selects "a:ServiceLevelDescription/text()" of selects "/GetAssetWarrantyResponse/GetAssetWarrantyResult/a:Response/a:DellAsset/a:Warranties/a:Warranty" whose( exists (it) whose(it > current date) of ((it as date) of (last 2 of it & " " & (substring (4,2) of it as integer as month as three letters) & " " & first 4 of it) of it) of (it as trimmed string) of (concatenations of substrings separated by "-" of it) of (preceding text of first "T" of it) of node values of selects "a:EndDate/text()" of it ) of xml documents of files "results_Dell_GetAssetWarranty.xml" of folders "__BESData\__Global\Logs" of parent folder of client