search results

(...) 2022) of Designer Studio has obviously changed its default behaviour to using REST mode, I am wondering if there is any command line parameter (or something else) to start Designer Studio in good old sql mode. I did not find any documentation on how to do that. Any inputs? Thanks a lot in advance & best regards, Nik

Hi there, does anybody know why this error occurs? Happens the following way: - Business rule retrieves datasource column (from [CacheOrganizationStructure]) COS_AD_name by means of a form field value (see 1.png) - Rule works fine if clicked on 'Test' button - This business rule is used in the cyclical action 'Update related workflow instance' with the goal to update a workflow's form v

(...) Hi! Unable to retrieve data while processing sql Command, the error is: Error occured during business rule evaluation. The given key (-25) was not found in WFBusinessRuleDefinitions cache for current content database. at: Evaluation requested at: Evaluation node: sql The same error is while configurating action or creating a business rule

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

Dear Community, I have a question regarding attachments database. Size of the database is quite large and I'm trying to find optimizations here. Table / index compression is not a solution - compression ratio is barely reaches 0,5% level. I have found a lot of records in this database where attachments are deleted (column ATF_IsDeleted = 1). Is it safe to remove such records from database or i

(...) Based on Daniel post https://daniels-notes.de/posts/2021/retrieve-ps-variable-value I figure, it is posible to retrive output value from sql Procedure? How force "Run sql procedure" action to log ouptut to [dbo].[WFLogs] table? Write-Output in PowerShell is logged to LOG_Description column. How log ouput from sql procedure?

(...) Hi all! We have to transfer some values from old database fields to new database fields, since we want to switch some fields in process to global fields. We plan to do this with well know T-sql statement (UPDATE WFElements SET ...) within a cyclic action, which can be triggered on demand. Does anyone know if there are any restrictions in Webcon SaaS (Software as a service) regarding sql UPD (...)

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

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

(...) Dear Community, does anyone have any experience installing WEBCON BPS Standalone version on sql server Web Edition? Tried to find you if this version of sql server is eligible to use with WEBCON BPS but didn't find anything accurate. From technical perspective it should work (required full-text search feature is available). With this sql server Web edition license costs can be significantly reduc (...)

(...) Hello, WebCon BPS user can specify substitutions on the portal. Does anybody know, where the data is stored in the sql database? I'd like to create a weekly report with the data. We are on BPS Version 2021.1.4.55. Thank you! Cheers, Balint

(...) Hi, I have a following problem. I've created a data table form field that downloads data from sql query. In that sql query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date form (...)

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

(...) Hi everyone, I just had the need to get multiple rows of data without having access the the sql database. I didn't want to create a field for this one time use case. Unfortunately the 'Test' result window of the expression editor, didn't have the option to copy the result. Luckily I thought of the Administration Tools\Search Logs. As you can see in the attached picture, I was able to execute an a (...)

(...) Dears, During installation version 2022.1.2.59 appears error System.Data.sql Client.sql Exception (0x80131904): Must declare the scalar variable "@sql ". Does anyone know what the issue is ?

(...) Hey everyone! Is there a way to keep line breaks (CR-LF) in the output of the sql Command used in a Business Rule? I'm selecting values from DET_LongText1 which has line breaks. I'm attaching 3 images to show what I mean. 1. Webcon Form: What I see on the frontend. 2. Notepad++: What I see in Notepad++. 3. Output: What I see in the email if I output the value of the field with a Business Rule. (...)

(...) Hi. I have a big sql from 3-4 apps. Is the possibility to generate report from my sql data source ?

(...) Hi all! We want to add some rows to an item list with 'Change item lists values' action. The sql query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which res (...)

(...) Hello folks, We have used constants which contain sql queries for calculated report collumns a couple of times already, so this does work. But i now have a query which works perfectly when added into the calculated collumn directly, but no longer works when stored in a constant. (img attached) Through logs we found that he has a problem seemingly with strings, but we found no way to baypass t (...)

(...) rule which is perfect for new files. The customer wants to keep their document numbering. For the existing files I would like to update the Instance number (Database: WFD_Signature) using a small sql script. But is it safe and is it wise to do that? I'm aware the numbers need to be unique in the system, and I know they are unique in the old system. I will also do an extra check during migration.