Custom Search

If you are looking for specific problems and the default statistics do not fit your needs, you can access data stored in ILA's database tables and write your own SQL query to extract any kind of information.
Special parameters can be included in the SQL syntax to facilitate the insertion of filter values. Parameters provide you with specific input fields.

Parameter syntax:
:[parameter_name[:default_value[:parameter_type[:parameter_format]]]]

Example 1:

SELECT * FROM smtp WHERE lg_FromDomain=:[Domain]

in the above example the parameter "Domain" replaces a "From Domain" static value.

Example 2:

SELECT * FROM smtp WHERE lg_FromDomain=:[Domain:icewarp.it]

in the above example the parameter "Domain" replaces a "From Domain" static value and sets the default value to "icewarp.it".

Example 3:

SELECT * FROM smtp WHERE lg_Duration>:[Min Duration:100:integer]

in the above example the parameter "Min Duration" replaces a "Duration" static value and sets the default value to "100". It declares the parameter as integer type, so you get an integer value edit box.

Example 4:

SELECT * FROM smtp WHERE lg_Date>':[Since:07/06/2005:Date]'

in the above example the parameter "Since" replaces a "Date" static value and sets the default value to "07/06/2005". It declares the parameter as date type, so you get a calendar edit box.

Example 5:

SELECT * FROM smtp WHERE lg_Date>':[Since:07/06/2005:Date:yyyy-mm-dd]'

in the above example the parameter "Since" replaces a "Date" static value and sets the default value to "07/06/2005". It declares the parameter as date type, so you get a calendar edit box. The parameter value used in SQL commands is formatted as "yyyy-mm-dd" to match specific database requirements.