search results

(...) itive. I thought about using the advanced settings, but I have no idea how. Documentation: You can also define the path dynamically. To do this, select Use advanced settings and create a suitable SQL query in the Advanced path choice field. When is this executed? a) When the first sub-workflow is started b) When one sub-workflow finishes c) When all sub-workflows are in state finished Verification pa (...)

(...) o add news values in an item list? I'm trying to add a new line in one item list but one of the field I'm copying into is a Person/Group one and it doesn't get the value. I'm using the following query : select '{WFCONCOL:1769}' as {DCNCOL:105}, 'Requester Manager' as {DCNCOL:104} from WFElementDetails where DET_WFDID='{WFD_ID}' and DET_WFCONID={WFCON:1652} with the unique value set to be (...)

(...) tachments is checked-in (so the version will be different than 1) before moving the workflow to the next step. In the validation form, I don't have the attachments system so that I can construct a query to verify this. Does anyone have an idea? Thank you!

(...) Currently, views do not allow dynamic filtering on views for datetime and people-picker fields. It can be done by extending the query in the datasource. The datasource can only be changed by administrators and designers. For end-users it would by great having the possibility to use placeholders for filtering datetime and people-picker fields. My idea is having placeholders like [now] / [today], whic (...)

(...) on for the new candidate. There are some issues with this, I'm not able to initialize the item list with the dictionary details (only DB or Sharepoint is available), I don't want to do this by SQL query because in the future I will need to do maintenance work if something changes. And the user doesn't want to click Add for all the options needed. I don't have many ideas on how to this. Hope (...)

(...) he time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggling by running this query by (cyclic) action on a separate path. The path is walking through fine according to the history, but no changes in the end. If I run the query with the "Test" functionality in the webcon Designer ev (...)

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