search results

Hi there, Is it possible to use one datatable to show different tables from a sql server? Right its possible to filter the sql results based on a value in a certain column. I also want to make it possible to show the content of a different table, however account to the infobox to the right side of the textbox where i write the sql statment, its not possible. So i was wondering if there is an alte

Hi all, first of all: this is not supposed to be a moaning complaint, just a heads up so other people dont fall for the issue that hit us today. I wanted to share some info regarding the update from 2022 to 2023, as we ran into some very unsatisfying issues with SQL COMMAND business rules that are querying field IDs. It hit us on some neuralgic spots in our main workflow, causing quite some

Hi, I don't know if this is possible in the BPS 2025 version, but for earlier versions I miss the ability to center the text (and make it bold) on request for each column of the item list or SQL GRID data table. I don't think it's possible to set the background color for the column label. Regards, D.

Hi, I'd like to build SQL query that uses 'current BPS database' and at the same time uses linked server that exists on that server. So I want to do sth like that: Select * from BPS_Content.dbo.WFElements t1 left join [my_linked_server].[database].[schema].[my_table] t2 on t1.id = t2.id Unfortunately it doesnt work. I got an error in Webcon Studio "Access to the remote server is denied b

(...) Hi, I need to build a process that will work as a service, check a mssql table , and start the process if new rows are added to the table. Single process based on a single row in sql table . Maybe someone has built a similar functionality? Best regards.

Hi Guys, Is there any way to configure paging for the item list? Got one with > 280 rows, initiated from the SQL query. I cannot use data table to display the data only, as users need to add comment for each row in one of the columns.

Hi, it would be great, if the 'Search panel' configuration would allow the positioning of the 'Search everywhere' field. Currently this is always displayed at the top which makes it really tempting to use it for searching, even if there's a dedicated field has been added. While this is not necessarily an issue, it may become one depending on the search phrase. In our case it takes almost

Introduction of SQL query based reporting model to reports with the capability of current table reports functions

Hi, while we can create business rules which act similar to table valued / scalar functions, we can't pass the columns/data to them. The inner business rules are executed before the outer SQL command is executed. This comes in really handy in a lot of cases but also has it's limitation and will require creating repetitive code. I would suggest the following: Create a new "type" "SQL func

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

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 user

Hi everyone, I’ve recently encountered the following problem: I have a form with a picker field where I select a customer. After choosing a value, several data rows display information related to this customer. Some of them use SQL queries, while two use REST Web Service data sources. The data rows that fetch data using SQL reload correctly whenever the “client” attribute value changes. H

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

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, I'm currently trying to figure out a way to filter a Custom data source with an "dynamic" filter. Here's a rough overview: #Custom data source I've created an SDK of type data source which prepares the data #Filter I have a filter value which is dynamic for a given workflow instance. Here are two examples: {COLUMN:ID#ID} in ('KHL_030','KHL_020') {COLUMN:ID#ID} in ('KHL_001','KH