(imported topic written by saltemus91)
I get this error in the Excel custom query tool also. Seems when I try to filter on IP I get a lowercase error any ideas?
Trying to meet my managers requirements and I am not a great at this language.
Could use help
RELEVANCE FOLLOWS PROBLEM IS THE FILTERING ON IP ADRESS
( item 0 of it as string & “$x$” &
item 1 of it as string & “$x$” &
item 2 of it as string & “$x$” &
(if (year of it as integer = 1980)
then ("")
else
(year of it as string & “/” &
(month of it as two digits) as string & “/” &
(day_of_month of it as two digits) as string) )
of (item 3 of it as date) & “$x$” &
item 4 of it as string & “$x$” &
item 5 of it as string )
of (
(if (exists Name of Fixlet of it)
then (concatenations “%0A” of (Name of Fixlet of it as string))
else ("")),
(if (exists Name of Computer of it)
then (concatenations “%0A” of (Name of Computer of it as string))
else ("")),
(if (exists Source Severity of Fixlet of it)
then (concatenations “%0A” of (Source Severity of Fixlet of it as string))
else ("")),
(if (exists Source Release Date of Fixlet of it)
then (Source Release Date of Fixlet of it as string)
else (“Fri, 15 Feb 1980”)),
(if (exists Operating System of Computer of it)
then (concatenations “%0A” of (Operating System of Computer of it as string))
else ("")),
(if (exists IP Addresses of Computer of it)
then (concatenations “%0A” of (IP Addresses of Computer of it as string))
else ("")))
of
results
whose (((Relevant Flag of it = True) AND
(IP Addresses of Computer of it as lowercase contains “1.1.1.1”)))
of bes fixlets
whose (
(name of site of it = “Patches for AIX” OR
name of site of it = “Patches for HP-UX” OR
name of site of it = “Patches for Mac OS X” OR
name of site of it = “Patches for RedHat Enterprise Linux” OR
name of site of it = “Patches for RedHat Linux” OR
name of site of it = “Patches for Solaris” OR
name of site of it = “Patches for SUSE Linux Enterprise” OR
name of site of it = “Enterprise Security”))