search results

(...) Hello community, I need to start a workflow instance for each email address in a text, where the addresses are separated by semicolons. My plan was to initialize the Item List using an SQL query , and then to start a subworkflow (SQL) instance for each row (email). Since our WEBCON environment doesn't support STRING_SPLIT, I fabricated a custom SQL query to split the long string into individual rows (...)

(...) m the current element could be set as the main visible tab. Maybe this option already exists and I haven't found it yet - if so, please let me know. Additional idea - currently, when using SQL query for related attachments, we are limited to 3 groups of attachments. It would be much more flexible if SQL could return a column like GroupName, allowing attachments to be grouped dynamically without (...)

(...) ed 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 be a (...)

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

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

(...) Hi. Since we switched from V2021 to V2025 I noticed that it seems to be no longer possible to use the content of a form field (unsaved data) in a SQL query (see pic). It just delivers "empty". Is there a workaround? I frequently used the data of form fields to control actions and so on. This is a major degradation ! Kind regards Klaus

(...) Hi everybody. I'm trying to implement a calculated column into a report. This is the query : ( SELECT dbo.ClearWFElemAdv(DET_Att3) FROM WFElementDetails WHERE DET_WFCONID = 9579 AND DET_WFDID = WFD_ID AND dbo.ClearWFElemID(DET_Att1) = 1 ) This column is empty. If I put in a value for WFD_ID, e.g. 52750 the column is filled with the correct Value (for item 52750). What am I doing wron (...)

(...) hecking WFD_AttText1 for 'XYZ' and WFD_AttText2 for 'ABC' at the same time in one request? I tried with several separators and concatenations without success, also wasn't able to use the "filters" query option. Anyone able to offer guidance on the matter? Cheers, Tobi

(...) e the action 'mergeattachment' not only for attachments in ONE form but also in DIFFERENT forms? If not, is it possible via sql? In the attached picture there is a screenshot of the following sql-query of the webcon-database: select ATF_WFDID, ATF_OrginalName, ATF_OrginalValueHash from dbo.WFAttachmentFiles where ATF_WFDID > 9620 how can I export the word-docs as real word-docs to the files (...)

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

(...) w a “message on execution success”, but there is no equivalent “message on execution error” that can display dynamic content. As a result, I can only show something generic like “Error during REST query ”, but not the actual validation error returned by the API. In theory, I could check the REST response for every possible error condition and throw a matching static error message – but this does n (...)

(...) Hi all, I have a question regarding the WFElements table and using Item list as a data source. I have an Item list that displays customers using a SELECT query from WFElements. I can see the Add button on the Item list and I can add rows on the UI. My question is: Is it actually possible to add new customers using the Item list and then persist them to WFElements (or another table) so that t (...)

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

(...) Hi, we are using version 2025.2.1.179. For a demonstration of a possible bug I've created a MSSQL data source with this query (the cat column can be ignored): SELECT 123 AS ref, 1 AS cat, 'EQU' AS country UNION ALL SELECT 123 AS ref, 2 AS cat, 'EQU' AS country UNION ALL SELECT 123 AS ref, 3 AS cat, 'EQU' AS country UNION ALL SELECT 567 AS ref, 1 AS cat, 'ESP' AS country UNION ALL SELECT (...)

(...) : 'KHL_B030','KHL_B020','HL_B008' Filter: {COLUMN:ID#ID} in ({1027}) Expression preview: ID in (''KHL_B030'',''KHL_B020'',''HL_B008'') The single quotes are escaped and therefore I get an error: query test Error occured during business rule evaluation. Syntax error: Missing operand after 'KHL_B030' operator. #The second approach doesn't work either Field value: KHL_B030,KHL_B020,HL_B008 Fil (...)

(...) In a step, I configured an On timeout action that runs a SQL procedure (a very simple query that updates a field in another database) after 1 minute. However, occasionally—about 1–2 times out of 100—the field is not updated, even though in history shows that the action was executed successfully. An external process calls the WEBCON API using a specific path. On that path, a SQL procedure action is (...)

(...) Hi, I have a MSSQL data source with a column newHash that get's created by HASHBYTES and VARCHAR(64) in the SQL query of the data source over some other columns to check if there is a value updated. This hash gets stored in the dictionary entry together with all other values. In the same query I also add the column with the diHash of the associated dictionary entry. When doing a daily sync betwee (...)

(...) ce always Entra ID login? And if yes, is there any way to force this login page if e.g. an admin user (not existing in Entra ID) wants to use local AD as authentication provider? This could be e.g. a query parameter: ?forceLoginPage=true. Kind regards Sébastien

(...) processes, where we can have several dozens of documents, it is impossible to find the right document. WEBCON does store attachments as relations, therefore it is technically possible to submit a query to SOLR to search for documents only. But it would also require a permission layer so that only documents are returned to user has at least read permissions. Although I more or less know how to impl (...)

(...) turns the value related to a given element in report. The value is stored in a table located on another SQL Server (linked server), which is already connected to the WEBCON database. I tried using a query like this: SELECT Value FROM [serverX].[Mydatabase].[table] JOIN [serverY].[WEBCONdatabase].[dbo].[WFElements] ON key = WFD_AttInt1 However, the report fails with a generic error: “Failed w (...)