Home > Forum > General > Data source for data table

Data source for data table
0

Hello everyone,

What is the best way to create a “data table” form field that accesses data from another WEBCON app?!

I would like to build a WEBCON application in which project reports are recorded. Visit reports are recorded in another application.
Now in the workflow of the project reports, on each page of the individual steps, I always want a small data table for visit reports that were created with reference to this project. Conversely, I would like to have a similar table in the visit reports,
so that thesalesmanagers can always see which projects the customer is currently involved in when recording a visit report.

When I create the "Data Table" form field I can select a data source. However, I don't know what the data source is called,
into which the visit reporting application writes its records. Where can I see where every created workflow record is saved?

Thanks in advance and greetings,
Matthias

MVP

Hi,
You can use the BPS data source: https://docs.webcon.com/docs/2025R1/Studio/ConnectionsAndDataSource/DataSources/DataSource_InternalBPSView
Remember to add associations for other applications in which you want to use this data source ("Association and security" tab).

You can also simply write an SQL query on the WFElements table, which stores the header data for all workflows (from all applications).
https://docs.webcon.com/docs/2025R1/Studio/ConnectionsAndDataSource/DataSources/DataSource_MSSQL