search results

(...) ew of all ids and which fields, tables you need to replace in the above command from: SELECT * FROM [dbo].[DicTranslationsObjects] The attached image shows the executed SQLcommand and the drop down values for the German language. Best regards, Daniel

(...) lt. w System.Data.DataRow.GetDataColumn(String columnName) w System.Data.DataRow.get_Item(String columnName) w WebCon.WorkFlow.Base.BusinessLogic.ElementManagement.FormFields.Choose.Choosevalues Loader.c__DisplayClass7_0.b__0(DataRow row) w System.Linq.Enumerable.c__DisplayClass7_0`3.b__0(TSource x) w System.Linq.Enumerable.c__DisplayClass7_0`3.b__0(TSource x) w System.Linq.Enumer (...)

(...) Hi everyone, maybe I have a wrong idea how a multi value picker field is used in filters/groups in reports. Current situation: The picker field will store the selected values in the order they have been chosen. If you use this field as a group, every unique "string" will be used as a group. Example: Workflow instance 1: IT: Research & Development Workflow instance 2: IT: Research & Deve (...)

(...) ield value (see 1.png) - Rule works fine if clicked on 'Test' button - This business rule is used in the cyclical action 'Update related workflow instance' with the goal to update a workflow's form values on an interval (thus using 'Change value of single field is not available as an action) - In the 'Data' tab for the action configuration I insert the process business rule for the desired form field (...)

(...) Hi, I noticed something strange in the database values for a choice field - a hash in front of the ID (screenshot attached). Has the behavior of the database changed? In the documentation I still find it's supposed to be ID#Name, no mention of a hash. Best regards

(...) Hello everyone I have question about Suggested report - when there is many threads and many values in categories not every value in each category is shown. Only firest 10 most common values are shown. I need to use filters to received less common data. For example - I know that Tomasz is author of some threats, but he is not visible in category "Author" becuase amount of this threats is less th (...)

(...) Is there a option to insert values do database (my own table) by the button added in html form? My idea is like a picture I addend, but when I click on the button I get error Message=Error occured during rule SQL Dodaj powiązanie (Id: 136) evaluation. Source=WebCon.WorkFlow.Base StackTrace= at: Evaluation requested at: Evaluation node: Rule at: Evaluation node: SQL InnerException: Message (...)

(...) ing elements (+) button. There is a choice box that opens a list of available items with important columns. You choose one or more items and closing the modal populates the items list with the chosen values . That's an obvious way. But, the obvious way is not really what I'm after. This is because the pop-up list of available items is not very usable for salesmen who need to find objects by several p (...)

(...) entered some data? Sorry, the process configuration has been changed, reload the form and enter the data again. - You are creating some query inside an action template/automation and need form field values in an instance? Sorry please reload. Are there any chances to make this a little less strict? Best regards, Daniel

(...) olumn. It was sufficient to click on the view and hit the save button. 3. Data source I had to remove the field, add it again and correct any usages, where the old column was used. 4. Copying values in the content database An archive database was not involved. Update WFElements set WFD_AttText1Glob = WFD_AttText1 where WFD_DTYPEID in ( select DTYPE_ID from WFDocTypes where DTYPE (...)

(...) Hi all! We have to transfer some values from old database fields to new database fields, since we want to switch some fields in process to global fields. We plan to do this with well know T-SQL statement (UPDATE WFElements SET ...) within a cyclic action, which can be triggered on demand. Does anyone know if there are any restrictions in Webcon SaaS (Software as a service) regarding SQL UPDATE (...)

(...) Hi, We have a following scenario: 1) An user has a form field where he can choose mulitple values in one form field (lets say different persons) 2) Then the user submits the form and it goes to a SharePoint list. We'd like to add the same number of records to Sharepoint list as the number of values selected in the abovementioned form field. So each record should represent one person and have other (...)

(...) es, can I get WEBCON BPS 2022 to take the e-mail subject as content for a field "Title" and the mail body as content for a field "Description" (multiline field)? I found the ability to set default values within the HotMailBox configuration but this does not fit the needs if i.e. different tickets arrive at a HelpDesk application via e-mail. Can anybody guide me to an approach please? Thank you (...)

(...) delete row. It would be really handy especially if there are some flaws in process and some rows on item list that shouldn't be there. Now if you want to delete them by action you have to use Replace values option with SQL Query that returns only rows, that you want to leave in the form, so other rows are going to be deleted. The problem is that every row is deleted and than rows from SQL Query are adde (...)

(...) Hey everyone! Is there a way to keep line breaks (CR-LF) in the output of the SQL Command used in a Business Rule? I'm selecting values from DET_LongText1 which has line breaks. I'm attaching 3 images to show what I mean. 1. Webcon Form: What I see on the frontend. 2. Notepad++: What I see in Notepad++. 3. Output: What I see in the email if I output the value of the field with a Business Rule. I (...)

(...) Hi @all, I´ve many processes they use the same rest-request to fill choice fields, table, etc. But the request requires a dynamic values in _url-parameter_ or _request-body_. At the moment i´ve to clone the *same* data source for every process... not nice ;-) ! A parameter would solve the problem - like as parameter into rules! Thanks and best regards Daniel

(...) Hi all! We want to add some rows to an item list with 'Change item lists values ' action. The SQL query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which result (...)

(...) ields with empty value on path transition. The idea is that I have a cyclical process and I need to clean some fields in order to be available on the next step. I'm trying to use the Multiple Change values to make them as empty, but I'm being unsuccessful here! Does anyone have any ideas? Thank you all!

(...) d way to add new items to an item list on the client side. We already found a way to add new item (which can be triggered by a form rule) and set some form fields before, which then act as default values for the new row. Since it all is asynchronous it has to be a promise chain, like this pseudo code: p.then(() => { SetValue(formField, 'Value') }).then(() => { InvokeRule('#{BRUX:1526:ID}#') }) (...)

(...) Changing from checkbox to a drop down with "Undefined", "Yes","No" and every value is set to "undefined". This will of course be annoying to set since you can't simple click through with the default values but it will force you to think about your decision. Maybe a parameter could be added so that you can activate whether the drop down value will be "undefined" or the current default value. So that yo (...)