search results

(...) Hi, Can I achieve such an effect in an calculated column? In sql it works but in webcon I have an error If atrubut is empty display the grouped attribute from the item list Code: select ISNULL(WFD_AttChoose5, STRING_AGG (CAST(DET_Att1 AS NVARCHAR(MAX)), ';')) from WFElements W left join WFElementDetails WD on W.WFD_ID = WD.DET_WFDID group by WFD_AttChoose5 What needs to be corr (...)

(...) Dzień dobry Mam problem z wykonywaniem akcji globalnej, która ma za zadanie startowanie obiegu sql . W zapytaniu zastosowane jest open query do serwera oracle. Przy teście zapytania lub puszczeniu akcji globalnej dostaje błąd z załącznika. W management studio zapytanie jest wykonywane normalnie Proszę o sugestię Wersja Webcona 2022.1.4

(...) hing accepted, like single line, and then you can delete the column and then change it to data row in order to keep your report. In this case the error GUID will show: "...Invalid column name 'SEL_sql Row'." version: 2023.1.3.169, but I don't think the version matters. I hope we get the option, at some point, to manually remove such column from your report if it was added before when it was no (...)

(...) cription b) attachment 2. I start child process a) copy data + copy attachments b) i would like to populate the same in child item list with records correlated with coped attachments ... I did sql source: [code="sql "] SELECT e.DET_ID as 'ID wiersza dziecka', e.DET_WFDID as 'ID Elementu Detalu dziecka', e.DET_WFCONID as 'ID Listy dziecka', e.DET_Att1 as 'Rodzaj dokument (...)

(...) rivate view without having to mark each result. Each time this view is opened, it would present the results for that phrase. Currently, results need to be marked manually, or such a report with an sql filter has to be created administratively.

(...) it should be stored only on order, but not on suborders. In the reports i have one report for orders, second one for suborders - on suborders I'm able to show 'customer' using custom column. With sql like this: ( SELECT dbo.ClearWFElem(WFD_AttChoose2) /* Customer */ FROM WFElements JOIN WFSteps ON WFD_STPID = STP_ID JOIN WorkFlows ON WF_ID = STP_WFID WHERE WF_GUID = 'af556142 (...)

(...) Hello all, I have a data table field where I'm selecting the fields using a sql query. One of the field is a picker and I want to show just the Text and not the ID. I've tried many options but as soon as I try using the Database-Name, it's giving errors. I believe it's because the option has space on it : 'Non Ok'. But the system should overcome this right? Even using the DBO function, it doesn' (...)

(...) the actual name of the environment. I know there's a table and inside is a row which offers this, but I thought there might be an environment variable offering this info rather than having another sql call. Thank you, Mihail

(...) Hello there :) I have a problem when trying to generate a table using the manual initialization via HTML Button. It only works when I initialize the table manually. I want to use sql however, to automate the whole thing. I failed using many Select Statements. What would be the ideal Select statement that would return the days between two dates, which happen to be the attributes? Best Regar (...)

(...) erform an Excel export of the current state via the DATA TABLE. Recently, we have been hitting the limit of 1000 rows more often (https://docs.webcon.com/docs/2023R3/Studio/Process/Attribute/DataPres/sql _grid/#7-allow-excel-export). I would like to propose a review of the current server performance to determine if it is now feasible to increase this limit to 2001 (header + 2000 rows) or, ideally, (...)

(...) clude unavailable tools. Unfortunately i didn't find the way to do it using the REST API filter available in WEBCON. My plan is to create some table in WEBCON, fill it with data from API and then use sql for filtering. Is there maybe a better way to do it?

(...) rendered if they are used in an item list data row column.: https://community.webcon.com/forum/thread/5247 I tested the most common/likely elements and to verify which are supported by using this sql query: select 'a tag' + ''+ 'button tag' + ''+ 'div tag' + ''+ '' + ''+ 'img tag' + ''+ 'input tag' + ''+ 'p tag' + ''+ 'span tag' + ''+ 'strong tag' + ''+ '.class'+char(123)+'display:no (...)

(...) ark colors, thus saving their eyes and improving the comfort of their work. The second topic is the code editor. Currently, in Designer Studio, the place where we edit code that is, for example, "sql command" is probably a regular notepad without support for, for example, tab. It would be useful to have such a small VS Code in the places where we edit code. Reports of this type have already a (...)

(...) . I thought about adding a timeout to check if New comments were added in the request. I know that in the notification configuration, I can select the last comment entered. But I want to create a sql rule to active/inactive the timeout. For that, I want to check if new comments were actually added. Do you have any idea how to accomplish this? Thank you

(...) . Obviously I would like to avoid manual work. Do you have ANY idea if the 'change form type' can be somehow automated? I need to change form type X to Y, no diferentiation whatsoever. Maybe some sql ? Changing WFD_DTYPEID in WFElements and WFHistoryElements will be enough? What do you think? Thanks in advance. Wojtek

(...) Hello everyone, I need your assistance with something. I am currently working on a Business Rule that should return a value using sql . The Business Rule needs to be as universal as possible, and I want to pass two parameters to the sql query. So far, so good. The issue is that I want to pass the same form field as a parameter twice: once as a value and once as a "column name" (essentially as an (...)

(...) Hello! is there a best practice how to transfer data from an external data source (eg. sql server) into a dictionary in webcon (and webcon in general)? I heard something about a technical path?

(...) Hi, this may sound strange, but so was the reason, why I'm proposing this. My suggestion is that the expression editor for a sql command inserts the instance id variable in a way: Currently it is inserted as: {WFD_ID} My suggestion is that it is inserted within single quotes: '{WFD_ID}' The reason for this is, that it would prevent errors which may only surface in production. This is th (...)

(...) er 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 checks if someone has an AD user or not, isn't working when I pass parameters like ##Vorname## [engl. Firstname] and ##Zuname## [engl. Surname] (which turns into {Vorname} & {Zuname} (...)

(...) so .. how to pass by path but keep A and C as finished and B and D as Waiting ? and for example add (assign) E as Waiting ... I don't see other option than "update parent flow" with out "moving by sql " ... but if moving then go by path .. then ..