WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for SQL table

Hi! I have a process which generates subprocess (list is from sql query). The subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors o

Hi Stanisław, there's already a setting for this in the advanced tab of the "Start a subworkflow (SQL)" action. :) Off topic: I would advise against modifying data via SQL commands inside any BPS database. I'm not sure, but I can imagine that you would loose any support if you do so. Best regards, Daniel

There is no need to write an sql statement. Simply check "Overwrite instance author" and set the value from the form field and workflows are started with this users as author :)

Thank you for your answers! I have another question.. I have an dictionary in which I defined a list of users for whom I want to start each subprocess and for each subprocess author should be a login (field from dictionary). I tried to present it on my main process (as item list) but I don't know how to set it with that field which you proposed (overwrite instance author). Or maybe shoul

At the moment i can't see the purpose/benefits of your approach for having different authors for each subworkflow. Assigning the first step to different users for e.g. is easier to achieve by setting a people field on workflow start and use the dynamic task assignment. Maybe you better explain what you would like to achieve.

Hi, depending on the number of times you are creating these workflows it could be an option to trigger a path transition of the dictionary workflows which in turn would start a single workflow using the non all action. Then you would be able to set the author. Am alternative could be to user the REST API. You could create an App which is allowed to impersonate users. Then you could call thi

Each month I will run subworkflow for each employee which is in my dictonary. In report for employee I need to present only processes which is connected with that user. Thats why I'm trying to change the author of each subworkflow to the employees from my dictionary list. Or maybe you know some trick how could I solve it with 'person or group' field and the dynamic value sentance that I need to

Hi, In reports, you can use ##currentloginname## if I'm not mistaken, to get the current user login. It works for sure in SQL filter, and it should in standard filters too, but I cannot verify that right now

Last year the "Me"-filter for person/group fields have been introduced on reports. I would suggest, that you use a person/group field and start the workflows by setting this field with the user in your dictionary rather than trying to change the author. As long as there are no global read permissions defined on either process or workflow level, the users would not have access to the created

Hello, Thanks Sebastian for your idea - that help me to solve my problem and works perfect at report! I have some troubles with configuration of that SQL filter that you recomend me but that thread https://community.webcon.com/forum/thread/459?messageid=459 helped me a lot. I want to thanks all of you guys - of course you have totaly right that changing anything directly in database is not a

Applies to version: 2020.3.x and above; author: Józef Cyran   Introduction The item list is frequently used to store any number of data rows as opposed to other form fields. This functionality makes the actions executed on the item list differ from the standard form field configuration.   Business case: Personnel planning for a project This article describes the

Applies to version: 2020.3.x and above; author: Agnieszka Burda   Introduction The following article is an extension of the Lunchtime article – see Lunchtime application The “Lunchtime” application has been enhanced with dictionary processes that allow you to pay for meals with money previously paid into your personal account. [LT Account] – a d

Applies to version: 2020.3.x and above; author: Franciszek Sakławski   Introduction When creating the configurable e-mail templates there is the option to add fields from the form. This article describes how to add an item list and SQL data table fields.   Fig. 1. A list of fields available in the system   To enter these types of fields in the template is n

Applies to version: 2020.3.x and above; author: Józef Cyran   The idea of the application For this article we will implement a simple system for dividing up tasks between a group of users, based on the following principles: The task will go to the user with the least amount of tasks If multiple users are tied for the fewest number of tasks, one of them is randomly a

Applies to version: 2020.3.x and above; author: Konrad Wojtycza   Introduction Nesting business rules in the form rules allow you to refer to data contained in Active Directory or external data sources. This extends the functionality of form rules and allows you to use data outside the form when defining the process logic.   Execution of a form rule for a specific group

Applies to version: 2020.1.x and above; author: Dawid Golonka   Introduction Some processes in WEBCON BPS require data from some other source to operate correctly. This data can be provided from external data sources such as SQL databases or SharePoint lists. Internal sources can also be created in the system such as Fixed value lists or references to data contained in WEBCON BPS

Applies to version: 2020.1.x and above; author: Franciszek Sakławski   Introduction In WEBCON BPS version 2020, the support for digital signatures has been enhanced by preparing plugins (SDK – Software development kit) that enable digital signing of documents. Four plugins have been prepared that allow for integration with external digital signature providers: Adobe

Applies to version 2020.1.x, author: Dawid Golonka   Introduction When creating support for business processes in WEBCON BPS, it is important to remember that even the simplest workflow with a minimum number of steps and form fields will be reflected in the database – all of its instances and settings are represented in the content database – which is the main place

Applies to version: 2020.1.x and above; author: Franciszek Sakławski   Introduction You can automate your existing company's processes using workflow class systems. WEBCON BPS Portal gives you many tools for handling digital process automation. One of them is generating certificates for employees who successfully ended a given training course. This art

Applies to version: 2020.1.x and above; author: Franciszek Sakławski   Introduction When designing processes and individual workflows in WEBCON BPS is it good to know how data is stored in the table, what relationships are and how particular information is displayed on the form. The following article describes the WFHistoryElements and WFHistoryElementDetails tables. Table