Action links - passing presentation variable using Navigate to Web Page

aPsikus

Thank you.

I guess that in first suggestion WHEN for All Column Values is not needed, as null will handle this.

In second option I think that THEN is missing in case

What I have found, CASE is not needed. But also tutorials are wrong.

Filter can look like this: "CC - Business Unit"."Business Unit - OpCo" IN (@{PV_SELECTEDOPCO}['@']{"CC - Business Unit"."Business Unit - OpCo"})

Default values should be column name from model, instead of value. That is the reason why there was error Nonexistent column: "A".

When we will select 'All Column Values', it will display default which is for all values, if we select any values it will use variable.

But now I have other issue.

Doesn't matter if I will use your CASE proposition or proposed above, when opening from dashboard for the first time, there is error:

When I will get back to prompt screen and press Apply once again, second opening is without problems.

Any suggestion what is going on?

Robert Angel

That sounds like cache, I would clear your cache, and in development in the advanced tab selection the option to bypass generally, it saves a lot of pain - in development...

aPsikus

But this Bypass option can't be saved, right?

How to implement it correctly?

Robert Angel

Hi,

your error won't persist once the cache is cleared, this is just to get over the short term issue.

aPsikus

Clearing cache didn't help

Robert Angel

Okay, when you said - "When I will get back to prompt screen and press Apply once again, second opening is without problems." is this with all things the same, does just clicking apply again with no other action clear the error?

Robert Angel

I would double check your syntax too, there have been recent posts in a similar it errored, then on refresh it didn't and typically there was an underlying syntax issue, strip the syntax back to basics and reapply piece by piece and see what causes the error to manifest.

aPsikus

Hi,

Dashboard is created that way, that we have main page with dashboard prompt, and other tabs which has reports filtered based on prompt.

Mandatory fields are Month and OpCo.

Month is default to previous month, and OpCo need to be selected by user.

So user, is selecting filter values, pressing Apply and click Tab which he wants.

All reports work fine.

On one of the pages there are Performance Tiles, to which I'm trying to add Action links.

In the first run when you will choose report from Action link it returns syntax error, doesn't matter what OpCo you will select.

What we have noticed, that if you will get back to page with prompt, doesn't matter if you will change filter values or not, but will press again Apply button, after going to page with Performance Tiles and opening Action link, report will be executed without any error and filters will be passed correctly.

aPsikus

Finally I have solved the problem.

Causing a problem was protected filter for OpCo is not null which was passed from Performance Tile.

When I have removed protection, everything is working fine.

Looks like in such case protected filter is passed as only one to target report, and is overwriting is prompted and variable in target report.