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 (...)
Hi, Is it possible to Use a http request to pull data from an API and map those retrieved data to populate a Word Document Template.docx? For context the retrieved data is in table format. I would appreciate it if the steps on how to do this is provided. Thanks and Regards,
ORIGINAL SUBJECT WAS: Assistance Needed – Retrieve "Content as Base64" for All PDF-Attachments of an Instance Dear All, I am currently looking for a way to extract the "Content as Base64" for all attachments associated with a specific instance. My goal is to obtain a single text line in the following format: 'Base64 PDF 1', 'Base64 PDF 2', 'Base64 PDF 3'. -> The easiest way would be to us
We are currently in the process of upgrading from the 2023 to 2025. Unfortunately, we were hit with some very bad news—starting from the 2024 version, the ability to define private views for reports configured on the dashboard has been removed. This is a significant issue for us, as users rely heavily on this functionality. Once the upgrade is deployed to the production server, it is likely to
(...) Hi, why is there a difference in how multiple lines of text with append mode enabled are displayed in report vs in the data table attribute? In the report, each entry is shown one below the other, but in the data table attribute, they appear side by side, which looks bad on the form. Is there any way to change that?
Hi, we have several use cases (eg recurring drivers licence validity checks) with the need to force an image upload with a photo just shot through the camera. An upload from the photo gallery shall not be allowed because the photo must be recent and EXIF data could be manipulated easily in the photos option. The image form field would need an option to force camera usage when a user uploads
I would like to suggest an enhancement to the user interface of Item List (tabular) form fields within the WEBCON BPS platform. [Current Limitation] At the moment, users are unable to freeze specific columns in Item Lists when scrolling horizontally. This often leads to usability issues, especially in wide tables, where the first few columns (e.g., item name or ID) get lost from view. [
(...) e to select *, dbo.GetTextPartEN(Description) as DescriptionEN,dbo.GetTextPartEN(Remark) as RemarkEN This came only to my mind now, because I'm creating a lot of "repetitive statements" in a few data table s, but when I think back, it would have helped me in a lot of other cases two. Best regards, Daniel
(...) Hi, I'm writing this post to verify, that I didn't overlooked an option. Situation: I have a data table to get the data of subworkflows and the base 64 encoded values of their attached images. This data table is used to create a word document. The standard SQL connection uses the bps_user which neither can read data from a separate database nor is the user allowed to read the attachment file table: (...)
(...) Hi, data table /rows display the values as they are returned from the data source. In case of the MSSQL data source this is fine for text fields and for choose fields, integers/decimals we can work around it. Either by using the available functions or using format functions and the current user language. In case of date time there's no work around. The issue is especially visible when users are loc (...)
(...) nly mode. Right now Export to Excel feature hides when I check the item list to readonly mode. Is it a feature / bug? Is it planned to be changed? Does any workaround exist, except the showing data table with the same result (and e.g. my query returns over 1k rows which is data table limit). I am aware that the form slow downs but is not crucial in that case :) Best Regards, Dominik
(...) data sources. The data rows that fetch data using SQL reload correctly whenever the “client” attribute value changes. However, the ones that use REST do not refresh. I had a similar issue with data table s in the past and solved it by using JavaScript to simulate clicking the reload button each time a dependent attribute value changed. Unfortunately, the Data Row control doesn’t have a reload button. (...)
Hi to all. As a consultant who needs to dive regularly into the database using SQL I'm surprised that there is no physical data model diagram in the documentation. A visual representation of tables and their dependancies provides a very useful overview about how data is structured, maintained and related. In SQL server there is a option to add a new database diagram and thus my question: could Web
Can I query SQL (WFDElements) to get a value for calculated column in the report from another workflow? Alternatively is there any way to present an SQL query as a report? Or on dashboard? I have a few cases where I need to pivot certain information. The only way until now that I found is to create a data source and a technical workflow that will load it into a table but it's far from perfect