search results

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

(...) ersion 2021.1.5.367) I have an items list with (amongst others) a column for (multiple) attachments. Out of each line of the items list I start a workflow instance of another (start a subworkflow sql ) workflow and the attachments shall be copied to the new instance. Idea 1: I check "copy attachments" in the "Start a subworkflow". Issue: all attachments of the parent workflow are copied Id (...)

(...) o add alias and update the documentation, so that only the alias would be used. "ElementName" would get the alias "Subfolder" "Category" would be "Filename". This way: - We won't break the old sql statements - There's no need to create a migration script. - New users wont be confused. Best regards, Daniel

(...) e contains multiple fields as well as lists. What would be the easiest way to achieve this using WEBCON? I was thinking of writing the content of my XML file into a technical multiline text field via sql and then extracting it with the "Change Values" action. The lists would be handled with the "Update Item List" action. Is this possible? Thank you very much for your help!

(...) What is the possible and if, the most efficient way of getting data from a dictionary into a js file that is supposed to read all the items from said report ? sql (business rule, then convey it to the js file as an argument) or we can natively do it in js ?

(...) and now in sub process I would like to split this table to: A >> a A>> b A >> c A>> z B>> a B>>z .... D>>a D>>b how to do it? probably is easy like 1-2-3 ... I tryed generate sql code .. but is not working ... SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL_NAME:1174} AS 'Kategoria', ST.Item AS 'Punkt normy' FROM WFElementDetails d CROSS APPLY (...)

(...) lo everyone, Unfortunately, no archived instances are currently taken into account in the Advanced Analytics Framework. Since we perform archiving cyclically to keep the memory requirements on our sql server low, the required process insights are not displayed in the Analytics Framework. For large processes, the processes are currently archived 3 months after the instance is completed. In princ (...)

(...) [Webcon 2024.1.1.130] (i thin it was working in 2022.1.4.404 - but I need double check] I have action to update item list where source is Parent Item list. The sql query is working but filters .. works if there is no polish letters :| so: [code='sql '] SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL:1135} AS 'Sygnatura Audytu', d.{DCNCOL:1132} AS 'Tytuł raportu 8D', d (...)

(...) nt instance has a number or related "kids" (instances) and only one unrelated, but all from same workflow. In order to indenfity the unrelated "kid", the parent has the wfd_id saved in a field. The sql that I use in the advance settings for the "wait for sub-workflow" verify if the total number of "kids" (related or unrelated) is equal to the total number of "kids" that are in a specific step (it i (...)

(...) es there were two different dashboards set as Default. Does anyone know how to fix this? Error: System.Exception: Exception occurred while importing table AppDashboards ---> Microsoft.Data.sql Client.sql Exception: Cannot insert duplicate key row in object 'dbo.AppDashboards' with unique index 'UQ_AppDashboards_IsDefault'. The duplicate key value is (8). The statement has been terminated. (...)

(...) advanced) dont show any past vacations. We updated to 2024.1.1.161 after finding changelog notice, that some problems with vacations report were repaired. Our config: We use a data source with sql view with past vacations, and all type of data in columns are correct: VAC_UserID VAC_From VAC_To VAC_VACTypeID sql : select * from [V_Urlopy_Historia] After some tests we've done: Afte (...)

(...) . The problem is that in my leave of absence workflow I have an action that sets up substitution for the time a person is out of office. When I run a test (see left side of the enclosed screen) the sql query shows correct dates of substitution (the same as te person's absence). When the acton runs the substitution is set to last for one day longer than expected. Why is this like that? Where am I do (...)