Data sources
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 working. I've added a screenshot. If I use the field manually, I'm able to get that specific lin (...)
Working on a project whereby there is a process to track delinquent loans and create collection activities based on ageing. We receive loan data as a daily dump in excel and new or modified rows should either fire new instances of our workflows or trigger certain paths in existing workflows.Unsure of how to go about this
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 file will have too many versions. On the other hand, I have change history and actual data. (...)
Hi all, at the moment we are struggling to generate C## classes automatically based on the SWAGGER JSON Definition of WebCon. (server-adress/api) It seems, that the inheritance could not be solved completely by the library. Our aim is to be able to read data in JSON format from the WebCon REST-API by using standardized tools, means no manually work for getting the data in the right format. Used REST instruction (v3.0) GET: Gets default bps view content Additional Information: - WebC (...)
Hi, I want used the global business rule in a rest web services. I try use de business rule in Customer Headers, but when I run the action the value it's empty. I added an image with the configuration. (config_restWebServices.png) Is it possible using the business rule in Data sources Rest Web Services? Thank you, Raluca
Hi. I have a big SQL from 3-4 apps. Is the possibility to generate report from my SQL data source ?
Hi community! In some scenarios it is necessary for us to render datatables on form containing some custom links or buttons. For this reason we built following SQL statement for testing purposes: SELECT 'Internal' AS ID, '<input type="checkbox">Click me</input>' AS HTML UNION SELECT 'Azure' AS ID, '<a href="https://somedomain.com" onclick="alert(''hello'')">Link</a>' AS HTML And we used this datasource in a datatable field on form. However, we have some interesting results. (...)
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 formats. I've tried multiple methods and nothing worked. Do you know any solution? However, the fo (...)
Is it possible to sort by the selected column (additional column, e.g. priority) in the dictionary selection field? Or to arrange your own order?
Hello, I tried to import some templates from DEV environment to TEST environment and when I uploaded the .zip archive the following error occured on the .xlsx report: "Value cannot be null. Parameter name: securityProvider" Does anyone know why do we get this error? Thanks!
Are there best practices how interaction with business central (formerly known as MS Dynamics NAV) can take place? What would be the preferred interface? I remember a communication with Webcon where comon data source was mentioned. Where are we here?
Hi all, I'm taking some time to explore the possibilities of Sharepoint and Webcon. I have a process set up to approve internal documents and they need to be renewed after 1 year from the previous date. I was trying to set up the beginning of the process in the Library List (and in the future use the renewal date do display the Start Workflow option for the line) and took the example of https://community.webcon.com/posts/post/starting-workflow-from-the-sharepoint-document-library/54 (...)
Hi all, i thought it might be a good idea to share useful queries that should be reusable for any of us as they are. Although I personally find the built in Workflow-History very useful and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource that should work for all workflows and translations. Values are shown depending on the users browser la (...)
After app migration between enviroments strange error occured which shows up every time existing instance is opened or new instance is started in all apps. Reverting back the previous version of the app did not solve the problem. Designer studio throws the error on clicking every item as well. Restarting server did not help. Has anyone came acress similar issue? Any ideas on how to find the source of the problem? What does the phrase Key: (311, 5116) refer to? Thanks in advance. Designer (...)
Hi, Does anyone know how to use the 'Edit a list element' action to update a document element in a SharePoint document library that is in a sub folder in the SharePoint document library? I am trying to use a CAML query and while I can find documents in the root document library, I can't get the CAML to find documents in a sub folder in the document library. I should mention that this appears to be WEBCON specific since the CAML query does return subfolder contents if I use a regular CAML query e (...)
Hi, We recently migrated Webcon to new servers on SharePoint 2019. Apparently, the configuration under Webcon BPS Configuration on each SharePoint site got lost (the database name etc.). 1. Is this behavior expected during migration? 2. Is it possible to set it globally or is it necessary to set it manually on each SharePoint site/subsite? 3. Are there any other such settings that might have gotten lost during migration? Thanks! Mark
Hello, Does anyone has a rest api configured to access Sales Force? I have a connection and I use it in a process but I'm getting the data from Opportunities. I would like to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data/v52.0/analytics/reportTypes/Opportunity But when I use the field as a Data table in order to check the information, the list comes empty. Anyone tried this? Do you know how to bring reports instead of (...)
Hi, We have an issue related to the usage of columns from a datasource (dictionary, BPS internal view) within a choicefield-type field. The user 'windows user' has created a new application, a new process, and a new dictionary. After configuring these, the user created the corresponding datasources for them. They created a new process where they associated the dictionary/process with choicefield-type fields. For data filtering, they used the fields from the datasources as filters. An (...)
Hi, Is there any tutorial about adding new values to the source using picker field? I have seen that there is that option but I have a problem with configuration of link to the object adding form.
Hi community! We implemented a document template with certain fields coming from a custom datarow (based on SQL-Query). We deployed the solution and the document template to PROD and everything was fine. After that we added one new field to the datarow (SQL query was modified) as a new requirement and added the new field also to document template. On DEV system everything looks fine, we deployed the solution to PROD and suddenly this new field is missing in Word Add-In (in the selection of d (...)
+48 12 443 13 90