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

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.