search results

(...) changes anyone encounters when testing the new version in a single thread. It won't take much of your time and will potentially save you more when others do the same. I will start with this one: sql command: Varriable WFCONCOL_ID : WFD_DTYPEID = {DT:12} and {WFCONCOL_ID:153} = {WFD_ID} has been "translated" to WFD_DTYPEID = 1 and dbo.ClearWFElemId(WFD_AttChoose1) = 2 and is now replaced (...)

(...) Hi community! We have 2 choice fields, first one is a dropdown (field1), second one has behaviour autocomplete (field2). Dependent on selection in field1, datasource of field2 (which is an sql query containing value of field1) changes. This is working as expected. Picker search mode of field2 is set to 'Contains', minimum characters = 3. Regardless of what is entered in field2, all availa (...)

(...) Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not wor (...)

(...) s columns of an item list. Would only be displayed for the test button of the expression editor. Currently it's also displayed for the "Show" buttons which forces me to replace the variable in the sql management studio myself. Best regards, Daniel

(...) Hi, Is there a set of rules, an instruction on how to directly (using insert-sql ) import data into the database (into the WFelements table)? Which field values should we generate so that there are no problems with the operation of the application. Of course, WFF_STPID - step ID, WFD_DTYPEDID - form ID depends on the process, and the rest, e.g. RowVersion (some hexadecimal value) ? And other?

(...) sage is displayed: "403 - Forbidden: Access is denied.\r\n You do not have permission to view this directory or page using the credentials that you supplied." I checked the security settings for sql LowPrivilegeUser. Has anyone encountered this error in a newly configured webcon environment? 04.07.2023 Closing. The error was caused by an IIS setting. IP Address and Domain Restriction (...)

(...) Hi all! Is there any official (or unofficial) documentation on Webcon designer studio parameters, like --sql or --iedebug? Is there an other way to logout from designer studio, without havin designer studio started? The problem is, studio does not start anymore and I want to try a different Url or browser login, but I am not able to change this. Best regards, Nik

(...) Hi all, I need to schedule a daily email (let say like an email from a sql job), but I didn't find how to do it. It is a possible to do that from WEBCON? Many thanks, Ovidiu

(...) Hi everyone, I wanted to ask if anyone knows where or in which table the "Fixed values list" are stored. I am using a "Start a subworkflow (sql )" to migrate data from our old sharepoint workflow tool to Webcon. Unfortunately, it seems that Webcon has decided that 'Choice fields' always require a GUID#Name to be populated. (Without this format I get an error and the subworkflow does not run). (...)

(...) Hi, I have a problem with the execution of sql queries in different environments using a Default connection (after moving the system to AZUR-e servers). sql Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parame (...)

(...) pecific Application. We can dig into the BPS Studio and check Application, Process, Worfklow, Document Types permissions. We can check actions, business rules, etc. We can try to do it better via sql or/and WebCon BPS Application. It is well described here: https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3 Sometimes we need to use groups which are cross Application (...)

(...) Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS sql ) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS sql , too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Kl (...)

(...) reate report that will be showing all instances , which current logged user had task to do in the past. Some user can have more than one task in workflow. Is it possible to prepare such report and in sql filter make a join statement similiar to this: SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY [WFD_ID] ORDER BY WFD_ID DESC) rn FROM [BPS_ConfigProd_Content].[dbo].[WFElements] (...)

(...) Hello everyone In a process I run a cyclic action in the Global Actions. This action contains a "Start a subworkflow (sql )". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the sql query of the subworkflow action... So now I am facing the mystery where exactly this error occurs (...)

(...) After installing a new development environment, I have a problem with performing an sql query to the BPS_Config database. The environment was installed with my administrative account. From the database level, I can also see that the users of the service and the application pool (db owner) have permissions to the database. The application pool is the account indicated in the installer as the user to c (...)

(...) lly. Selecting a users took now multiple seconds. You can see that there are three calls for the people field "Responsible" which took in total about 5 seconds. I worked around this by creating an sql data source, which made the form usable again. In the screenshot the "Owner" field uses the sql datasource. The drawback this has is, that it's no longer a people field and everywhere I have to se (...)

(...) How to display data from another database (added as an MSsql data source) in a report? How to do this in a new report? Or maybe it could be added to another process report

(...) m . By changing the columns of the report in the source database, for example clicking the "default view" checkbox twice, (4), the variable definitions had been restored (5). You can execute this sql statement to verify if there's something for you to do. It should not return any rows. SELECT TOP (1000) [ARP_ID],[ARP_APPID] ,[ARP_Name],[ARP_Configuration] FROM [dbo].[AppReports] where ARP_ (...)

(...) hi I have datetime type fields i.e From and To , i want to check in current db table (WFElements), if datetime exist or not between two dates validating on form submit path using sql query. Issue: all the time showing validation error message , My validation Sample below: select case when ( SELECT count(*) FROM [BPS_Content_Prod].[dbo].[WFElements] where wfd_attchoose1='{1189} (...)

(...) of stem is for example 111 and 112, and if is in step C or D then the list have only options 4-8. of course i would like to reset value a drop down list when enter to step C . BTW: I don't know sql yet ... and in editor in filter there is no if then else .... so .... it works only in first step ... but later not ... if is only case1 then is 3 items works to the end ... A to D but if I ha (...)