> For the complete documentation index, see [llms.txt](https://platform.intelie.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://platform.intelie.com/pipes-queries/dynamic-filters.md).

# Dynamic filters

INTELIE Live supports that the Pipes filters react to dynamic parameters of a query. This is useful to support interfaces that allow the user to change the filters without the need of changing the query expression.

The dynamic values are passed in the `lookupValues` argument of the Query object. This argument is a  `map<string, list<string>>`, where the key is the name of a Lookup Table and the value is a list of the desired keys in that Lookup Table. INTELIE Live will apply to the query the values corresponding to each of those keys.

### Lookup Tables

Lookup Tables are structures that associate multiple values with keys. They can be created  programmatically through the API or through the web interface. A Lookup Table created programmatically will not be editable through the web interface.

![Web interface to manage lookup tables](https://3214244039-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lov7jZs3pzHFyAcuuli%2F-Lp3WebmWrIzuJ3zH-C2%2F-Lp3_XDjPTTyyPXAjapO%2Fimage.png?alt=media\&token=b567757a-01d0-41d9-9a24-454d646d76e3)

### The @@lookup macros

The `@@lookup` macro allows the lookup values to be used on the query. For every Lookup Table created, a `@@lookup.name_of_the_table` macro will be available.

![Example of the @@lookup macros](https://3214244039-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lov7jZs3pzHFyAcuuli%2F-Lp3WebmWrIzuJ3zH-C2%2F-Lp3b8qJiWxaDK6zs4IN%2Fimage.png?alt=media\&token=0906cf7e-e1dc-4783-9f81-d23c28e763bb)

When this macro is used on a query, it will be dynamically replaced by the values corresponding to the Lookup Table keys in the `lookupValues` query argument.

### The lookup functions

Some functions are also created to facilitate the use of the Lookup Tables keys and values on any Pipes query.

![Example of auxiliar Pipes functions](https://3214244039-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lov7jZs3pzHFyAcuuli%2F-Lp3WebmWrIzuJ3zH-C2%2F-Lp3bGLlRMhDNWWzETSP%2Fimage.png?alt=media\&token=512b3134-662c-4033-a236-b1e136fa1fbb)