WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for data base

Hello, I'm trying to import user data from the import WF (1) into the employee WF (2) and route based on whether the user has an Active Directory account. Depending on whether the user has an Active Directory user or not, the user should either be sent to the blue path or to the purple path in WF (2). The issue is that the business rule in the 'Start a Sub Workflow (SQL)' actions, which chec

Hello, I am trying to update some form fields and columns in an item list after some actions. On my path i have configured a FOR EACH on my item list which is creating/composing JSON payload for my REST. (rows) However, I am encountering an InternalServerError (500) when attempting to save this data using REST service on path for my current instance. PATCH: api/data/v5.0/db/#{DBID}#/element

I have a process that creates 10 reports each month. After creating the initial reports, I would like to clone them automatically at the end of the month, only changing the reporting month. The user (author) updates the data and submits it for verification. I proposed the following procedure: 1. I created a BPS source that lists all 10 reports from the last month. 2. The BPS data source has c

(...) they are using application) and in case of next usage of application personal information could be filled out automatically based on what they filled out first time. Some data we don't have in our data base s so we can't just connect it to our data base . Kind regards, Jan

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

hi, I would like to create a calculated column for a report with a list of items. This column, using SQL, should fetch data from another process. I want to map it based on the DET_Att23 ID for each row of the report:: select sum(DE.DET_Value2 - isnull(DE.DET_Value17, 0)) as nn from WFELEMENTS join WFELEMENTDETAILS DE on WFD_ID = DE.DET_WFDID where WFD_DTYPEID = '212' and DE.DET_WFCONID

Hi, I have a process that use API to send data to another system. I have a patch in WebCon to check status, based on the feedback, process moves to the next step or waits another hour on the timer. I want to change this. I found this option in WebCon API: Path that will be used by element PATH /api/data/v6.0/db/{dbId}/elements/{id} But my second system don't have a PATH method. Do yo

Hi. we've implemented some global form rules e.g. a developer on screen mode that displays meta data of fields (instead of turning on dev tools) - a knowledge base article will follow later. Small work in progress preview teaser in the attached screenshot. ;) Right now it is necessary to add this global form rule to all main form behavior sections manually to get this loaded. It would be

Hi, it would be great if an option is added to exclude processes from the analytics overview. I tried to "remove" those by entering a date far in the future for this flag: Limit the scope of analytics data – parameter is used to limit the scope of processed data available in the Analytics reports. If this option is activated, all measures of analytical reports will not be calculated for workf

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 fi

WEBCON works on ver. 2024.1.1.130. We have a few dashboards with created data sources for reports. After data sources, we created reports but using this data sources, not creating new one in Designer studio or in Portal. Now, users gave us information about lack of access to one of the reports which uses data source. Inside configuration of dashboard we have option to change priviliges but if

[Benefits and business justification] - In many business processes, items are archived after a certain period to reduce the load on the production database. - However, access to historical data is often essential – e.g., in the context of audits, analysis, reporting, or trend comparisons. - Granting appropriate permissions enables precise management of archive access, aligned with real busin

Hi, Is there a chance to add alternative way of filtering data on reports based on text fields rather than filtering specific values? It's quicker for user to enter directly search phrase rather than choosing from list, even filtered values (sometimes user have to check multiple options that meet search phrase). Additionally it skips one sql query used for generating list of values in filter. It

Quite often we have the use case, that we need to provide a personalized dataset. With SQL data sources we do have the possibility to use calculated fields with a subquery. Which could end up with performance issues when using large datasets. As an example this calculated column returns 1 if the first letter of the COS_ExtensionAttribute05 field in the COS table matches the value of the dataset.

Hi, Current Situation: Data Sources are typically static and context-independent. Each Data Source is bound to a fixed query or API call, with no native mechanism to pass parameters dynamically. As a result, any variation in use (such as retrieving different columns, filtering by different criteria, or adapting to different workflow contexts) requires creating multiple Data Sources or embeddin

Hi everyone, I would like to suggest an improvement to the standard archiving mechanism in WEBCON BPS. Currently, the standard archiving functionality works well in two important areas: - links to archived elements remain the same as before archiving, - archived elements are moved to a separate archive database, which helps reduce the amount of data processed in the main database and impro