forum
Hi Folks, whenever I try to execute [Menu button] action, which should open a hyperlink, I get an error: "Error in Menu button action Start Counterparty Card. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_WFElementDatails_WFD". The conflict occurred in database "BPS_Content", table "dbo.WFElements", column 'WFD_ID'. The statement has been terminated." I have exactly same button configured in other workflow in the same application and it works fine. It is irrelevant wha (...)
Hi I have a question. I want to return all weekend days in SQL for my form validation. This is my SQL Code that returns these days, but only for the current month: WITH Dates AS ( SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS DATE) AS DateValue UNION ALL SELECT DATEADD(DAY, 1, DateValue) FROM Dates WHERE DATEADD(DAY, 1, DateValue) < DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0) ) SELECT DateValue FROM Dates WHERE DATEPART(WEEKDAY, Date (...)
We would like to run a PowerShell script periodically, to prepare data for selected cases in one of our interfaces. BPS Studio version 2023.1.3.202 doesn't give us an option to add that type of action in global actions (configured for the process). So currently we have to use a task, that is configured in TaskScheduler on the application server, to run it. Is there an option in BPS Studio to run a PowerShell script that is not connected to only one particular case data? Are there any plans to (...)
Hi guys, i just have another question... we need to create an Excel file from an item list. Basically, this works well using an appropriate Excel template. However, I have fields in the item list that are filled from a fixed value list and the action then creates an entry in the column in the format [ID#Name]. But I only want to see [Name]. What am I doing wrong?
Hello, We moved from 2021 to 2023 version of webcon and now we have a problem with initializing item lists in preview mode. When in edit mode everything works fine, but in preview mode item lists do not initilize. Is there a way to achive such a functionality. What was the reason to change it ?
Hello there! We are encountering a similar issue as described here: https://community.webcon.com/forum/thread/4743?messageid=4743 Despite checking everything, we still haven't found a solution. After a few seconds, the license service stops and gets disconnected... The problem seems to be: The connection is initially established but after refreshing a few times it gets disconnected. How can we resolve this issue? We have already set the TCP inbound rule to 8002. The system time is (...)
Hi everyone, Jarosław created a threat in which he points out that <buttons> elements are no longer rendered if they are used in an item list data row column.: https://community.webcon.com/forum/thread/5247 I tested the most common/likely elements and to verify which are supported by using this SQL query: select '<a>a tag</a>' + '<br/>'+ '<button>button tag</button>' + '<br/>'+ '<div>div tag</div>' + '<br/>'+ '<i class=''ms-Icon--EditContact ms-Icon'' title=''In Bearbeitung''></i>' (...)
Hi guys, is it possible to display a dynamic tooltip/information via the description on a form field? I should display a value including VAT on a value field that has no VAT and i don't want to use a new field. e.g. something like that: "Amount incl. VAT : {FD:166} * 1.19" Is there perhaps another way to display a tooltip on a form field other than via the field description?
Hi guys, Is there an easy way to copy content from one process to another, e.g. using the WFDID? For example, to copy the content of a text field from process 1 to a text field in process 2 using an action. Our users would like to have a feature to copy content from older processes to current ones if it is similar content. A kind of "copy template".
Hi, I've prepared a template using Word Classic and put there data rows and data tables fields. Unfortunately the data are not displayed. The same situation happens when I go to Admin Mode > Admin actions > Word Template Printout. No data from data rows/data tables fields are diplayed. I am using Webcon Express.
Hello Where can I find for download webcon ver. 2024 regarding this https://community.webcon.com/posts/post/webcon-bps-2024-downloads/458/10 There are many other artictles for version 2024 but with no links to download.
We use in one of our applications the option to generate HTML code (for example extra buttons performing some actions) in list item lines. For this purpose, data row field type was working well. For example such code: SELECT '<span style="margin:2px;"><button onclick="startAccessRequest( ''{SI:3201}'' );" style="font-weight:bold; color:green; font-size:12px; text-align:center;">➕</button></span><span style="margin:2px;"><button onclick="startAccessRemoval( ''{SI:3201}'' );" style="fon (...)
Hi, I am currently working on some tool management workflow in WEBCON and I have a problem. I have an items list with REST API as data source where user can pick and book tools for some time period. Time period property is not included in REST API so I'm using form fields for booking dates. Then I need to filter the items list using tools from REST API and dates from WEBCON database to exclude unavailable tools. Unfortunately i didn't find the way to do it using the REST API filter available in (...)
Can I delete business entity ? Even if not active, it's being used like everywhere, where the "business entity" field exist or any start with list is used.
Hello all, I'm not sure if this is something that changed in the versions or I'm missing any configuration. I checked that users with the access 'Access and Edit all Instances' are allowed to select Available Paths even if they're not the assigned person. I know that although having the rights to edit the instances, it couldn't be moved and that yellow message was shown because another person was the assignee. This is not happening in my processes and I'm not sure if that was something ch (...)
Hi everyone I started using Webcon in May, so I'm pretty new to everything. I'm trying to setup an internal process to move and lock Active Directory users. This involves moving the user to a different OU, but I can't seem to find this option in Webcon (other than executing Powershell which I'm trying to avoid for security reasons). Does anyone have experience in this? Greetings from Switzerland Raymond
Hi, I have a choice field with SQL data source connected to it. Is it possible to create a link (into the choice field) to a selected element like as in the case of BPS Internal view? Simplify, I need the same option as in the selected screenshot but for the sql data source.
Hello all, This might be a very simple question! I'm trying to set up a calculated date field using a concat function and then a text to date in order to format it to date, but I'm keep having an error saying that String '7/3/2024' was not recognized as a valid DateTime. It looks like the conversion function is not working. Do you know if that only works if selecting a field? Meaning, I need to create the concat information prior and then use the field in the conversion? Thank you
Hi, I tried to import an application from the development environment to the production environment and got the error: "Check if the import service role (part of the core roles) is running for the current databases". Has anyone had this error? Thanks, Raluca
Hi everyone, maybe someone of you has a guess what we can do. - We have an environment with 6 content databases - We have a process which manages the members of a BPS group. - We use the Add/Remove single user to BPS groups to add a single user in synchronous mode (1) - Even so the action times out after 50 seconds it's marked as completed successfully in the history (2) - The duration of the corresponding synchronization of took about 2 minutes (3) - According to the 'Details' the sy (...)
+48 12 443 13 90