top rated

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

0 3

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!

Pending email notification

0 1

I've got strange behaviour of email notification. On path I create an action to send a custom email. For last couple of days all emails have status pending in Report module. 1. What might be the reason email are not reaching the recipient? 2. Is it possible to push pending emails? Mass notification emails are working correctly

Firing Workflow Instances from Excel File Update

0 1

Working on a project whereby there is a process to track delinquent loans and create collection activities based on ageing. We receive loan data as a daily dump in excel and new or modified rows should either fire new instances of our workflows or trigger certain paths in existing workflows.Unsure of how to go about this

Holiday request

0 1

Hello, in the "Absences" application I have two processes: Employee file, Holiday request. I wanted to ask you, how do you organize data sources for such a process? 1. Should the source of data be an employee's file with a list of items that reflects holiday leave limits? In this case, each submitted application should update the parent workflow (Employee file), but I am afraid that over time the file will have too many versions. On the other hand, I have change history and actual data. (...)

Hide form fields on load

0 4

Hey there. What's your preferred way of hiding form fields on page load? In my scenario form fields should remain hidden, unless a form field rule from another field was triggered on value change that 'unhides' the target form field. I've been doing it the following way: 1. Make the field that should not be shown upon form load visible in the Field Matrix 2. Insert the 'Hide' JavaScript function into the main form behavior of the step 2. Create a form rule which shows/hides based on (...)

Q: How to create a Add2Attachment-Button via HTML-field (JavaScript)?

0 1

Good morning, we have a special situation, where we need an configured JavaScript(?)-Button which works like an "Add Attachment"-function INCLUDING predefined group. We would have defined the Attachment-Section with following groups: General, F1, F2, F3, F4, F5, F6. Our users should load pictures to the attachment (1x for F1-F6). These would be copied to one of six picture fields (F = German for Foto / Photo).The reason is that we need the filename for each picture, which, as far as i (...)

No associated application to edit the file

0 0

Hi there Does anyone know the reason for why when i try to edit a word attachment from the form i get a message "No associated application to edit the file" but Word is opening just fine? Version 2022.1.4.61 Any input would be much appreciated. Cheers Pasquale

-

0 1

-

Duplicating production setup 1:1 to a new dev server

0 1

In our attempt to move to the cloud I need to update our webcon database to the latest version that supports GCC. I do not want to install this on prod and we don't have a proper dev env setup for this (Yet). To get the db upgraded, I am trying to migrate our existing prod WebCon instance, data and all to a new dev host (basically making a 1:1 prod:dev environment). Is there a "supported" method for doing this? I've tried a clean install, restoring the config and content databases and (...)

Editing attachments - errors after trying to edit

0 0

Hi Guys, I wanted to use the edit attachment function. Unfortunately, after invoking edit, I get attached messages. How to fix this problem? Best regards, Patryk

Error "Incorrect sequence of form fields"

0 4

Hi all, does anyone know why this error is showing or how to fix it? It appears when I try to change the position of the fields in the form.

Don't understand Foreach / For aach Action

0 10

Hi there. Trying to familiarize myself with the for each action. I have an item list an I want a business rule to evaluate the value for each row of a certain column (choice field) an execute an action for it. Unfortunately, as soon as I have more than one row in the item list, the BR evaluation will fail as it attempts to test against all the row values for the specified column. My BR uses: IF[GET IDs[SELECT VALUES[Item list | Column]]] = [Choice field id] I guess there must be (...)

Word Add-In & Barcode images in table

0 2

Hi community! I am struggling with Word Add-In and data tables. The requirement is to show a table of order positions, each position contains an image field with a barcode (which should be shown in table) and some other fields. Is that even possible and if so how? Thanks a lot in advance & best regards, Nik

Content as BASE64

0 4

Hi, I'm having trouble converting the contents of an attachment to BASE64. On the system step I have a TimeOut that calls the transition path after a minute. In the traversal path, I have an action that calls a web service. The frame uses a business rule to convert the content of the attachment to Base64 (the business rule returns the text value of the last attachment). When the whole thing is handled by TimeOut, I get the error: Message=Error executing SQL rule Create Attachment Base64 (I (...)

Q: Anyone already worked with "Remove personal data" ?

0 1

Hello everyone, for a new idea i have in mind, it would be great, if there would be an easy build-in way to anonymize all form fields of an instance, which are marked as "Data Type - Personal data" in the Personal data storage (Style and behavior TAB). As far as i tested, there is always the need for a "Personal Data Dictonary", when using the action "REMOVE PERSONAL DATA". QUESTION 1: Is there any other way? QUESTION 2: Is there any build-in option to anonymize the AUTHOR too? Th (...)

Coloring even rows (plus edges)

0 2

Hello, is it possible to color every other (even) row in the reports so that the rows are more visible. In addition, is it possible to add edges in the rows to make the reports more readable. Example attached.

Define Default Report View

0 5

Hello, my dashboard includes a three column design with one report in each of the columns. The problem i'm facing now is that because the columns are too narrow, the reports get displayed as tiles rather than a compact table row list. I can change the view mode when viewing the dashboard in the browser (see image), but I would like to define it as the default view. Is there any way to change this behavior and define a default view of narrow reports? Thanks, Philipp