WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > User profile Jacek Wojnar > Forum messages

Jacek Wojnar

User

Data source for data table
21.05.2026 14:34

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 wri

Hi Martin, Good point. I completely forgot about that :-) Regards, Jacek

Remember to add the condition ATT_IsDeleted = 0 to the SELECT (otherwise, you'll also see deleted attachments). As for the link, you can try fiddling with /api/nav/db/1/attachments/xxxx/preview?hash=0 where xxxx is the ATT_ID.

Hi, You can use a calculated column and create a subquery to the WFDataAttachmets table where you have the attachment details.

Hi Filip, I'm not 100% sure but that's what it looked like in my tests ;)

Hi, if you mean the X from the screenshot, it appears if there is more than one output path from the step (the user has a choice)

Hi Celina, I wanted to add that deployment mode can also be enabled for individual processes :-) https://docs.webcon.com/docs/2025R2/Studio/Process/EmailNotifications/

Hi Celina, Yes - you can use "Deployment mode" https://docs.webcon.com/docs/2025R1/Studio/SystemSettings/GlobalParams/EmailConfig/SystemSettings_EmailSetting#3-deployment-mode

I was also surprised that it didn't work by default ;) In your case, you need to add "ESCAPE '!'" at the end. Try: AND WFD_AttText1 LIKE '%![JOB!]' ESCAPE '!'

Hi Sebastien, This is probably because MS SQL treats [] as wildcard characters: https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/like-entity-sql# A workaround is to use the SQL filter: >Your column< like '%![JOB!]%' escape '!' Regards, Jacek

Hi Stefan, First, you don't need a system step to send an email. Just add an action to the path. A system step is used to, for example, make your instance wait for another event (other workflows, APIs, integrations). If you want/need to use a system step, you can exit it with a timeout action (e.

Hi, I understand. In such a situation, the [Form fields] tab will indeed be useful :-) A workaround (besides using JavaScript mode) could be to create business rules that return the list ID and/or column names - [Form fields] is available in business rules.

Hi Sebastien, What do you need to achieve? Attributes are available, but in JavaScript mode.

Timer offset in minutes
13.03.2026 13:02

Hi Sebastien, I agree - the unlock option in the "offset" field sounds good :-)

Timer offset in minutes
12.03.2026 14:31

Hi, You can try creating a technical field, e.g., "timeout start time". Set it on the path with a value of +75 minutes from the current date and time, and in the timeout configuration, set this technical field to [Start date] instead of [Step entry date].

Problem with timer
11.03.2026 20:51

Hi Łukasz, This timer is set to the ENTRY into the step. Have you made a path move on the specific document you're testing this on? Regards, Jacek

Hi Tomasz, You can try use the SQL command and REGEXP_SUBSTR (SQL Server 2025 required). In older versions of SQL, you can use PATINDEX e.g: DECLARE @text NVARCHAR(200) = 'Company details: NIP 1234567890, ul. Testowa 1, Warsaw'; SELECT SUBSTRING(@text, PATINDEX('%[0-9][0-9][0-9][0-9][0-9][0-9]

Selecting addresses by SQL
28.01.2026 09:23

But now you can see that the query is targeting the correct database because you have the correct WFD_Attchoose2 column in the result :-) You need to check if you're actually looking for the correct data in the WFD_AttText1 field (for example, if there are any spaces). Could you screenshot this q

Selecting addresses by SQL
27.01.2026 13:57

Hi, try changing the [data source] to the default BPS database

Automatic document preview
09.01.2026 08:31

Hi Joanna, you can use this option (screenshot)