Home > Forum > Rules, JS, SQL > Reports / SQL question to compare 3 items 2 types

Reports / SQL question to compare 3 items 2 types
0

I have got 3 different flows but on each flow I have got the same data in one variable (key).
in flow 1 is Signature
in flow 2 is WFD_AttChoose5 {72}
in flow 3 is WFD_AttChoose6 {692}

how to do SQL request or more interesting is how to do report where I can:

filter Signature = WFD_AttChoose5 {72} = WFD_AttChoose6 {692}

In Webcon reports I don't see process fields if I add 2 or more processes to report :/
so I can't do filter on request :/

so maybe in Source create Source by SQL requests ... and then put it to Reports ... but again I don't see option to do that :/

Any suggestions?

MVP

Hi Paweł,

as you noticed, a report can only display process fields, if a single process is selected. One exception to this are global fields.
You have the option to add a calculated column to retrieve other information.
Depending on the number of calculated columns and the complexity of the SQL command it may have a negative impact on the performance.

If you play around with calculated columns, you can activate the diagnostic mode to view the executed SQL.


Best regards,
Daniel