latest posts

Thank you both for your answers. I'll try and build my own model based on your recommendations.

Hello community, what value should be entered when filtering only instances where I participated and me is not assigned to? See picture attached. Thank you

Everything is fine on those mentioned parts, except the data we get in the end. Each instance created from that action, should only have values from those 2 fields that are in the query by my understanding.

Hi,
Can you show a preview of this query with the fields replaced? (You should have columns matching the column names in WFElements, e.g., WFD_AttText1 or WFD_Attint1)

Standord_id - looks ok.
Position - you need to provide "Database field name" without the "- Name."

I can't check right now, but if I remember correctly, these fields should be visible and editable in the attribute matrix at the first step.

Hi, I'm going through data migration process via sharepoint lists and the protocol that I want to achieve it with is by using cyclical actions. I've created an automation that is runing subworkflow(sql) and there is a problem with mapping. Data source has exact values that I need, and I'm using them as intended but the problem is I'm getting data rows I don't want and even then those queried fields are still not applied to created instances after running the action, so that leads me to believing that something is wrong. In the end, instances created are empty and those 2 fields I only used for testing purposes are still not applied.

Whoa, never seen this post, it would made my life easier a few years ago :D

HI Roman,

there's also this knowledgebase post which describes the tables in which the elements of the Designer Studio are stored.

https://community.webcon.com/posts/post/configuration-tables-in-webcon-bps/158/26

This is a bit outdated as the automations didn't exist in 2020. Don't ask how we worked before them, you don't want to know the answer. :)

There's also one other important information.
In English the term "Fields" is used in the Designer Studio but in polish it's something similar to 'Attribute''. As attribute already sounds like English you will see some posts which use 'attribute ' instead of 'field'

Best regards,
Daniel

Hi Roman,
there is a documentation* to the database, but it's not a diagram, if you need the diagram then the best way would be to create one yourself in the SSMS.
Relationships are maintained with proper keys, so the diagram basically builds itself.

Main tables you will need:
* WFElements
* WFElementDetails

* WFDocTypes
* WorkFlows
* WFConfigurations
* WFDefinitions
* WFApplications

* WFHistoryElements
* WFHistoryElementDetails


*https://developer.webcon.com/2025/resources/db/?PageSpeed=off

Hi to all. As a consultant who needs to dive regularly into the database using SQL I'm surprised that there is no physical data model diagram in the documentation. A visual representation of tables and their dependancies provides a very useful overview about how data is structured, maintained and related. In SQL server there is a option to add a new database diagram and thus my question: could Webcon, as a software vendor, provide and maintain the database diagram OR is it up to the implementation team to build their diagrams? Or maybe this is already documented and I'm just missing the link?

Later edit: I wanted to add the post to the „Database” topic but unfortunately it ended up in the „Data Sources” one. If an admin can move it, I will be obliged.

Hi Martin,

there's an ugly workaround for the transport issue.

I've defined constants for each required id. In my case it was application and dashboard.
Then I used a calculated column to fetch the value from the constant using the GUID.


https://daniels-notes.de/posts/2021/deploying-database-scripts#getting-constant-values-in-reports

This blog post is already four years old and we are still limited to the existing variables..

Best regards,
Daniel