Skip to main content

Celonis Product Documentation

Advanced: Forward filter through the URL (e.g. from an Analysis)

You can open a view with a specific set of selections by adding the encoded filter string in the URL.

We will show this functionality at the example of creating a dynamic link in analysis and opening a board with the temporary selections.

41194512.png

Add a Button in an Analysis and set it to "open external Link"

For the URL use the URL of the view you want to open and add ?filters=<%=$CEL_ACTIVE_FILTERS% > at the end. This will use all Selections, but not analysis, sheet or component filters.

41194513.png

Following this link will now open the view with all current selections. If the user had custom user-based filters (so not filters set in the YAML configuration) those will be deleted before opening the view.

41194514.png

If you want to use this functionality somewhere else, the added string is simply the filter statement (FILTER "table"."column" = 'string') BASE64 encoded.

Tip: Use this encoder to encode your filter https://www.base64encode.org/

Example:

https://team.realm.celonis.cloud/package-manager/ui/studio/ui/assets/a664e4f7-40a9-4337-9209-22e2f5b5ee97?filters=JABDAEUATABfAEEAQwBUAEkAVgBFAF8ARgBJAEwAVABFAFIAUwA%3D

Gif explaining the workflow

60363156.gif

Limitations:

As the input for the filter is derived from the base64 encoded filter in the link, the filters are static and it is not possible for the user to update the filters or get dynamic input from the user to update the filters.

Using a "." in the filter statement string currently creates an issue in the decoding and leads to a filter statement in Chinese characters.