search results

(...) 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 (...)

Use case: We are using an offer process/workflow, where we fill in the costs in a table - e.g. columns "descripition, quantity, price per unit, total price." In case the offer is accepted and we'll need a change request of the costs we need a two separate process steps. The first step will start the change request, opening two additional columns in the table - "quantity for change request, tota

Hello, I have a short question. I want to generate an Excel file with my data from the BPS datasource. I created an Excel template with a worksheet(test) and a table(myTable) and a action create excel. I write the assignment like this: test!myTable and my data to the right cell. But I always get an error. (Invalid cell name) If I just want one data set and just write the cell names for e

Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards

Hello, I' m new in webcon and i try to fix issue connected with attachments. I don't know much about attachments database but as i saw there are two places where i can find data : [BPS_Content].dbo.WFDataAttachmets and [BPS_Content_Att].dbo.WFAttachmentFiles When im trying to add attachment like always going step by step in my workflow everything is ok - attachment is being added in bot

(...) uld like to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data/v52.0/analytics/reportTypes/Opportunity But when I use the field as a data table in order to check the information, the list comes empty. Anyone tried this? Do you know how to bring reports instead of using SQOL queries? Thank you!

(...) Hi, how to set a filter in the data source for a data table so that search-filtering by date works. The usual filtering according to the scheme does not work: 1. "some date (iso or browser settings)" = "field in the data table with a date" (like attachment) 2. "some date (iso or browser settings)" like "field in the data table with a date"

(...) used the Aspose library which supports a template syntax. This allows to write code inside the word document to generate more sophisticated documents. Examples: - Instead of rendering item list/ data table s as tables in word we could generate "chapters" - Chapters could contain other chapters - Displaying multi line fields with rich text - Displaying pictures from attachments inside the document (...)

(...) ould like that the system would allow choosing various options and populating the item list with the information. I know I can accomplish this with a choice field and then showing the details on a data table view. Thanks

(...) Hi all, Is there any way to export data from Webcon to Excel WITHOUT column headings? Can't see such an option neither in export from data table attribute nor from the report. Can this be done in any way?

Hello Community, I've got a problem. I've got two workflows, a parent and one subworkflow. I'm trying to transfer data from the parent workflow (single line of text attributes - 'email' and 'phone') to a table in the subworkflow with the item list update action. The table has columns ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an SQL query t

(...) ello, I have a process (start - finish) that creates an instance and remains in the "Finish" state. Here, I have the following form fields: "Quantity TOTAL" (Floating-point number) and "Quantity" (data table ). In that data table , I have other instances from a different process, and in one column (Quantity Requested), I calculate the sum. How could I save that sum in Quantity TOTAL and have it consist (...)

(...) ind out more information about the cause using an error ID? Where can I enter the ID in the Designer Studio to get to the form field that is causing the error? I tried to adapt a data source to a "data table " form field because not all existing values ​​were displayed. Now I always get the error "Failed with an unknown exception Error ID: 6f351188-04d9-4049-bd2b-d3da66c64976" Unfortunately the error co (...)

(...) e have a field type Integer you can set its appearance like a) 123456,00 or b) 123 456,00 or c) 123,456.00 I'm wondering if we can change, by any chance, the way an INT looks like inside a data table field as well. Because at the moment, into the data table is looking like d) 123.456,00 .. and I don't have the option to choose this format for other fields as well. Thank you!

(...) Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In the where clause, I refer to the value of another ‘Criterion’ field on the form. The data table should display the data depending on the selected criterion. Unfortunately as I change the criterion, the table sometimes fails to refresh and displays the data for the previous criterion. How do I solve (...)

Hello! In the form, I have a list of items X that is sorted by column A in descending order by default. How can I set up an action to generate data into a .docx file or specify an attribute for the list of items in the .docx file so that the exported table with the list of items X is sorted by column A in ascending order? The descending sort by column A is because the data is being added to

Hi, Is there a simple way to get which environment runs a process? The data should be one of the 3 possibilities: DEV, TEST, or PROD. There are many places in Webcon settings where environment is set as "Auto", but I found no variable giving the actual name of the environment. I know there's a table and inside is a row which offers this, but I thought there might be an environment variable

Currently, if a company has several content databases, for example 5, and users need to be synchronized across each database, the data is stored in 5 tables * 5 databases, resulting in the same data being present in 25 tables. CacheOrganizationStructure CacheOrganizationStructureExtendedTokens CacheOrganizationStructureGroupRelations CacheOrganizationStructurePictures CacheOrganizationStruc