topic Re: Filter tokens based on Row depends and Row Rejects in Dashboards & Visualizations

Filter tokens based on Row depends and Row Rejects

Muthu_Vinith — Sat, 09 Mar 2024 17:48:48 GMT

Hey Experts,

I am encountering an issue with using filter tokens in specific row on my dashboard. I have two filters named ABC and DEF, tokens represented for ABC is $abc$ and DEF is $def$.

I want to pass these tokens only to one specific row, while for others, I want to reject them.

For the rows where i need to pass the tokens, I've used the following syntax:

<row depends="$abc$ $def$"></row>

For the row where i don't want to use the token, I've used the following syntax;

<row rejects="$abc$ $def$"></row>.

However when i use the rejects condition, the rows are hidden. I want these rows to still be visible.

Any help or example queries would be greatly appreciated. Thank You!

Re: Filter tokens based on Row depends and Row Rejects

richgalloway — Sat, 09 Mar 2024 22:14:36 GMT

The depends and rejects options control visibility of the element. That is the only function of the options. To use a token in an element, just invoke the token name within the element. There is no need to "declare" the token as one might in a programming language.

Re: Filter tokens based on Row depends and Row Rejects

bowesmana — Sun, 10 Mar 2024 23:26:33 GMT

Note that depends and rejects take a comma separated list of tokens, not a space separated list.

Re: Filter tokens based on Row depends and Row Rejects

Muthu_Vinith — Sun, 10 Mar 2024 23:34:56 GMT

Yeah the tokens are in comma separated, but the only thing is when i use rejects condition the rows are hidden. How to fix that? @bowesmana

Re: Filter tokens based on Row depends and Row Rejects

richgalloway — Mon, 11 Mar 2024 00:10:29 GMT

That's the way rejects works. When the token has a value, the element is hidden. To make the element always visible, remove the rejects option.

Re: Filter tokens based on Row depends and Row Rejects

Muthu_Vinith — Mon, 11 Mar 2024 09:41:40 GMT

Is there any ways to create a new token where i can pass it to filters (i.e ABC and DEF) and rows? @richgalloway @bowesmana

Re: Filter tokens based on Row depends and Row Rejects

richgalloway — Mon, 11 Mar 2024 14:44:41 GMT

In Advanced XML, all tokens are global in scope so there is no need to "pass" them.

Re: Filter tokens based on Row depends and Row Rejects

Muthu_Vinith — Mon, 11 Mar 2024 15:20:45 GMT

So how can i use <change> condition in my case. Any example queries would be greatly appreciated @richgalloway . They told to create a new token and pass it to filter and row.

Re: Filter tokens based on Row depends and Row Rejects

richgalloway — Mon, 11 Mar 2024 16:25:58 GMT

Who told you to create a new token?

What problem are you trying to solve? I think I need a bigger picture so I understand what is happening and how to get it to work.

Re: Filter tokens based on Row depends and Row Rejects

Muthu_Vinith — Mon, 11 Mar 2024 16:47:21 GMT

@richgalloway .Please check your inbox

Re: Filter tokens based on Row depends and Row Rejects

richgalloway — Mon, 11 Mar 2024 19:23:46 GMT

I'm having 5 filters in that, I've two filters called group and class for group token=$group$ and for class=$class$.
For group and class filters only one specific row that is SQL having values, others rows does not have values. if i pass token $class$ and $group$ in SQL. I'm getting results, but when i pass these tokens to other rows, it will be zero, because there is no values for class and group.
But i want to show other rows also but $class$ and $group$ token should be rejected because other filter having values for these rows also. So only i'm asking we can use depends or rejects. Please I need your help to solve this.

The depends and rejects options control the layout of the dashboard; they have no effect on the content of the dashboard panels.

Can you share the code in which the tokens are being used? That may help with my understanding of the problem and allow me to make a useful suggestion.

Re: Filter tokens based on Row depends and Row Rejects

Muthu_Vinith — Tue, 12 Mar 2024 03:08:14 GMT

I've used tokens in the base search itself. Except class and group filter. I need to enable these two tokens for SQL row and need to disable it for others. @richgalloway

Re: Filter tokens based on Row depends and Row Rejects

bowesmana — Tue, 12 Mar 2024 05:46:24 GMT

You are only providing keyholes into your problem domain - we need to understand the bigger picture as @richgalloway says to understand what your problem is.

Can you provide your existing XML and/or searches showing the fields you are querying - please ensure the data is sanitised, so it can be posted here.