search results

(...) R3 and above; author: Krystyna Gawryał   Introduction Version 2023 R3 introduced the ability to use the CONCAT function within the LIKE function to create advanced filter conditions on data sources. This is particularly applicable when configuring Choice fields, allowing the list of returned values to be limited to those required by the user. This article provides a description of th (...)

(...) Applies to version: 2023.1.3 and above   Introduction This article concerns the system data source <Users and Groups>  and its effect on the Person or group form field from 2023 R3 onwards. The system data source <Users and Groups> (distinguished by the triangle brackets) is meant to act as a filter on top of the list of synchronized users - used (...)

(...) al post has appeared on daniels-notes.de I've finished a new post about using Playwright with WEBCON BPS. As I needed to add support for more field types, I didn't want to define the test data for each step and field type on my own.  Therefore, I focused this time on generating the form data using the REST API. After all, we already have the workflow steps, field, and field matrix, (...)

(...) is easy for the global parameters, there are other artifacts where the sheer number of elements makes this hard. Therefore I described my approach to create this checklist using the configuration data base table. In the end I considered the following artifacts: BPS Groups: Need to be transferred. User profile and favorites: Can be ignored. Registered API applications: Need to be transfer (...)

(...) External content by Maksymilian Stachowiak Starting Webcon journey usually begins with moving some data from other places, let it be SQL data bases, but when more applications are created you still might need this knowledge to migrate further processes. In this series I'm creating an example application into which I'm importing data using built in cyclic actions, and external powershell scr (...)

(...) Hi everyone, is someone here how understands power query? I got a task to retrieve data from a BPS report in excel to use it for additional analysis. I was able to retrieve the data but transforming the json response to a table is beyond me. Just in case there's someone who would be able to do it but doesn't know how to retrieve the data I add the logic below which can be put into the advanced edit (...)

(...) Does anyone know if it's possible to show data not present in an application on the report? I have read the article about calculated columns (https://community.webcon.com/posts/post/using-calculated-columns/196/3) but that's not my case. What I would like to do is join the items from the report to a table in a different data base (on the same server) or to an existing MSSQL data source. In many proce (...)

(...) Hello everyone, did someone update the data base compatibility level from the default 'SQL Server 2008 (100)' to a newer one and can share their experience? I really would like to make use of those "new" functions instead of using hard to read workarounds. Best regards, Daniel

(...) Hi all! I am new to WebCon BPS. I wonder if it is possible to get all items of a process or a data source/dictionary defined in BPS from client side via REST API. In SharePoint I did something like this: _api/web/lists/getbytitle('MyList')/items?select=Title... This does not seem to be possible with BPS REST API or at least I did not find it ;-) I am thankful for every hint pushing me into the ri (...)

(...) During the latest webinar Mike mentioned the GitHub Tool for bulk data loading. Does anyone know where I can get it? I didn't find it on the WEBCON-BPS page on GitHub. Thank you in advance for your answers.

(...) I haven't found any documentation how to access the current form data . What I know is, that all the formdata is kept in a json property called liteDate.liteModel as a json-object as you can see when calling /api/nav/db/{dbId}/app/{appId}/element/{wfdid}/desktop I guess that this liteModel must be available via javascript. I'm wondering, because there is this form from the offical 2021 release pap (...)

(...) When adding or updating elements via Rest Api, for picker fields it is required to provide Id and name. Quite often the name is known, but not the id. As picker fields are usually based on data sources, it would by great, when the api would be extended with methods to query data sources. There should be at least two methods: 1) getting a list of all available data sources (overall / by application) 2 (...)

(...) Hi all, i hope you are well. We have moved our PROD-Environments data bases to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old data bases are offline. Currently there is still an alias configured, that routes t (...)

(...) We are implementing a solution of Master data Management and are trying to use Webcon as a User interface with all the logic behind forms. The data base is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from table (...)

(...) ul 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 data source that should work for all workflows and translations. Values are shown depending on the users browser language. It simply shows which step was left with which path, by which user, at what time (...)

(...) Hello Gurus I'm trying to do such action: In my VS solution, I have made CustomAction that gets data from an external system as a list. I would like to return that list to ItemsList in my workflow. I have code like this: [ConfigEditableFormFieldID(DisplayName = "Pozycje nagłówka ", FormFieldTypes = WorkFlow.SDK.Objects.Enums.FormFieldTypes.ItemsList)] public List Lista_Poz { get; set; } publ (...)

(...) Hello everyone, before you install/upgrade BPS check the default schema of the data base user under which the installation/upgrade will be executed. Make sure that the default schema is dbo. If this is a different schema new objects may be created using this schema. This may lead to unexpected errors later on which will be hard to debug. Here's a little script to change it. SELECT name AS [Name], (...)

(...) Currently selection attributes, such as picker, poll the data base in such a way that LIKEs are always placed in the WHERE clause. The data that the data base returns are then filtered according to the picker configuration (exact match, contains phrase, starts with). In my company, we collect customer data from several CRM systems. For one of them, we have the customer's data materialized in the dict (...)

(...) Is it possible to loop over all rows of an excel file? I have an excel file with employees information(say 50 rows of employees). I want to navigate through each row, read and populate data in my form from excel columns and then trigger a workflow for each employee.

(...) Hi, I have noticed that you can create multiple content data bases on one Webcon installation. Why and how would you actually use that? It would be great if you could segregate the instances of different business entities in different data bases, but I am not sure that is possible. What else do you know about this subject of multiple content data bases on the same Webcon portal. Thanks, Razvan