WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for data source

(...) connection string manually, this fails: The string for the log thing does use the old alias that I removed. (Begin Dump) C:\Program Files (x86)\WEBCON\WEBCON BPS Portal>webcon.bpscloud.portal -c "data source=;Initial Catalog=BPS_Config_19T;User ID=BPS_SQLUser;Password=xxx" URL: http://*:48439 ConnectionString: data source=;Initial Catalog=BPS_Config_19T;User ID=BPS_SQLUser;Password=xxx Logs Connection (...)

(...) Hello, I have the following scenario: - Webconapps - data sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database data source and chose the above connection, I get the following error: "Unknown error: The SELECT permission was denied (...)

(...) Not sure if firewall could be the root cause. Let me summarize once again + add some additional info: - It's Microsoft SQL Azure (RTM) - 12.0.2000.8 - Using SQL authentication - Webcon data sources > Connections > MSSQL database > inserted all connection parameters, click Test and get the "Connection succeeded" result. - SELECT statement works if using SSMS - SELECT statement doesn't work if using d (...)

(...) nted instead of putting Car Type (ID) = 1 - you have to create 'Constant' CarType Sedan with value 1 and so on. Structure like enum would make this easier, and more condensed - instead of having a data source, and constants (1 app, x app, or global) there could be the enum structure, which should have a possibility to be used as data source, and it's values as values in for example buisness rules. Any (...)

(...) Hi, I'm trying to update an existing instance or create a new instance with REST API. I'm using api version 3.0 and Postman. I want to put data to choice field, but I know only name from data source. It's possible at all? I tried to put a value in two ways: "formFields": [ { "guid": "c2e37260-5d57-410e-997c-1f19bb12a4c0", "svalue": "USD" (...)

(...) unambiguous match of the passed value. If the value of the field is 3#USD,you can put it in two ways - set value: "3" - then the id will be verified and the value 3#USD will be selected from the data source - set value "3#USD" - then the value will be searched in the data source and the given value of the name will be compared, e.g. for the value "3#PLN" will be a name mismatch error. If you don't h (...)

(...) My point is that any use of the data source Value will be problematic for the data source, which is the dictionary process (filter).

Has someone met the problem with "Giving privileges" action, after update to v. 2022.1.4.127? Action stopped matching user data on "DisplayName" (COS_DisplayName) or ID that is stored as BPSid (COS_BPSid). Finding user is now possible only by email address (COS_email). COS_BPSid and COS_email are not the same in my case. That seems to be a bug as the log of action suggests that data is searched fi

(...) Thank you. The problem was, that the query was as you said against BPS Users data source not against default data source. Now it's working.

(...) Hi everyone, for data sources you can define a common data source and add child sources for the parent "Superior source". These child sources can then be associated to business entities, which allow you to target different backend system for each business entity. If I haven't missed anything I don't have a similar option for the Connection themselves. This is fine as long as I can use the connection in (...)

(...) Hi, thanks for your answer. What are the possible consequences of changing the compatibility level? If I don't want to go upgrading the database, I need to create a new SQL data source in designer studio and write a complex query that i then use as a data source for a data table? How can I then add a data table onto a html template? The create pdf action doesn't seem to interpret the{SEL_SQLGrid} (...)

(...) Hi, is it possible to manage colors in the graphic - Gantt chart? My "holiday schedule" data source retrieves data from two processes (remote work at the initiative of the employee and occasional remote work). By inserting the source into the process, all elements are marked with the same color. I would like elements from two processes to be colored separately with a color of my choice.

(...) Hi everyone, does anyone has an idea, why a data source dictionary would not return all data, also "access data in the context of system account" is checked? I was banking my head on the wall, why the form validation stopped working until I noticed that the lastest workflow instances are not returned by the data source. The screenshot shows the data from the "data sources" navigation pane, it's not (...)

(...) Hello, in the "Absences" application I have two processes: Employee file, Holiday request. I wanted to ask you, how do you organize data sources for such a process? 1. Should the source of data be an employee's file with a list of items that reflects holiday leave limits? In this case, each submitted application should update the parent workflow (Employee file), but I am afraid that over time the fi (...)

At Webcon BPS, on the form's list of items, I have a checkbox field and a second field of dropdown(choose) type. The second filed - dropdown field retrieves data from a data base and allows for adding values outside of the database. The first filed - checkbox field determines whether the value in the second field is from the source or added externally. How can changing the value of the checkbox

(...) Hi Marcin, the behavior /configuration itself wouldn't be changed but you could add a condition to the data source like where IsExternal = 0 This way the data source would not return any values if "is external" is checked. Best regards, Daniel

Hi all, I was wondering what the best practice is when using SQL queries in Webcon with attributes, tables or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This

(...) which requires an order by. 2. As far as I remember, the SQL server can improve the performance for executed views. If neither of the options above are required, I would either use MSSQL database data source or just write the query where it is used. In one attachment you see the "conversion" of a generated process view to a MSSQL database data source. It just occurred to me, that you may talk about di (...)

(...) ad the data to an item list via import from Excel and start workflows for each row. Maybe with an invisible path to move the workflow directly to the final step. 2. If the data is accessible using a data source, you could use this instead of the item list approach. It could also be an option, to create an own database, where you store the necessary data and use this one. Best regards, Daniel

(...) Hi, it would be great if the response tab of a data source would have an additional option to download the defined response structure so that it could be uploaded. This would be even better, when the internal names would be part of the download. There are cases when you need to change the internal names and doing this again and again for the superior source and x business entity sources is annoying. :) (...)