search results

(...) time I experienced this error. Everything worked fine until Users list configuration step. When I try to configure the local AD as source for synchronization, I receive the error "The parameterized query '(@Email nvarchar(4000),@DisplayName nvarchar(4000),@BpsId nvarch' expects the parameter '@DisplayName', which was not supplied." I assume, that for one of my service accounts the property display n (...)

(...) te duplicates neither empty rows. For my case, the information to be checked will be Customer Name and Address (because a customer name can have more than one address). I was trying to follow the query below but I'm not sure on how to add the dictionary there (in the database documentation I have, I don't find alias for a dictionary=) if exists ( select 1 from WFElementDetails where DET_WFDID (...)

(...) ut they only work as form rules and for action (even creating a business rule, form rules don't work as it needs to a TRUE/FALSE result). Even using SQL Command I think it would only work for a subquery because I need to check the value on each row. I've used the Select Values in combination with GetNames function but I was not successful with my idea! Hope anyone has an idea on this!

(...) each new record entered. I can't seem to create an "application wide" variable that I can reference, create a new proposal # and then increment by 1. Now that I think about it like that, can I SQL query the # of records for the workflow? (Still fairly new to queries in webcon, any help would be appreciated). Thanks

(...) act match, contains phrase, starts with). In my company, we collect customer data from several CRM systems. For one of them, we have the customer's data materialized in the dictionary database. We query this data about 9 - 30 thousand times a day, on average one execution takes 3 seconds. After changing the polling method from like to exact match (mediated by the SDK add-on), it turned out that t (...)

(...) It would be great to be able to pass any attachment id to the 'show first attachment on page load', e.g. via sql query editor.

(...) Hi community! We implemented a document template with certain fields coming from a custom datarow (based on SQL-query ). We deployed the solution and the document template to PROD and everything was fine. After that we added one new field to the datarow (SQL query was modified) as a new requirement and added the new field also to document template. On DEV system everything looks fine, we deployed th (...)

(...) lumn that is mandatory to be filled whenever the item list has any rows and I tried many examples to construct a validation form rule in order to have information on that column. I was using a SQL query because: - Column cannot be required (there are cases that the user is sending documents so the item list will be empty) - Form rules using Condition By Row cannot be used inside the form validatio (...)

(...) D How do I get the (translated) step name? Is there some option inside the SDK? I haven't found one, so I'm thinking about passing ids/translations via the PluginConfiguration. I just thought about query ing a data source. Maybe I could create a SQL view which is utilized by the data source. Did someone do something similar and has some experience? Best regards, Daniel

(...) rson for the task is selected in that item list. This is bringing me many issues and challenges. First of all, I need to use 2 actions in the subworkfows to fill in 2 different Item List but my query is not bringing anything because I only get examples for the cases where we have parent and child select {DCNCOL:466} as {DCNCOL:462}, {DCNCOL:467} as {DCNCOL:463}, {DCNCOL:468} as {DCNCOL:46 (...)

(...) Hello. Is there a way to use a stored procedure as datasource instead of a view or table or Select statement? I use at the moment a query on two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server. Regards Klaus

(...) Hello, I'm wondering is there a simple way to do this. Sometimes "SQL COMMAND" returns nothing (there are no rows that match the query ). How do you test for this? IF "SQL COMMAND [...]" = EMPTY does not seem to work. Maybe there is a workaround?

(...) Hi there, I have a data source of MSSQL type, that populates a data table. The SQL query is quite complicated but it works. However it currently takes about 33 seconds to complete. Thus when executed in SQL Studio, I get the output table. When I try to execute it in a bps process, it fails. When testing in Designer Studio, I get an error of execution timeout. Is there a way to tell Webcon to allow a l (...)

(...) Hello all, Hope you're doing great! Does anyone know how to configure a query which will return where a specific user was set in any action? I'm using this article https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3 but I want to also check where for example the user is hard coded for the Task Assignment for example. Hope you got ideas! Thank you

(...) t is the column 'assigned to'. After removing this column from the report, all large reports are loaded almost immediately (even those with many calculated columns). It looks like in this version the query has been changed to the WFElementTasks array? I am curious if someone will confirm this scenario? Regards.

(...) Is there a way to query the database or check in the designer studio about the number of form fields created in our application?

(...) tion you need to fix? Sorry, please reload the form. - Oh you 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

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

(...) HTTP Error 404.15 - Not Found The request filtering module is configured to deny a request where the query string is too long. Most likely causes: Request filtering is configured on the Web server to deny the request because the query string is to (...)

(...) Hi! I have a process which generates subprocess (list is from sql query ). The subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors occurr (...)