The filter conditions
The filter conditions
Filter condition | Description |
Equal | This checks whether the value in the field matches the input. |
Not Equal | This checks whether the value in the field does not match the input. |
Like | This checks whether the value in the field matches the input. % : This character stands for one to any number of characters. _ : This character stands for any character |
Not Like | This checks whether the value in the field does not match the input. % : This character stands for one to any number of characters. _ : This character stands for any character |
Greater | This checks whether the value in the field is greater than the input value. |
Greater Equal | This checks whether the value in the field is greater than or equal to. |
Less | This checks whether the value in the field is smaller than the input value. |
Less Equal | This checks whether the value in the field is smaller or equal. |
Between | Here it is checked whether the value in the field lies between the input. |