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
Hi, I am currently working on some tool management workflow in WEBCON and I have a problem. I have an items list with REST API as data source where user can pick and book tools for some time period. Time period property is not included in REST API so I'm using form fields for booking dates. Then I need to filter the items list using tools from REST API and dates from WEBCON database to exclude una
Hi, I have configured an On start (cyclical) action that is basically starting at 12:00AM and stops at 6:00AM, and is doing so every 2 minutes. What it does is to create an instance for the same process (parent process - where is also the global action configured). Parent process is running a loop on a data source that contains 10 entries and starts 10 other instances on a second process (chil
(...) threshold for contributing would not be as high as it is for a Knowledge Base article, which usually requires a certain level of detail. Simple contributions like 'Displaying a Google Maps link in a data table ', 'Coloring a data table entry from the previous day excluding weekends', 'Displaying graphics in a report', or 'Limiting the maximum number of text lines in a multiline text field using RegEx' would (...)
(...) Hi everyone, I've noticed a strange rendering / displaying of data table s. I attached a screenshot: 1) This is how the data table looks like if I refresh the browser 2) The mouse overs work fine 3) "Dragging" the data table "displays" the table correctly. 3) can also be achieved when the data table is in a tab and you switch tabs. The data table is displayed correctly when getting back. We hav (...)
(...) I try to find option to trigger refresh button in "data table " . OK I can click arrow .. but I would like to refresh to have no data ... So I have form rule when some field value is changed (deleted) then is clearing fields but not reloading whole form ... so because data is not saved or the full form is not reloaded ... the data table stays with "old data" - i can click refresh and then will be empt (...)