forum

Portal reports: Process columns from multiple worflows?

0 2

Hi all. I have the requirement to create a report that aggregates process columns from multiple workflows. In the portal report configuration menu from the source tab I can choose multiple processes->workflows. However, doing so wil only allow me to pick system columns and not process related ones. Is there a way to surface process columns from across multiple workflows to build the report? Thanks.ac

Changing the comment format in Webcon 2022 (dbo.f_clear_description error)

0 4

Hi We recently changed the version of Webcon from 2020 to 2022 and I came across this problem. In the report we used a calculated column to show comments: (SELECT ISNULL (dbo.f_clear_description(wfelems.WFD_SIGNATURE), 'None')) However, from what I can see in database, the comment format has changed and now when using this function I get an error: "Invalid length parameter passed to the LEFT or SUBSTRING function." In the attachment, I marked in green old comments, and those starting w (...)

Issue with License Services

3

Any known issue regarding license services. because we are getting an error message in the portal saying "Failed to load license. Please check if the license server is running". From the application management tool the services is running successfully and when I try to refresh the licenses from the license manager tool I am getting an error message saying "Cannot connect license service. Please check if the license service is active". even after restarting webcon services the issue remains (...)

Copying the sum to an attribute after initializing the list item

0 2

How can I copy the sum of points to an attribute when the list item has been initialized and is no longer being edited? The sum is only copied when the position list is edited.

Initializing a list of items with attachments from the parent workflow

0 2

How can I initialize attachments on the item list in the subworkflow? The initializing query retrieves text fields, but does not retrieve attachments. I receive an error message: Validation Error, SubElems (ID: 9031) Attachment not found. SubElems (ID: 9031) Attachment not found.

How to edit comments?

0 1

Can a user edit comments? For example, for a simple error like a typo.

Cloning an app or workflow

0 7

I have created an app and a dictionary. Now for this app, i have to create same process, but with different set of users. What is the best way to do it? 1. Clone the workflow, set it a Custom Instance number and modify steps with the new group of users? 2. Clone the process? 3. Export that app as a template? But when i want to import it, i have to use that dictionary i have created. Thanks

Show in Report if Item has attachments

0 2

Hi. I want to show in a report in a column if an item has an attachment. Does anybody have an idea how to do that? Kind regards, Klaus

Download Excel file from external REST API

0 4

Hi all! We are using the action 'Invoke REST Web service' a lot, but there are some limitations I am struggling with. I want to download an Excel file using this action, using an external REST service. My first approach was to store the response body into a multi-line content field. I am also using a HTML field with a download button, to save this file from content field to disk. This method is working very good with plain/text. After saving file from Content field to disk, Excel (...)

VPN and webcon process

0 0

We have a server where there is an app installed and it is accesible only through VPN. If i have created an app in Webcon and i have to send data to that app invoking SOAP service action, will it work? Or how to configure?

Edit mode task

0 2

Hello, 1. When i click on task, it always bring me into edit mode, and if there is other person assigned to this task, it is saying there is other person editing. Is there a way to block this edit mode? I mean, when i click on a task, i want to have it in a VIEW mode and then click on that EDIT button if i want to edit. 2. For ItemList there are option to Export/Import to Excel. Is there a way for Export option to configure/rename the filename? It exports with that name of my ItemList's f (...)

ex.System.InvalidCastException

0 1

Hi, I have problem with moving workflow from one step to another step. I mean if i create a workflow with 3 basic steps (start, intermediate, end(positive)) on those steps i set up paths with task creation on business rule level and i set up myself (my account). When I try to open that application in portal then on first step everything is ok and i can sent task to second (intermediate) step. AND here is a problem when i try move task from that step or even when i try open task in Admin mod (...)

Extract substitution person

0 0

Hi, I wanted to create a rule to validate if the current user is the assigned person directly or the substitution person. I was able to get the assigned person directly from System fields, but I wasn't able to get the substitution person. How can I extract, without SQL, the substitution person? Thank you, Raluca

Run history

0 2

Hello, How can I see the run history of a workflow? How to check on which step it failed or if something run? For example, on a step i have a workflow to run a soap service... how to check response and how to get response and use that data to invoke another soap service action? Thanks

Item list in email

0 1

Hi, I have found this article. I don't understand where should i define an additional row... (text fig. 13) Or i get error "column DET_Att1 not found.." https://community.webcon.com/posts/post/confiugration-of-the-item-list-and-data-table-form-field-in-e-mail-templates/14 Can you help? Thank you.

ItemList Loop to attach in email

0 1

Hello, Is there a way to send an email with the values from an Item List. I have an app for products order. I have some Form fields: Project, Delivery date and Products (which is an Item list - with following columns: ProductName, Prince, Quantity) I want to send an email which has as Body the Item List's values which i have added. Is it possible? I have seen that i can Populate a word with Item list, but i am asking just for that email body text. Thank you.

[Solved] Issues with database connection "subsequently assumed a new security context"

0 2

Hi everyone, I was working on a process and out of the blue I receive the following errors: In BPS Portal / testing a data table: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction In the event viewer there's the following entry: The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated securi (...)

Distinct values

0 1

Hello, I am a webcon beginner. Can someone help me? I created a Dictionary with the following fields: Company and Project. Company A can have Project 1, and Company B can have Project 1 too. When i run a process: i have to select Company and Project. But when i select a project, in the company field i want to see only distinct values of companies from my Dictionary entries for that selected project only. I have tried with function DISTINCT, but it didnt work.. thanks!

Distinct values

0 0

Hello, I am a webcon beginner. Can someone help me? I created a Dictionary with the following fields: Company and Project. Company A can have Project 1, and Company B can have Project 1 too. When i run a process: i have to select Company and Project. But when i select a project, in the company field i want to see only distinct values of companies from my Dictionary entries for that selected project only. I have tried with function DISTINCT, but it didnt work.. thanks!

How to see all functions in Designer Studio

0 1

Hello, How can i see all Functions in Designer Studio? That's how it looks like for me: Thanks!