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

(...) Hello! In the form, I have a list of items X that is sorted by column A in descending order by default. How can I set up an action to generate data into a .docx file or specify an attribute for the list of items in the .docx file so that the exported table with the list of items X is sorted by column A in ascending order? The descending sort by column A is because the data is being added to the ta (...)

(...) Hello, Here is something I've come across recently, if you have a report that uses a field that got changed to a data row then: 1. the report will be in an error state 2. you can't remove the column from report configuration panel. I understand that such a column is not allowed in a report, but at least let me exclude it from the report. The only way to fix this is to change the column back to (...)

(...) ebcon design studio ... is close to crash ... any way ... if i do: "e.DET_WFDID = 'parent id' i have what i wont (just for check). on path if I put that automation - it semi work ... is filled column s but whatever is set as "attachment" always returns "attachment was removed" another issue is doubling records ... (probably to many joins ... )

(...) Hi, I've inserted a line chart to my form. It gets data from database (4 column s). 2 column s are presented on a chart as data series. Sometimes there are nulls in one of the column s. Then Webcon interpreters it as 0. Do you know any countermeasures to it? If there is a null value from the database, then it shouldn't show that line at the given point in time. I attach a photo of that such graph wit (...)

(...) A good and useful option for system users would be the ability to create filters on a column using a narrowing phrase. For example, by entering the phrase "BX2TD6" in the column filter with the function "contains phrase," users could create such a private 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 (...)

(...) Please vote for this user voice, as it already have more votes, and is exactly the same ;) https://community.webcon.com/forum/thread/4134?messageid=4134 Hello, when working with custom column s in reports I'm always trying to avoid using regular ID when comparing forms, workflows, processes etc. I'm almost always joining with specific tables to get GUID, so reports won't break between environments. (...)

(...) se.ReadOnlyItemsCollection`1.GetByID(Int32 id) at WebCon.BpsExt.Signing.Autenti.CustomActions.Helpers.RequestBodyProvider.AddSmsAuthenticationnConstraints(List`1 constraints, ItemRowData row, Usercolumn s userData) at WebCon.BpsExt.Signing.Autenti.CustomActions.Helpers.RequestBodyProvider.AddParties(ItemsList itemLis, Usercolumn s userData, Boolean setUserPriority) at WebCon.BpsExt.Signing.Aut (...)

(...) maybe, in further coming WEBCON versions there could be the possibility to add 2 more "section layouts" like i posted in the picture. Mostly the usefull one would be: half side left, and two small column s in the right half. With this layout options designing dashboards and grouping buttons would work much better. Thanks, Bjoern P.S.: Maybe i forgot the third version 25% - 50% - 25%, if some (...)

(...) Hi everyone, Jarosław created a threat in which he points out that elements are no longer 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' (...)

(...) item list. Basically, this works well using an appropriate Excel template. However, I have fields in the item list that are filled from a fixed value list and the action then creates an entry in the column in the format [ID#Name]. But I only want to see [Name]. What am I doing wrong?

(...) on action Start Counterparty Card. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_WFElementDatails_WFD". The conflict occurred in database "BPS_Content", table "dbo.WFElements", column 'WFD_ID'. The statement has been terminated." I have exactly same button configured in other workflow in the same application and it works fine. It is irrelevant what hyperlink I try to open, I als (...)

(...) f the report. I want to show the sum of days in each step of the process (Bar chart) and the average Day(s) in step as a Line chart. This is not working. I don't have any filters, nor calculated column s. I've tried to create a chart with another field to check if the issue is related with Day(s) in step field, still I get the error. Does anyone configured something like this? Thank you

(...) forgot to add the single quotes in a where condition using the id of a choose field Wrong statement: and {WFCONCOL_ID:544} = {WFD_ID} Correct statement as of WEBCON BPS 2023 with the calculated id column s: and {WFCONCOL_ID:544} = '{WFD_ID}' The big question is, why was it working in the first place and only failed in production? The production database contains way more data and the SQL server (...)

(...) he quotes step, the user must enter the rows with the different values for the quotes and then send for approval. The next user must select what is the row of interest, but clicking on Select Option column . The thing is that in that step, because I want the item list to be editable, the Add button is available. Is there any way to allow the user to edit the item (to select the row of interest), but (...)

(...) Hello all, I trying to set up a form rule that sets the cell background based on the days difference between a column date and today's date. This only works after clicking on the save but I want the background to be set as soon as they define the Date column . Probably this will only work with Javascript functions but I don't have any experience with that. I want to create an alert if they select (...)

(...) Hey, I set up the default value 0 in column A of the Item list. How do you clean it by action or something on that condition where it is 0 then set an empty value in that row? A screen of the part item listed above

(...) Hi. Following Scenario: (Webcon Version 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 (...)

(...) 24 10:20:46 PM History save started. 8/21/2024 10:20:50 PM History save finished. 8/21/2024 10:20:52 PM How can i find this ID, FLD id? I was searching for this in this table but there is no ID column . Do you know how to find this?

(...) here I can't use the normal delete button. So instead, I'm adding one using a dataRow form field, where I call the JS function like this: deteteFunction(list ordinal number); In this list there is a column called IsOld, and it's values can be OLD or NEW. * If the line I want to delete has the value NEW in the IsOld column , then I want to just simply delete that line using the basic SubelementDelete(# (...)