latest posts

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

Hi Adam,

thanks for the info. Now I need to create a new bookmark. :)

Best regards,
Daniel

Yes, thanks!

Dear Community,
If you've encountered issues accessing https://uifabricicons.azurewebsites.net, it's not a bug - it was locked. This site is intended for internal use only (restricted to Microsoft employees?).
Source: https://github.com/microsoft/fluentui/discussions/35051#discussioncomment-14286716

Fortunately, there's an alternative you can use to browse Fluent UI icons:
https://developer.microsoft.com/en-us/fluentui#/styles/web/icons

While I can't guarantee long-term availability or full compatibility, it should serve as a helpful workaround for now.
Just wanted to share in case it helps!

Thanks for the explanation Adam — that makes perfect sense. I’ll set up a simple script to warm up the app after each restart. Appreciate your help!

However, I'm still experiencing the issue with LicenceService timing out. Attaching the Event Viewer log if that helps somehow.

Martin,
Yes, the first page load after a server restart in IIS is slower due to what’s known as a cold start — the web application must fully initialize before it can serve requests efficiently. While there are ways to reduce this delay, some form of cold start overhead is unavoidable.
To help mitigate this, consider creating a simple script that runs after each server restart to trigger an initial request to the site (e.g.,  curl -I https://yourWEBCONserver/). This proactively warms up the application so that users experience faster response times for subsequent visits.

Best.

Hey everyone,

I have two reports — one for Vessels and another for Shipments.
On the Shipments report, I’ve set a URL filter like this:
VESSEL_CODE = vesselCode

Now I’d like to link these two together.
Basically, I want to add a column on the Vessels report that links directly to the Shipments report, automatically filtered by the vessel’s code (using the URL parameter).

Ideally, the solution should also work when exporting/importing the process between test and production environments.

Has anyone done something similar or found a neat way to pass parameters between reports like this?

Thanks in advance!
Martin

Unfortunately, disabling AUTO_CLOSE didn’t solve the issue.

One more detail: after a server restart, the Webcon Workflow Service takes a few minutes to start — not a big deal. However, once it’s up and running, the Portal still takes about 60 seconds to open on the first visit. Is that normal behavior?