search results

Hi, it is posible to export data from item list to Excel in action but only id from column value? Only way i found is map item list to excel table (Sheet1!Table1). In this way the whole (id and name) of column is exported. But I want only id or name.

Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission

Is it possible to create at the finish stage word file using data from WFHistoryElements table? Where should I store data regarding stages, time of the stages and person details assign to this stage to be able to used them in document template?

(...) Hi, I have an item list with a "date" column. I figured out that filtering (or even showing it in a customized date format in a data table ) is tricky as the daty type of the column is actually nvarchar(1000). What I want to reach is to filter the data table based on a "date picker" field, but I don't manage to. Kind regards, Klaus

(...) Hi community! I am struggling with Word Add-In and data table s. 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

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

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