Hello everyone In a process I run a cyclic action in the Global Actions. This action contains a "Start a subworkflow (SQL)". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the SQL query of the subworkflow action... So now I am facing the mystery where exactly this error occurs at all and what exactly is the cause. Does anyone know where I can find more information about t (...)
Hello everyone, I need your help with a task that should actually be relatively simple. I'm trying to establish a connection to my Site Collection in SharePoint and have entered the relevant data (Server and Site Collection, User, ...). When I click on "test", it loads for several seconds, and I get the error: Unable to connect to the remote server. Regarding my rights in SharePoint: I am the owner of the Site Collection. What could be the cause of this? Thanks in advance!
I'm trying to connect to Webcon with Power Bi. Service I set up OData user and API key as described here https://community.webcon.com/posts/post/odata-format-in-webcon-bps/346. I do not have a problem to connect using Power Bi desktopapp but after uploading report to Power Bi service there is a problem with refreshing although I set up on-premise gateway on Webcon vm - invalid credentials. Has anyone tried to connect from Power Bi service to Webcon on premise server?
Hello Does Webcon 2023 work with SQL 2022? Native or with compatibility db level 2019?
Good morning everybody, did anyone of you managed to change the pencil color of the "HANDWRITTEN SIGNATURE" FORM FIELD ? Thanx and a nice, sunny weekend (not here ;-) ), Bjoern
Changing the RestAPI mode to "admin" should allow you to update fields, including readonly. The documentation however mentions the requirement of "admin permissions" How to add requires admin permissions?. Below are excerpts from the RestAPI documentation mode -Enum: "standard" "ignoreReadonly" "admin" Optional mode parameter that specifies validation behavior. When empty or standard, all fields will be validated. When set ignoreReadonly, readonly fields won't be set but no error will be (...)
Hello, Is there a way to ensure uniqueness of items in Webcon's dictionary when importing data from Excel, to avoid duplication? Thanks.
I have request from business to create report that will be showing all instances , which current logged user had task to do in the past. Some user can have more than one task in workflow. Is it possible to prepare such report and in SQL filter make a join statement similiar to this: SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY [WFD_ID] ORDER BY WFD_ID DESC) rn FROM [BPS_ConfigProd_Content].[dbo].[WFElements] LEFT JOIN WFElementTasks ON WFElementTasks.WFT_WFDID=WFD_ID (...)
Hello, Can you assist me with the following? I'm attempting to test an outgoing/sending email but receiving an issue during the installation and setup of the webcon bps. I'm now working on WEBCON BPS 2023.1.1.89 demo version. Error image attached.
Hello everyone, I have a question for you, maybe you can help me. I know you can set user privileges for each application or process separately, but I wonder if I can also restrict user visibility depending on some criteria.. For this scenario I've created: BPS user group: Software Engineer person X, person Y, person Z are part of software group Let's say there are also multiple projects and their details into a db: project 1, 2 and 3. process: Project update , each update process w (...)
Hello community, I am building application with one Dictionary process, and one standard process with 2 workflows. I would like to start second workflow many times as subworkflow of fist workflow and assign it to the several users/users groups (one per subworkflow) selected from Dictionary process. I am trying to use action “start a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – Query returning data) works as follows: SE (...)
Hi, Is anyone having trouble calling a PowerShell script that connects to MsolService? After updating WebCon to version 2023, the action calling the script ends with the error as below.
Hello, I am experiencing a problem with my SharePoint connection, which had been working properly until today. I've tried with multiple users and it is not working, same error. Webcon version 2022.1.4.174 If there is MFA enabled, is there a problem? Because it worked with MFA enabled. Any ideas?
Hi Guys I need your help. I start tasks based on a workflow but attachments do not transfer. If I do it manually as a action on path then the attachments move to subworkflow and its ok. But if I use a cyclical action to call the same action -> "create SQL subworkflow", tasks are created but without attachments :/ Example in the attachment, I trigger the same action: Uruchom zadanie TEST (en: Run the TEST task) I use version 2022.1.4.223
Hi, I need to add an event to the AAD group calendar. Webcon uses/is synced with local AD. AD is synchronized with AAD. On the AAD side, an application with API permissions has been added Adding AAD groups and adding users to groups via graph API from webcon works fine. But, for example, if you want to add an event to the group's calendar POST method https://graph.microsoft.com/v1.0/groups/{group_id}/calendar/events The api needs to run in the context of the logged in user, not in th (...)
Hi, I have a problem with the execution of SQL queries in different environments using a Default connection (after moving the system to AZUR-e servers). SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parameter that causes the execution of TEST SQL may be different than the rest of the environments? (...)
Hi, We have upgraded to ver. 2022.1.4.248 and I found the problem with language translations for the dropdown choice attribute. It seems like it does not translate just for dropdown - other types of choice attributes work just fine. Has anyone encountered a similar problem? 2022.1.4.248
Hi, I have a problem installing upgrad. I get a message : "User 'public' does not have permission to run DBCC CHECKIDENT for object 'ActiveTasks'. Anyone know what's going on and how to solve it?
I have a choice field and it is populated from a data source with autocomplete activated. I want to limit the choice field to only the data from the data source. The user can't manually type any other text. How can I accomplish this?. Thanks
Hello, Does anyone know if it is possible to achieve the following functionality: - I would like to insert a button in an item list column. I can achieve that so I don't need help with this (WebconBTN_01.png). This code produces the kind of button from WebconBTN_02.png image. - When this button is clicked, I want to set the DET_Att1 (it's a Yes/No field) to 1 (not run the action from the screenshot). Can someone help me out? Can this be achieved with javascript? If yes, how? Thank yo (...)