Daniel Krüger (Cosmo Consult)

Hi, the underlying reason was that the SQL statement compared the id of a picker field against an instance id. So far so usual. Somehow the customer was able to save a value in the field which did not contain the the id. This caused the problems. No, the field did not allow to save values w

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

Hi Andree here's an example to filter a data source. I don't know whether your company is a business entity or a normal field. In your case you would have a field or a business entity in which you selected the Company. In the project field, you can use the value to filter the available ones.

Hi Andree, the view depends on the "location" from which you opened the Expression Editor. Not all functions would work in all areas, so those which won't work are hidden. Based on the displayed functions it looks like you are in picker/data source and have the option to filter the data. If

Hi, if there are not to many rows in the Excel file I would do the following in a "Processing" workflow. Since I'm not sure how many workflows would be created/updated I would do this in batches Step 1: Import the rows two an item list Paths "imported", verifies whether there is already a

I'm quite sure there are at least two related posts. One from Encorsa and from me. The one from Encorsa was also about doing this automatically via / api. I would like to have this option yesterday when I published a application to 7 environments. :) My addition would be: - to define a confi

Hi Flo, I should have added a screenshot in the first post. :) The screenshot shows the Behavior "Form rule to be executed on page load". Multiply form rules are executed depending on the current step. The used form rules always checks the condition (field value) and either hides or shows t

Hi Dariusz, we used also an Employee file. There was an "holiday leave limit" item list but consist of the column Year, Days from previous year, Days current year, Extra Days This was updated only when something happend to the limits or when the next year item list row was created. Of course

Hi Björn, I was actually able to do this. The following works in 2022.1.4.155. It could be that the ids/classes of the elements are different in your version. $(".fileinput-button")[0].children[0].click(); setTimeout(() => { let select = $(".addWithCategoryDropDown")[0] // https:

Hi Flo, I'm using a similar approach. 1. Using the form field matrix to define which fields should be visible in general. 2. Create a form rule. 3. Use this from rule in the "on value change" 4. Add this "Main form" Behavior" tab and add "if (step =1) then ExecuteFormRule". I don't like

Hi Bo, these are the chapters of our documentation to restore a production database as a formal test environment. I have to ask permission to provide any more information as I have done this during my "working time", whatever the actual term is for this time, when I'm doing something for which I

Hi Flo, in this case I would do the following: 1. Create local parameters for mobile and info AD property in the automation, this can only be done inside the for each. 2. Clear the values of both parameters 3. Add the if condition as you described and set the appropriate value. Execute th

Hi Marcin, it's for sure a bug, or a "glitch" which may happen but it's fairly unlikely to reproduce it and therefore to fix it. At least I didn't encounter it only once. Or better, a colleague reported it to me and I "fixed" it. Since I wasn't able to reproduce it I didn't report it. Be

Hi Marcin. I think I had a similar error message and I had to manually modify the data in the database. The order of the form fields in the placeholders ist stored in the table WFStepFormFields. In my case two fields shared the same value for FLD_Order. I changed the value and for "safety" mea

Hi Flo, maybe I'm missing something obvious to understand your issue, because I really can't wrap my head around what you want to do or why there should be an issue. Of course I don't have your actual workflow but even with the simple mail example I don't see any problem. I've created a simple

Hi Flo, maybe these information will help you: The numbers refer to the number in the screenshot In the for each action you can select different types, in my case the item list is unfortunately called "Item list" (1). In the for each action you have access to the columns/fields of in each ac

Hi Flo, do you want to use the for each row function in a form rule or the for each operator in an automation: The later one is documented here: https://community.webcon.com/posts/post/for-each-operator/319/3 If it's in the form rule you can use the get row value function. Select values w

A complete check would be when the chosen signature would check against the signature definition as well as against the existing instances. In case a signature was changed over time. Of course this would only work for „static“ signatures which don’t rely on business rules /field values.

Hi Björn, in this case I would create an "intermediate" workflow, which has a "start as Subworkflow action" there you can overwrite the Author with the system account. I once had to implement an "innovations/ideas" application where all ideas should be public but the author should not be visib

Hi MIchal, there are also the Admin* logs like AdminWFEventLogs https://community.webcon.com/posts/post/the-adminwfeventlogs-table/137 Unfortunately I can't remember which information are stored where and whether they are stored in CONFIG or CONTENT database. You could also take a look at