Rules, JS, SQL
Hi, Does anyone know how I can view the history for the "BpsUsersGroupRelations" table? I want to find out if a person was in the specific group. Thanks, Raluca
Hi everyone, I have a scenario where, in one of our workflows, we use the “Move Workflows (SQL)” action on a transition path to update multiple workflow instances—often dozens or even hundreds. Each of these updated workflows executes several actions upon transition, including making a REST API request to an external system. The issue arises when, for example, out of 150 instances, 140 complete successfully, but the 141st encounters an error. In such a case, all changes within the workflow (...)
Does someone know how to fix this problem? The cleaner fills our sql server with error messages that took 20gb of space after few days. This Error occours even when using a different version and virtual server.
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 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 (...)
As the title says, i can't figure out how to add a newline/empty line. To give more context, the user can input what he wants in this field, there is a button that should add a text at the bottom of the textbox, however the text appears besides the user inputed text and i just can't figure out how to change the formrule for it to appear in the nextline without javascript. I appreacite every help i can get.
Is it possible to use process constant in js mode, same way as we would use it in form rule ?
You can easily find info about changes and who and when changed the lock of enviromnent select CHD_ID AS [Change_Id] , CHD_CFCID [Changed_object_code] ,case when CHD_OldValue = 0 then 'Unblocked' when CHD_OldValue = 1 then 'Blocked' end as [Old_value] ,case when CHD_NewValue = 0 then 'Unblocked' when CHD_NewValue = 1 then 'Blocked' end as [New_value] , CHR_TSInsert as [Date of change] , CHR_RowID as [Row change] , CHO_CreatedBy as [Who changed] from ChangeDetails join ChangeRow (...)
Hello community. In my application, I would like to have stopwatch. • Stopwatch should starts and run when the form field with stopwatch is visible and stop when not visible. It should be visible through few steps. When not visible, it will reset. When visible again, it will start again. Alternatively, • JavaScript, HTML, CSS stopwatch with buttons (Start, Reset are enough). Are these requirements feasible to be done in WEBCON? I know, in WEBCON: • There are an HTML form fields, (...)
Hello everyone, I’m still learning how to use JavaScript effectively with WEBCON BPS. Currently, I’m working on a project that involves an HTML button/JavaScript triggering a file download at the end: JAVASCRIPT: // Save the PDF and offer it for download const pollerPdfBytes = await pollerPdf.save(); const blob = new Blob([pollerPdfBytes], { type: 'application/pdf' }); const url = URL.createObjectURL(blob); const link = document.createE (...)
ORIGINAL SUBJECT WAS: Assistance Needed – Retrieve "Content as Base64" for All PDF-Attachments of an Instance Dear All, I am currently looking for a way to extract the "Content as Base64" for all attachments associated with a specific instance. My goal is to obtain a single text line in the following format: 'Base64 PDF 1', 'Base64 PDF 2', 'Base64 PDF 3'. -> The easiest way would be to use built-in tools, but unfortunately, that doesn’t work (CONTENT AS BASE64[GET ATTACHMENTS]) After (...)
As the title states, there are some autocomplete fields(with values in them that cannot be found) i have that prevent me from moving to the next step(in one case i would maybe like to "cancel" the subworkflow/return with negative). I tried to deactivate the form field validation on the paths, however the error still occurs.
Good day webcon community, As the title states, i ask myself if javascript is faster than using formrules. As example i had a formrule what would get the sum of a number column in an item list and compare it to another field. It took sometime for the formrule to procress this, while my javascript that i wrote in a html element did it much faster. I wonder now if i should reimplement certain functions with javascript instead of using formrules to shorten the page loading time. So can someo (...)
Hi i have a task to extract formfields from all the applications that has like this makred. Can anybody help? would be much appreciated
Hey everyone, I have the following challenge. I'm storing travel expenses in an item list. The expenses could be in various currencies. I'd like to get the exchange rate automatically for each row (because the exchange rate might be different for different dates and currencies). The API GET call is: https://kurs.resenje.org/api/v1/currencies/<CODE>/rates/<YEAR>-<MONTH>-<DAY> I have <CODE> in DET_Att6 and the <DATE> in DET_Att3. The response is a JSON: { "code": "USD", (...)
[Webcon 2024.1.1.130] (i thin it was working in 2022.1.4.404 - but I need double check] I have action to update item list where source is Parent Item list. The sql query is working but filters .. works if there is no polish letters :| so: [code='SQL'] SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL:1135} AS 'Sygnatura Audytu', d.{DCNCOL:1132} AS 'Tytuł raportu 8D', d.{DCNCOL:1131} AS 'Norma', d.{DCNCOL:1128} AS 'Punkt normy', d.{DCNCOL:1126} AS 'Opis', (...)
Hello everyone, we are using JavaScript for a RestAPI call (long story – it's a requirement from IT). Now I receive the "Response Status Code" and "Response Text" within the JavaScript, but I also need to send these values back to WEBCON for further processing. Since we usually work with WEBCON without using JavaScript, I’m lacking the necessary know-how in this area. Can anyone assist me with this? Thank you in advance! Wishing you all a great weekend, Bjoern
Hi, I have a problem with 2024.1.1.114 and SDK execution. I created an SDK to connect to the SAP and download data from the chosen contractor. The SDK was working from version 2022 to 2023 with some updates to c# code - after updating Webcon and SDK to 2024 i received the error: ERROR -> Plugin changed transaction nesting count. Please contact administrator. Interestingly, when I connect the VS debugger to the portal, the error does not occur and the SDK downloads data to the form. (...)
What is the possible and if, the most efficient way of getting data from a dictionary into a js file that is supposed to read all the items from said report ? SQL(business rule, then convey it to the js file as an argument) or we can natively do it in js ?
+48 12 443 13 90