search results

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

(...) uicker 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 could be defined on report parameters or available to switch by the user.

(...) ents to save time, but they can only do this for documents they are the author of. Is there any reasonable workaround to let users without edit rights use such an action? P.S. I have to use the SQL option because of position lists in the instance.

(...) untered 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. However, the ones that use REST do not (...)

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

(...) Hi, I'm going through data migration process via sharepoint lists and the protocol that I want to achieve it with is by using cyclical actions. I've created an automation that is runing subworkflow(SQL ) and there is a problem with mapping. Data source has exact values that I need, and I'm using them as intended but the problem is I'm getting data rows I don't want and even then those queried fields a (...)

(...) owing value assignment -- No value, didn't change the description -- Empty, didn't change the description -- ' ' set the description to a space character -- '' , didn't change the description -- SQL command returning null, didn't change the description -- NULL as a string, obviously set the description to NULL as a string - Assign an empty constant to the field, didn't change the description (...)