(...) Hi, I used in data sources " Current BPS database s" in field type choicefield clause IF. It's was worked until did upgrade at last verison 2022. After upgrade, When I select a value from field show id value not name value. Thank you, Raluca Lupu
(...) ly hits for the filename I got were in the Portal directory. Which is of no importance as the cyclical action is run by the Workflow Service. I also made sure that no other plugins in any content database used this file with another version. There was actually only this plugin which used the file SELECT [PLF_FullName] ,[PLF_Guid] ,[PLF_Extension] ,[PLF_PLPID] FROM [DEV01 (...)
(...) Hello, is there a possibility to use existing SOLR as Data Source? I had an idea to show users SQL grid, which would show similar items found in database , based on text typed in regular TextInput field. That lead me to Levenshtein Distance algorithm, which might be slow in SQL, but i've found that such a thing is already implemented in SOLR (https://stackoverflow.com/questions/1752301/how-to-configure (...)
(...) ery) and send these results to an external endpoint (REST service). The problem is that the query does not reflect current changes in form, since this happens on save. This should be related to database transaction and current values which are not persisted at this moment. Is there even a way to handle this scenario properly in Webcon? We have a dictionary process, so there is no way to play a (...)
(...) After upgrade to version 2022.1.4.174 I get errors on some querries that use . Error occurs when querying another database directly or using join, etc from SQL COMMAND or choose field querry. I found that this is related to change described in https://community.webcon.com/download/changelog/117?q=cf05b90, associated with using bps_user on SQL COMMANDS. Is there any way to deal with it at SQL server le (...)
(...) grate our on prem WebCon to our GCC High instances of O365. Currently working on the dev instance. I'm having issues just installing WebCon. Even on a clean box, I get the following error on "Content database Creation" I've tried, cleaning up the database s and users, and restarting the box and retrying install. Leads to the same error, I've installed WebCon a handful of times and never seen this partic (...)
(...) In our attempt to move to the cloud I need to update our webcon database to the latest version that supports GCC. I do not want to install this on prod and we don't have a proper dev env setup for this (Yet). To get the db upgraded, I am trying to migrate our existing prod WebCon instance, data and all to a new dev host (basically making a 1:1 prod:dev environment). Is there a "supported" method fo (...)
(...) rent 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. 2. Should the data source be a dedicated database table? In this case, I have to use the "Load by default" option in the directory to update the list of items with holiday limits if I want to see real data. Due to the SQL procedures used in holiday (...)
(...) I came across this problem. In the report we used a calculated column to show comments: (SELECT ISNULL (dbo.f_clear_description(wfelems.WFD_SIGNATURE), 'None')) However, from what I can see in database , the comment format has changed and now when using this function I get an error: "Invalid length parameter passed to the LEFT or SUBSTRING function." In the attachment, I marked in green old comme (...)
(...) 'webcon.sharepoint.core.wsp' Solution Deployment : Missing one or more of the following attributes from the root node in solution webcon.sharepoint.core.wsp: assembly '', type ''. The configuration database was queried for a non-existent object with the id d0d745af-6efd-429c-8072-59d3d392bba2. Most commonly, this is caused by removing an SPFeatureDefinition without writing upgrade code to remove refer (...)
(...) rnType, JsonSerializerOptions options) at WebCon.WorkFlow.Common.AAD.AadCloudsConfigurationDeserializer.Deserialize(String json) at WebCon.WorkFlow.Common.AAD.CacheAadConfigurationProvider.Getdatabase Configuration() at WebCon.WorkFlow.Common.AAD.AadConfigurationProviderBase.GetConfiguration() at WebCon.WorkFlow.Service.ADSynchronization.AdSyncConfigDownloader.GetConfiguration(IContentDatab (...)
(...) orm'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 field affect the behavior mode (...)
(...) le with a status of 0. I do not want all outstanding e-mail notifications to go out after changing the password. Is adding to the send queue based on the WFMails table, or is there another, dedicated database table for this purpose? UPDATE I have already found some important information: This queue is stored in the database in the WFMails table. Are messages with status 0 then retried?
(...) w with all (planned) attendances and (planned) absences must be created. For better visual differentiation, an extension of the standard colors "ColorID" is desirable. Is this easily possible via the database ? The types that _we_ need to distinguish, but it should be possible to create as many color definitions as you like. Types of attendance: * Office * Home office * Business trip * Further ed (...)
(...) ch a problem in version 2023? I don't know whether to look for the cause in the environment configuration or if it's a general problem. The problem occurs on different processes and different content database s. Thanks for any information.
(...) Is it for FREE? :) Yes, it is if you like SQLing :) Like we said WebCon BPS platform has got full history in the SQL and in history view (detailed one). Custom SQL taking data from WebCon BPS SQL database s can give you such SIMPLE overview on the form. It is also configurable - with subworkflows or not, which columns, etc. BUT basic version is about WHO clicked WHAT (and WHEN) in the process. What (...)
(...) view how it is done :) BPS 2023+ It would be perfect if such an overview could be added out-of-the-box (e.g. such dashboard) of the groups (at least the ones directly used which can be SQLed from database ) - alike in the kb article by Mr. Baszak :) https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3
(...) 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 Klaus
(...) rt a subworkflow (SQL)”. My understanding is that “start a subworkflow (SQL)” action (configuration of Data settings – Query returning data) works as follows: SELECT ‘value’ AS object of subworkflow (database field Name) etc. • How to write SQL query / where to get ‘value’ from Dictionary process? • How to set up Step edit/Task creation/Tasks assignment to use this ‘value’ to assignment subworkflows ( (...)
(...) Hello, I' m new in webcon and i try to fix issue connected with attachments. I don't know much about attachments database but as i saw there are two places where i can find data : [BPS_Content].dbo.WFDataAttachmets and [BPS_Content_Att].dbo.WFAttachmentFiles When im trying to add attachment like always going step by step in my workflow everything is ok - attachment is being added in both tables (...)