How to present more than one "Item list" in Webcon report or any other report in Excel/RS

0

Hi Stanisław,
it really depends on your needs, you can do join on elements, filter the WFElementDetails table by DET_WFCONID column etc. there are many possibilities.
Play around with SQL, database documentation will be helpful - https://developer.webcon.com/2021/resources/db/

For example, if you want to select column from 2 separate items lists:
SELECT DET_Att1 FROM WFElementDetails WHERE DET_WFCONID in ({WFCON:<id1>}, {WFCON:<id2>})

You can use such queries in data table atributes.

I do it like this: The report contains form fields as columns AND columns from the item list. This way however you should be aware, that if your items list contains 3 rows, there will be 3 rows in the report - each containing specific values from each list row, and the same values "outside" of the items list.

Hi Stan,
In version 2021 you can generate a report with all rows of item list I believe.
In SQL/RS I use (for predefined number of rows and rows names) separate SELECTs, example for 2-column list:

(SELECT DET_Value3 FROM WFElementDetails
WHERE DET_WFDID=WFD_ID /*binds with element*/
and DET_WFCONID=xxx
and DET_Att1='ROW_NAME_1') AS ROW_NAME_1
,(SELECT DET_Value3 FROM WFElementDetails
WHERE DET_WFDID=WFD_ID
and DET_WFCONID=xxx
and DET_Att1='ROW_NAME_2)') AS 'ROW_NAME_2'
,(SELECT DET_Value3 FROM WFElementDetails
WHERE DET_WFDID=WFD_ID
and DET_WFCONID=760
and DET_Att1='ROW_NAME_3') AS 'ROW_NAME_1'