search results

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

(...) Hi, We installed a fresh Webcon server and attached the backup of the config database to a new sql Server and connected it to the new Webcon server. The config database now has references to the old host and the new host. Is it possible to remove the old host from the config db? Thanks

(...) nderful as me :) I need information about which users and at what level they have access to each application and process. I searched the forum but didn't find anything similar. I'm going to write sql because I don't think there is any other option. I will be grateful for the sql pieces :) Regards

(...) Hello community, I am trying to color whole ITEM list rows with sql query. I followed, the article https://community.webcon.com/posts/post/coloring-the-background-of-the-item-list/195/3 but even the simplest sql query (same than in article) generates the error (see figures enclosed). Any idea what I am doing wrong? Any example of your working sql query for ITEM list coloring? Thank you.

(...) ttribute will be seen in Task Workflow to edit. To the first point, I've tried to add action on ending path in Task Workflow to update related workflow instances, but I don't see Item list. Maybe sql ?? But I don't know how to write it... Thanks for help.

(...) exception has occurred while executing the request. | agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36 | href: | ex: System.Data.sql Types.sql TypeException: sql DateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."

(...) and assign it to the user, but unfortunately I don't know how to update the standard process from the dictionary process. Do any of you have an idea how I could do this? Or would that simply be an sql update command that I would then have to make on the field of the standard process? Thanks for your kind help in advance.

(...) Hello, Do you know how can i find what query is exactly executed when i'm using raports in WEBCON. What sql SELECT is inside, I knew that i can find it some where in the console(debug mode) F12, but I can't find it right now. Or there is some database table with this ?

(...) Hi all! I am currently struggling with 'Add privileges' action. I want to use a predefined datasource (sql query based on WFElements), this is shown under (1) in attached picture. The datasource I am using selects all elements from a specific formtype and needs additional filtering in sql query window (2). But I am unable to do that, every attempt so far resulted in syntax error. I am (...)