search results

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

(...) elements where WFD_DTYPEID='77(Dictionary ID)' AND WFD_ID='Instance ID' AND WFD_ATTchoose1 = '{Form name}' and WFD_Attchoose4='{Step Name}') THEN 1 ELSE 0 END Is my SQL query wrong?

(...) Hello, Lately I was thinking about SQL optimization. So I did this query on production environments of our 4 random clients. The query shows where probably we should be thinking about putting index, because of high usage of those columns. Of course we all know that putting index on WFElements with attribute columns is not a good idea (maybe if you have secondary BPS_Content for only 1 process could be (...)

(...) Hello folks, The query in the attached image is not working in the designer, but working flawlessly on the same DB in the MSSQL Management Studio. Is there the possibility that the designer somehow does not like "ROW_NUMBER" function? Or is it a Webcon bug? I hope someone has experience with this already. Thanks in advance :)

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

(...) Dear Webcon Community! Problem: you cannot use datarow fields on portal reports. Proposal: make it possible as it was a calculated field on report, running as subquery What do you think? Thank you! BR, Peter

(...) rformed 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 user assignment Here no filtering is required except the appropriate AD groups: SELECT users.COS_BpsID FROM [dbo].[CacheOrganizationStructure] as Users join [dbo].CacheOrganizationS (...)

(...) Hi, I am trying to move multiple related child instances through an action. I tried doing that with the “Move workflow (SQL)” action. The query I used can be found in the Attachments. The table I get also looks fine, but I still get the Error "Incorrect column PATH_ID format". I already checked all of the IDs, they should all be fine. I used the following thread as a reference: https://alterpaths.c (...)

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

(...) We are aware that some functionalities are not available in a SaaS environment, like some query actions. But is there an official listing of what is not allowed in SaaS? Because Building and Testing a project on-premise, and having no way of knowing if something will break on PROD because of that is not acceptable. Is there a way to test for it? Or at least have something to read through to worka (...)

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