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

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings