I have almost found working solution, but I'm facing error which was described in the forum already few times.
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:
Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Location: saw.views.evc.activate, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 27002. [nQSError: 27002] Near <)>: Syntax error (HY000)
State: HY000. Code: 26012. [nQSError: 26012] . (HY000)
doesn't matter what OpCo you will select.
Filter (set as SQL) used in target report, which is causing problem:
"CC - Business Unit"."Business Unit - OpCo" IN (@{PV_SELECTEDOPCO}['@']{"CC - Business Unit"."Business Unit - OpCo"})
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.