search results

(...) g a BPS data source > Filtering section [The bug] In a data source filter, when using the ALL_TRUE operator, the WHERE condition in a generated query is prematurely simplified, what results in an sql error. [Workaround] Chain AND operators. [Fix] Please fix the sql translation of the ALL_TRUE operator :)

(...) ed. While this is not necessarily an issue, it may become one depending on the search phrase. In our case it takes almost one minute until the search is executed. This is due to the fact, that the sql server breaks the search phrase into a a lot of parts which has a dramatic effect on the the query. A little background, the search result returned 4 rows and we have only 10795 workflow instances (...)

(...) Hi, I'm having a dilemma about comparing two date objects. My thinking is when I do sql queries to retrieve data from objects it will give you already stored db results, but with webcon functions you actually get value before it is actually stored. It does not work this way, so i'm looking for a way to do it. In conclusion, it should compare date before change and after change (this is triggered on m (...)

(...) will save the instance changes. add extra field in the item list with boolean that will examine is something changed or not. - parsing current values with js and creating json which can be read via sql , this could potentially be more complex

(...) Is it possible to insert into wanted dictionary related item via sql query or else ?

(...) n any ports other than HTTPS/HTTP (443/80) on the application server to run the Designer Studio on a remote machine (not on the application server)? - or open traffic from that remote machine to the sql server

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

(...) e not archived, everything is just fine, but when you archive any of these elements, datatable/row gets empty and datatable shows that "No data preview ... archived ...". Data sources are custom T-sql , but I suppose that's not the problem. I need to show the data within datatable / datarow no matter the element status. Thank you, Mihail

(...) Currently, such data sources do not return the system company information, which limits their usability. The lack of this functionality forces users to manually retrieve data using sql queries, which contradicts the Low-Code platform's principles.

(...) ror message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. Callstack: Microsoft.Data.sql Client.sql Exception (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Anyone got an idea what could be causi (...)

(...) ften happens that there are timeouts on a form that should be executed, but, for example, someone entered the form editing mode and the timeout could not be executed. Adding a feature similar to the sql move action for timeouts - finish tasks in admin mode - force undoing user checkout

(...) 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: "The SELECT permission was denied on the object 'WFAttac (...)

(...) a workflow -> Main form -> Attachments section there is an option called 'Related attachments'. This is really useful since it allows displaying attachments from sub-workflows/parent workflows or via sql and it can save a lot of disk space. The issue is that the related attachments don't appear in the same tab as standard attachments. Users, unless they are aware of the second tab, usually don't eve (...)

(...) tried to do GET via API I got empty response. GET: {{env}}/api/udef/db/1/MTBVENDOR?ComCode=PL12&InvoiceNum=ASDF&InvoiceDate=2025-08-25 RESPONSE: STATUS 200: { "Data": [] } when i check sql query for data source is like this: (([InvoiceNum] = N'ASDF') AND ((CAST([InvoiceDate] AS DATETIME) = '2025-08-25T00:00:00') AND ([ComCode] = N'PL12'))) and i works. Do you have idea what can (...)

(...) rt Synchronization failed. Mode: Incremental Debug: No Duration: 93s Status: Exception Reason: Started automatically according to global schedule configuration. Exception: - Microsoft.Data.sql Client.sql Exception (0x80131904): Violation of UNIQUE KEY constraint 'UQ_CacheOrganizationStructureSubordinates_COSSUB_COSID_COSSUB_WFDSID'. Cannot insert duplicate key in object 'dbo.CacheOrganizatio (...)

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

(...) New assignment filter: All active where I am delegated/substitute Currently, such a report is created in the sql filter if you do not want to show the user's active tasks.