search results

(...) value. It would make more sense to group according to the display option the grouped column is set to. Especially because i dont know how to do calculated columns in SOLR reports like i used to in sql -reports. ;) I have attached a screenshot to make clear what i mean.

(...) Hi All, I have a workflow where I use “Start a subworkflow (sql )” action. I also have a “Wait for sub-workflows(system step)” step where I wait until all the subworkflows will end. I configured the “Wait for sub-workflows” to go back to “register step” when one of the subworkflows finished negative. See picture And here are my problems: Let say I started 3 sub-workflows and one of them went ne (...)

(...) Hello folks, I have to create a Word file with data from several workflows and therefore created business rules with sql Commands in them to help me with that. The problem is, those business rules are nowhere to be found in the Business Rules section of the Word Add-in. Several other rules are shown, but those with sql Commands in them are just not there. Is this a known behaviour, or a bug, or is (...)

(...) Hi everyone, I had the requirement to calculate a reminder date based on a due date. This should be x days before while respecting the working day calendar. sql Command for calculating a date _after_ the base date, attachment (1): select Top 1 [CAL_WorkingDate] from ( -- Top: number of working days before the base date SELECT TOP {BRP:13} [CAL_WorkingDate],[CAL_IsWorkingDay] FROM (...)

(...) er a new installation according to the instructions "WEBCON BPS standalone installation" (windows 2019 and updates, .net 4.7 installed automatically with the system, .net core hosting bundle 2.0.9, MSsql 2019 express, Ms sql Server Management Studio 18, IIS with Windows Authentication) -in the browser error http 500.19 - internal server error. Additionally, it is not possible to start the website co (...)

(...) nospaced. Simply it's easier to read code, when it's monospaced. In attachment you can see and compare how that simple lines are better aligned, with monospaced font. When you edit some more complex sql Queries, or when you deal with some custom HTML element - it would make life just easier. There is some question, how to deal with with those Webcon Variable blocks - how they should be aligned, but (...)

(...) ion, but works for a single subworkflow. I don't want to use hyperlink. I must enter on the subworkflow in the start step. Is possible to start different subworkflows from a main workflow with sql ? I don't have an item list. I need to define an sql action for each subworkflow? Can I have an example? Thanks

(...) only possibility to show only one "Item list" attribute but is there any possibility to create some technical data table or atribute to show more than one list? Or maybe you can give some example of sql function which select more than one "Item list". Thank you in advance for your help.

(...) t, as there is no function that allows me to do this (or I can not find it). The only procedure that allows me to change the items list and add rows that were not there is the initialization through sql . But in this case I don't need any initialization at all. Is initialization the only way, or do you manage to cope in such cases in some other way?

(...) How to use the mentioned function (https://community.webcon.com/posts/post/function-dictionary-for-business-rules-and-form-rules/237) without sql to get the date value for the last and the first day of the current month in the default value field of datetime type attribute?

(...) tion 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=Error occ (...)

(...) Hi, because of the lately very, very poor performance of sql -Reports I have changed some reports to Searchindex. The sql -Reports always only show the workflows that the user has access to, after I changed it to SearchIndex every user sees everything in the report, but of course then can't open the instances they dont have permission to. The predefined Filter is set to all. Is there anything I can (...)

(...) Hello, I tried create sql script for created a global business rule with existing multiple global business rules . I tried use of multiple global business rule ( with parameters) in one global business rule (with parameters). Every global business rule used has parameters. The business rule that appeals to the other business rules has parameters that are mapped in the appealed rules. I get the e (...)

(...) Sales Location 0002 -> 1,2,3,4,5,6,.... max. 999999 . . . Is there a way to generate a unique number for each sales location in a custom action, and if how? We thought about executing an update sql statement on workflow containing sales locations incrementing a certain number field. Btw. this should be thread safe ;-) 2.) Instead of putting this reservation actions (custom action + SOAP acti (...)

(...) Hi, I add new connection (MSsql database) - test it with success. Next I add new data source with some sql query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property (...)

(...) several thousand documents is not an option. It would be best to use the option to check permissions to open in the browser, but that didn't work for me. I was thinking about using a dedicated BPS sql procedure [proc_WFSecuritiesInsert] to add access for a group for specific cases but I don't know if it's a good solution. I don't know what is the general approach to doing something from the ba (...)

(...) form1, step2 and 2 days, saved it. 3rd record as form1 ,step1 and 1 day. when I clicked on save, it should give the a error message as given in the validation error message panel. The sql I have on the form validation action on Save path is checking for IF NOT Exists and passing value 1 when the user entry is not a duplicate which means validation is successful and should allow savin (...)

(...) xml, sometimes mapping fails (multi level structures cannot be mapped) Proposal: similary to REST action, give possibility to get back whole respond xml. Then you have the chance to get content with sql query. What do you think? Thank you! BR, Peter

(...) urchase out of the group of 8 is meant to approve the order again. But not the user having done the first approval (1). My approach would be to get the first approver from the tasks table via sql and make sure that he is not within the users for the second approval. So that this user would not receive a second task on that workflow instance. Does that work or is there a better approach? (...)

(...) ask Creation The user assignment to the single approval tasks shall be done through AD groups as the members change frequently. 3) Approach In both steps the task assignment is performed through sql queries that retrieve the users from the active directory. To support a simple configuration of the AD group names process constants are used to define the group name. 3.1) sql query for the first (...)