search results

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

(...) My database goes into "Recovery Pending" mode which causes a program HTTP error 502.5. Restarting the SQL Server service solves the problem, but this has happened several times, does anyone know why this is happening?

(...) I am looking for the solution regarding REPORTS. I want to restrict the reports in the way that authors can only see their own requests. I was trying to do it with SQL , but I failed, I saw suggestion that it can be restricted on the user priviliges for entire app level, but I can't find solution. Please help :D

(...) hin Webcon. Specifically, I am interested in understanding whether there is a possibility to visualize a document by providing a link that points to a document stored either on SharePoint or within a SQL Server database. My goal is to enable the automatic display of the associated document in preview mode when a user selects a record in the application. Has anyone had experience or insights into (...)

(...) ally applied filter of the vacation chart generating engine. The user should decide what dates spread the want in each of therse groups (history and plans) by forming an appropriate filtering the the SQL query. The vacation chart can be used for several other applications than just vacation. The currently applied filtering restricts these uses, really.

(...) and 'phone') to a table in the subworkflow with the item list update action. The table has columns ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an SQL query to put different WFD_AttText attributes into one DET_Att column and different Att_Choose values into one DET_Value column into the 'value' column, so that the 'email' and 'phone' attributes get (...)

(...) Hi, I've cases where one choose field updates another choose field. If the data source is not a SQL database this can take some time. Setting the first field takes about 1 second, (1) in the attachment. Getting picker search results 540ms Validate picker control 460ms The setting and validation of the target field (2) takes again 1700ms and another 390 ms for executing a form rule. Setting (...)