Rules, JS, SQL
Hi, is it possible to do it via javascript is the main question. i know that this could be done via sdk(c#) and there is already an example guide of it on the forum, but i was wondering would it be possible to create a parser in javascript, that can be loaded maybe by the hotfolders option ?
Hi guys, I'm trying to cyclically start new elements in BPS based on data retrieved from another system. I already have an endpoint that returns the required data. To achieve this, I planned to use a global action (cyclical). First, I created a business rule that fetches the data using a REST API. Then, I wrote an SQL query that utilized this business rule to retrieve the data. However, when testing it, I keep encountering the following error: WebCon.WorkFlow.BusinessLogic.BusinessRu (...)
Is there a simple way to get the URL of the current instance? Use Case: In a specific step a user can create a ticket (via menu action) in a 3rd party app (REST POST). In the request body of the rest call I create the json and want to submit also the url for this instance. Thanks! Ernst
Hi all! Is there an easy way to list all the privileges (and scopes) for applications, processes, associated form types, dasboards and reports? Maybe someone already wrote a query for that or can point us in the right direction? Thanks a lot in advance & best regards, Nik
I have some form rules that have parameters, i would like to trigger them in a javascript/formrule javascript. However it seems there is no way input the parameters when invoking the form rule. Does somebody know a way to do this?
Hi, I'm having a dilemma about comparing two date objects. My thinking is when I do sql queries to retrieve data from objects it will give you already stored db results, but with webcon functions you actually get value before it is actually stored. It does not work this way, so i'm looking for a way to do it. In conclusion, it should compare date before change and after change (this is triggered on menu action SAVE).
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 (...)
+48 12 443 13 90