forum
Hello, we have a huge AdminServiceLog table in the BPS_Config db that is constantly growing. Is it possible to archive or delete these records without causing side effects? Are there further optimization possibilities to avoid large data records in advance or to adjust them afterwards?
Hi, I need to build a process that will work as a service, check a mssql table, and start the process if new rows are added to the table. Single process based on a single row in SQL table. Maybe someone has built a similar functionality? Best regards.
Hi, how use local variables in action Generate/Update a Word file (in word template). We can use variable like {AUTP_Value:384} in html template but, it is possible use it in word template?
Subject: Assistance Needed – Missing "Default Sorting" in Reports After Upgrade Hi everyone, We hope someone can assist us. We recently upgraded from 2023.1.3.29 to 2024.1.1.187 and noticed that the integrated reports on dashboards no longer retain their default sorting. When we attempted to adjust the sorting, we realized that the corresponding menu option is missing _(including normal reports opened over the menue)_. As a temporary workaround, we are replacing the dashboard repo (...)
Does Webcon save the time a user stays in a given process step, i.e. the time from entering the step form to moving to the next step or clicking the save button? I want to make a report out of it to calculate KPIs
Is there a way to set attachments to read only for a certain step? Reason: I have a voting application in which several people can vote on the publication of a new file. The application consists of a main workflow (with a list of the workflow participants) and a sub-workflow for each participant. After the "Start" step, I want the attachment to be read-only. In both the main workflow and the sub-workflows, it should not be possible to add an attachment, nor remove an existing one. Are (...)
Hello, I would like to set a comment as required depending on a value of a data table. Is it possible to make this requirement dependent on a business rule? If so, how would I proceed here? Thank you very much!
hi, I would like to create a calculated column for a report with a list of items. This column, using SQL, should fetch data from another process. I want to map it based on the DET_Att23 ID for each row of the report:: select sum(DE.DET_Value2 - isnull(DE.DET_Value17, 0)) as nn from WFELEMENTS join WFELEMENTDETAILS DE on WFD_ID = DE.DET_WFDID where WFD_DTYPEID = '212' and DE.DET_WFCONID = '5788' and DE.DET_IsDeleted = 0 and WFD_STPID <> '935' and dbo.clearwfelem(WFD_AttChoose55) = D (...)
Hi, I have a problem with action "Update item list values" pointed on path. Workflow is started automatically base on REST API and pointed to the same path. I found information on the log "Number of replaced rows: 0' after start process by REST API. When I use web to start process, action update item list values works fine. When I edit a document created by REST API , action also works fine. Best Regards Tomasz
Hello, I would like to create a new data source in the MSSQL Database category that would retrieve information from a list of values from the form and other attributes on the same form, but I don't know what such a correct query should look like. Currently, my query is only able to retrieve information from the attributes themselves, but not from the list of values. Edit: I found the solution.
Hello, I would like to dynamically hide the clone button. I tried to write a JS function but I have a problem. Maybe someone of you had such a task and can help me. I will be grateful for your help. Regards Miłosz
Hi, I'd like to build SQL query that uses 'current BPS database' and at the same time uses linked server that exists on that server. So I want to do sth like that: Select * from BPS_Content.dbo.WFElements t1 left join [my_linked_server].[database].[schema].[my_table] t2 on t1.id = t2.id Unfortunately it doesnt work. I got an error in Webcon Studio "Access to the remote server is denied because the current security context is no trusted.". Then I tried to execute this query directly (...)
Hi, I try to use this article, but it does not works anymore. https://kb.webcon.pl/przyklady-uzycia-rest-api/ I try to generate a token base on this instruction https://developer.webcon.com/docs/2024.1/api-registration-and-authentication#get-access-token in Postman to api/oauth2/token , example: { "grant_type": "client_credentials", "client_id": "XXX", "client_secret": "XXX", "scope": "HighTrust.Elements.ReadWrite.XXX } I recived error: { "error": "invalid_request (...)
We are having customer who would like to apply annotations to Pdf files. When trying to edit a pdf file in WEBCON BPS the "IT Hit Edit Doc Opener 5" is being downloaded which I installed. Edge tells me that the add-in is installed and on my computer it seems to be installed too. As far as I understand, this add-on should allow to edit pdfs However, when i'm trying to edit a pdf document, the "IT Hit Edit Doc Opener 5" is downloaded again. Has anyone experience in editing pdf's in WEBCON (...)
Hello, is there a guide on how to move both databases and the portal to new servers? I tried to backup the databases, restore them on new database server and then perform upgrade on the new application server, but the installation fails when connecting to the Search Server: 06-02-2025 19:02:51 msg: Step2 src: Upgrade 06-02-2025 19:02:55 msg: Sql version: 14.0.3480.1 src: SqlServerVersionChecker 06-02-2025 19:02:59 msg: Url to Solr: http://[SERVERNAME]:8983/solr/BPS_Activities/query?q (...)
Hi, Everyone! On the WEBCON form (ver. 2025), I would like to display a simple external website for the user. There is no need to save this information in the document. I used Custom control (External) for this purpose. After entering the URL in the attribute properties, the page displays, but I have no idea how to change the size of the control. It is best to change it dynamically depending on the content of the displayed external page. Can anyone help? Is this possible without writing a plug (...)
Hi everyone, I will try to explain the behavior as good as I can but I don't have any explanation for it. Maybe someone else does and has an idea how I can track the 'culprit' / improve the behavior. We have an item list with related documents. This item list has a data row column which outputs an HTML fragment for the current row to trigger a rename function. select '<a class="webcon-button--icon-button" onClick="ccls.renameRelatedAttachment.rename(this)"> <i class=''icon ms-Icon m (...)
Working Area: TEST-Server Hi everyone, i just tested the PUBLIC LINK feature the weekend before, and everything worked fine with my PUBLIC LINK and my private GMAIL-Adress. We want to give unknown guests (except an invitation email) the possibility to log into a step of a specific workflow, press the path button and then lose access to the instance. Today we upgraded to the 2024 Version on TEST-Server and now, with the same App and EMail, i get an error translated to "The verification o (...)
After updating to webcon 2025 every worfklow shows "Failed with an unknown exception Error identifier:" at the start/when reloading the page. The workflow is still usable, however this is still a bit upsetting. When pasting the error code into the administration tools, it says that no error was found. One worfklow however does show an error: ex: WebCon.WorkFlow.Data.Solr.Exceptions.SolrInitException: SOLR not initialized ---> CommonServiceLocator.ActivationException: Activation error oc (...)
I installed a new instance of webcon. In IIS I have new site with 3 bindings webcon-test.domain:.com 80 webcon-test.domain.com : 443 empty :80 Auth provider AD I'm not able to login to portal from the machine where webcon is installed via https/http://webcon-test.domain.com But link http://localhost works fine When I change a server and try to login via https/http://webcon-test.domain.com everythinks works fine. Portal address - https://webcon-test.domain.com
+48 12 443 13 90