The Expression Builder

The Expression Builder is used to configure what expression the API checks. You can configure your expression based on the different columns of your database table or compare different variables. The left side of the configuration is the column/variable/value you would like to use. The middle part is the operator where you can select: equals, does not equal, greater than, greater than or equal, less than, less than or equal. The right side is the value that you want to compare the left side to. Here is an example of an expression:

In this example, we are using the special variable $this which is used as an element in an array. This expression is looking for any element that is equal to 2. We can make more complex expressions using additional conditionals. Clicking on the blue plus button adds more options like "And", Or", "And()", "Or()". "And": adds to the expression where it must match all of the conditions. "Or": adds to the expression where it must match either of the conditions. "And()": adds to the expression where it must match all of the conditions as well as allowing the user to add an additional set of conditions that are wrapped within the parenthesis. An example, of this would be: and( $this < 100 and $this > 30), so this would find any element that is between 30 and 100. "Or()": adds to the expression where it must match either of the conditions as well as allowing the user to add an additional set of conditions that are wrapped within the parenthesis. Additional filtering can be added to the left or right side depending on the Data Type.