...
| Info |
|---|
NOTE: Unlike our other data lookups, we don’t need to specify the name of our table since there is only one data table that contains our competition data. |
ALL or ANY
Our competition data lookup will involve one or more conditional clauses and our filter option will determine how they are used with our search query:
...
| Info |
|---|
NOTE: Multiple conditional operations can be defined by using the Filters option on the Data Lookups panel. It provides option for a single condition or multiple conditions. |
Filter Operations
With the Competition Data Lookup, we have the ability to create multiple search conditionals and even pair them together into AND and OR combinations. Each filter operation is comprised of these elements; target attribute, relational operator and comparison value.
...
3. Comparison value, displays the numeric or character value that will be used for our filter comparison.
Live Preview
The Live Preview will contain both the set of rows from the competition table and the results data lookup based on your search criteria. In the following example, we are using ALL option, filtering on product A9N17518 and seeking Average of all competition. Therefore, out Live Preview panel will appear as:
...