search results

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

(...) ration I still have comunicate at workflow designer: "The database contains workflow instances associated with this step. You must delete those elements first in order to delete the step". On which sql table I can find that archive elements? Any ideas how can I fix it? Thanks advance for your help.

(...) d 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 added so every row h (...)

(...) workflow dependent on other columns from the same workflow item, e.g. WFD_AttDecimal1 = WFD_AttDecimal2 * WFD_AttDecimal3. Sounds trivial, but it isn't, especially in a SaaS system, where 'Run an sql procedure' is missing. Another approach for us was to use 'Update related workflow instance' action, but this approach obviously leads to nowhere (maybe this is a bug or document context is missin (...)

(...) ebcon Team. Unfortunately I do not find any documentation on that, especially how to iterate over 'Any Collection' and access columns in custom action. If I select 'Any collection' and put some sql statement in there, is there a way to access specific table columns from generated table result? If I take a look at the configured XML I only see {ANYCOLLVALUE} macro. Hope the question is cle (...)

(...) nt: /api/data/v4.0/db/{dbId}/elements Now we are facing the challenge to check if there are already elements in our system, to avoid duplicates. This can also easily be done with an integrated sql query like Select Count() from WFElements WHERE ... So we need to cancel save operation if this condition is met. Since it is a fresh workflow element it should not be persisted in database. Un (...)

(...) Hi community! In some scenarios it is necessary for us to render datatables on form containing some custom links or buttons. For this reason we built following sql statement for testing purposes: SELECT 'Internal' AS ID, 'Click me' AS HTML UNION SELECT 'Azure' AS ID, 'Link' AS HTML And we used this datasource in a datatable field on form. However, we have some interesting results. (...)

(...) Hey, now all 4 databases (Config,Content,Content_Arch,Content_Att ) are on the same MS sql server. Do you have plans to give opportunities to host each DB in deddicated server? For example - to have 4 MS sql Server , 1 for each BPS database.

(...) t, but as a separate workflow elements. I want to implement Asset Management workflow, but need to enter into the system few thousand items (PC's, servers etc.), which are currently stored in another sql database.

(...) nformation as a data row in the child. But I need to alert the responsible on the child flow so they are aware that the field was changed. I'm not sure how to play with versions or IsChanged (using sql command) to created an execution action for this and I don't want to add another field so they can enter the final date. Does anyone have any ideas? Thank you!

(...) Hi everyone, I have problem with adding multiple attachments. When I use action "Add attachment", I can add only one attachment (picture1). When I use the same action, but the sql query returns more the one attachment - the action doesn't work (and it doesn't matter if the ID's of attchments are in the one row or many rows). Thank you for your time :)

(...) e idea structured, I'm facing some questions in regards to: - How can I initialize dynamically the item list with an information from an integer form field? Didn't find anything in the options using sql query - Is it possible to translate the number of months as text field, example, from today until end of year, we have September/October/November/December, or at least, have in each row the month nu (...)

(...) web browser tells an error: HTTP Error 502.5 - ANCM Out-Of-Process Startup Failure Investigating this I started the file "" within path "" manually and received the error dump added below. The sql user can connect with the password given and all rights within sql server are appropriate. What looks strange is the attempt to reach the server through Named Pipes. This is not configured. D (...)