Error Conditions and Error Messages for Filters
The following table lists common error conditions you might encounter while saving or applying filters and the error messages for those conditions:
Table 1: Error Conditions and Error Messages for Filters
Error Condition | Sample Filter Data | Validation Error Message at Apply Filter | Validation Error Message on the Save Filter and Manage Filter Page |
|---|---|---|---|
Invalid column name. | 'namm' | Invalid column name: namm | Invalid filter query |
Incorrect filter query. Comparison missing after column name. | 'Name' juniper 'Name' has test OR 'Device Alias' contains test | Incorrect filter query, please provide a comparison after column name (Name) | Invalid filter query |
Incorrect filter query. Value after comparison missing. | Name = Name = juniper OR Name = | Incorrect filter query, please provide a value after comparison (=) | Invalid filter query |
Incorrect filter query; “)” missing. | ( Name = test | Incorrect filter query, please insert ")" to complete the query (test) | Invalid filter query |
Incomplete filter query. Column name or "(" missing. | ( Name = juniper ) OR | Incomplete filter query. Please provide a column name or "(" to complete the query after (OR) | Invalid filter query |
Incomplete filter query. Column name or "(" missing after (NOT) | ( Name = juniper ) OR NOT | Incomplete filter query. Please provide a column name or "(" to complete the query after(NOT) | Invalid filter query |
Incorrect filter query; Unexpected token ")" | Name = test ) | Incorrect filter query, Unexpected token ")" | Invalid filter query |
Incorrect filter query; Unexpected token ")" | Name = test AND ( Name = test1)) | Incorrect filter query, Unexpected token ")" | Invalid filter query |
Incorrect filter query; Unexpected token "(" | Name = test AND ( Name = test1)( | Incorrect filter query, Unexpected token "(" | Invalid filter query |
Incorrect filter query; ")" missing. | ( Name = test AND ( Name = test1) | Incorrect filter query, please insert ")" to complete the query (test) | Invalid filter query |
Invalid filter query. Query must start with "(" or NOT or column name. | ) | Invalid filter query. Query should start with "(" or NOT or column name. | Invalid filter query |
Invalid filter query | ( Name starts-with ") | Invalid filter query. Query should start with "(" or NOT or column name. | Invalid filter query |
The equal condition is not supported for the specified column. | Domain = SUCCESS | Filtering of “Domain” column is not possible with “Equal” condition | |
The not equal condition is not supported for the specified column. | Domain != SUCCESS | Filtering of “Domain” column is not possible with “Not Equal” condition | |
The greater than condition is not supported for the specified column. | Name > Test | Filtering of “Name” column is not possible with “Greater than” condition | Filtering of “Name” column is not possible with “Greater than” condition |
The less than condition is not supported for the specified column. | Name < Test | Filtering of “Name” column is not possible with “Less than” condition | Filtering of “Name” column is not possible with “Less than” condition |
The “greater than or equal to” condition is not supported for the specified column. | Name >= Test | Filtering of “Name” column is not possible with “Greater than or equal to” condition | Filtering of “Name” column is not possible with “Greater than or equal to” condition |
The “Less than or equal to” condition is not supported for the specified column. | Name <= Test | Filtering of “Name” column is not possible with “Less than or equal to” condition | Filtering of “Name” column is not possible with “Less than or equal to” condition |
The “contains” condition is not supported for the specified column. | ID contains 123 | Filtering of “ID” column is not possible with “contains” condition | Filtering of “ID” column is not possible with “contains” condition |
The “not-contains” condition is not supported for the specified column. | ID not-contains 123 | Filtering of “ID” column is not possible with “not-contains” condition | Filtering of “ID” column is not possible with “not-contains” condition |
The “starts-with” condition is not supported for the specified column. | ID starts-with 123 | Filtering of “ID” column is not possible with “starts-with” condition | Filtering of “ID” column is not possible with “starts-with” condition |
The “ends-with” condition is not supported for the specified column. | ID ends-with 123 | Filtering of “ID” column is not possible with “ends-with” condition | Filtering of “ID” column is not possible with “ends-with' condition |
The specified column supports only numbers for values. | ID = test | “ID” column accepts only Numbers | “ID” column accepts only Numbers |
The input value is not supported for the specified column. | 'Device Network' = 123 | “Device Network” column can not be filtered with the provided filter value “123” | “Device Network” column can not be filtered with the provided filter value “123” |
The input date and time value does not match the supported format. | 'End Time' = 10pm | “End Time” column accepts only valid date, Example: 11/03/2017 01:14AM | “End Time” column accepts only valid date, Example: 11/03/2017 01:14AM |
The input value is not supported for the specified column. | State = SUCCES | “State” column can not be filtered with the provided filter value “SUCCES” | “State” column can not be filtered with the provided filter value “SUCCES” |
The input column name is invalid or is of a column for which filtering is not supported. | State = SUCCESS | Column name “State is invalid or Filtering of that column is not supported. |
