search results

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

(...) Hello. Is it generally impossible to use the above action type to create a new workflow item with a "filled" item list or do I have a mistake in my doing? I have a table (item list) where I want to start subworkflows from (depending on field value) where this line of the item list is "copied" to the new workflow. Creating the WF item is easy, but the table stays empty. Is this a bug in my qu (...)

(...) like that the system would allow choosing various options and populating the item list with the information. I know I can accomplish this with a choice field and then showing the details on a data table view. Thanks

(...) . Business wants to perform the following scenario. Batch of barcode lables from paper documents are to be scanned with hendheld scanner. Each scanned id is to be inserted into ID column of item list table . Based on the ID some additiona data are to displayed in other columns. What I have already done is the form rule that ADDs NEW ROW every time the value of ID item list column is changed. It works o (...)

(...) 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 Guys I'm wondering if there is a better way to find out which user has completed a task in a specific step than what i'm currently doing looking to the WFHistoryElements table . In need this information to ensure that the user that has finished the task in "Author confirmation" step, cannot finish the task in the current step (review) so i can force a 4-eye principle even with active substituti (...)

(...) with Add privileges action) from certain workflow elements. Is there an easy (and maybe built-in way) to remove all these permissions without knowing the BPSId of these users? I know there is a table WFSecurities, which can be selected and filtered by WFD_ID, but maybe there is an easier way to do this. Didn't find anything, any help appreciated. Thanks in advance & best regards, Nik

(...) Hello, I have an template with a simple excel file that has a table named "table Excel". This table has 4 columns: DATE,CUSTOMER,VALUE,CURRENCY. In designer I created an item list with 4 colums that have the same name. When I map the columns in designer I use "Sheet1!table Excel" and on the right i drag the columns from the item list. Every time i run the action i get : Invalid cell name If i try (...)

(...) Hi everyone! I'll start with the app package import error message, then some details: System.Exception: Exception occurred while importing table WFDetailConfigs ---> System.InvalidOperationException: No item type: WFBusinessRuleDefinitions, id: 2752 at WebCon.WorkFlow.Base.ImportExport.Mapping.MappingList.GetBySourceId(Int32 id, DbNodeType dbNodeType) at WebCon.WorkFlow.Base.ImportExport.I (...)

(...) Hi everyone! I'll start with the app package import error message, then some details: System.Exception: Exception occurred while importing table WFDetailConfigs ---> System.InvalidOperationException: No item type: WFBusinessRuleDefinitions, id: 2752 at WebCon.WorkFlow.Base.ImportExport.Mapping.MappingList.GetBySourceId(Int32 id, DbNodeType dbNodeType) at WebCon.WorkFlow.Base.ImportExport.I (...)

(...) lo, I created a few BPS users and I found out that they are saved in BPS_Config instead of BPS_Content. From the Administration tab I activated license for some users, but I have no idea in what table I can see this information. I want to make a calculated column in a dictionary report where I can see witch user has license. So in what table I can find if a BPS user has license or not? Thank (...)

(...) view V_WFElements would not only contain the integer id but the GUID. I'm not sure whether using the view in a calculated column would be more performant or creating an own join, but only for one table . For example (select Count(*) from V_WfElements childs where childs.DTYPE_GUID = '0000' ... further conditions) vs (select Count(*) from WfElements childs join WFDocTypes on childs.WFD_DTYPEID = (...)

(...) I used to update this table and chagne wft_user and WFT_user name. But from the version 2023 i got Update or insert of view or function 'WFElementTasks' failed because it contains a derived or constant field. Is there any other way to udpate the column in wfelementtasks?

(...) rable e-mail through action. The action is simple and it worked until now (previous version 2023.1.1.89). When the action runs it returns an error "Can't send e-mail: Column 'mail' does not belong to table Results.". The field used in the action is named "Procedujacy" and is the type "User or group" with the data source . I am sure it worked before, what can be the problem here? EDIT: Seems that wh (...)

(...) Hi, When inserting an item list in a word template, the add-in asks for some columns configuration for the final table . Issue is that modifying "Display name" of a column of the item list is not visible in the final document, it is visible only in the template. The attachment document receives the original item list column name. The "Display name" set for an autogenerated column (like ID) work (...)

(...) Hi all, Is there any way to export data from Webcon to Excel WITHOUT column headings? Can't see such an option neither in export from data table attribute nor from the report. Can this be done in any way?

(...) It would be very helpful if excel generating action and data table attribute ability to save as excel could produce an Excel file with or without columns headers. This is sometimes useful, as some external applications accept only data in excel files and no headers.

(...) I have a process (start - finish) that creates an instance and remains in the "Finish" state. Here, I have the following form fields: "Quantity TOTAL" (Floating-point number) and "Quantity" (Data table ). In that data table , I have other instances from a different process, and in one column (Quantity Requested), I calculate the sum. How could I save that sum in Quantity TOTAL and have it consist (...)

(...) Cloud.Portal.Extensions.DebugInfo.DebugInfoMiddleware.Invoke(HttpContext context, IDebugInfoGetter debugInfoGetter, IPerformanceCounterFactory counterFactory, IFrontendTraceProvider formatter, IDefaultable DbInfoProvider defaultable DbInfoProvider, IUserCredentialsManager userCredentialsManager, IDebugInfoManager debugInfoManager, IHttpContext synchronizedHttpCtx) at WebCon.BPSCloud.Portal.Performanc (...)

(...) MyRunAsync(args); } public abstract Task MyRunAsync(RunCustomActionParams args); } Base config class: public abstract class MyCustomActionConfigBase : PluginConfiguration { [ConfigEditable Text(DisplayName = "BaseConfigValue")] public string BaseConfigValue { get; set; } } *** extending / 'productive' project / solution *** Custom plugin class: public class MyCustomAction (...)