(...) Hello, I try to render values from a rich text editor (multiple lines of text; Mode: Rich) as a column of a table on a Word-Document. But after the Wordfile generation the formatting is lost. In the database the value is stored as: X2OTestBla Is it possible to generate the Wordfile with the given formatting? Thanks in advance. 1st Image: Value in the Rich-Text-Editor 2nd Image: Re (...)
(...) Hello, we use the actions "Convert word to PDF" and "Generate/Update a word file" and we assign the documents to a dynamic category. The category is not saved to the table WFDataAttachmets, the field (ATT_Attribute1) stays empty. in version 2021.1.4.55 it did work fine. Thank you! Balint
(...) Hi, how to set a filter in the data source for a data table so that search-filtering by date works. The usual filtering according to the scheme does not work: 1. "some date (iso or browser settings)" = "field in the data table with a date" (like attachment) 2. "some date (iso or browser settings)" like "field in the data table with a date"
(...) hello, I need to migrate local groups from production to dev environment, do you know database table or do you have sql that will show me all local grups, even empty one ? thanks in advance.
(...) Hi! We have a business request to save email in instance we have just sent out with Webcon action. I know some workarounds: - show some details from wfmails table - create hotmailbox and process cc-d email But I do not like them. I have not tried, but maybe with msgraph api it is solvable. Does anyone have a good solution to save sent email in msg/eml file as attachment? Thanks! BR Pete (...)
(...) I have a problem with a report (simple display of a table with objects) for a process into which about 150,000 objects have been imported using the API. After opening the report, a long loading bar appears and then the message "Failed with unknown exception" and to check the calculated columns. There are no calculated columns in the report. There are no such problems for the previous case of 20,000 lo (...)
(...) the Aspose library which supports a template syntax. This allows to write code inside the word document to generate more sophisticated documents. Examples: - Instead of rendering item list/ data table s as table s in word we could generate "chapters" - Chapters could contain other chapters - Displaying multi line fields with rich text - Displaying pictures from attachments inside the document (...)
(...) me knowledge base articles where figures are not correctly displayed e.g. https://community.webcon.com/posts/post/the-picture-form-field/32 https://community.webcon.com/posts/post/wfelementdetails-table -description/34 and more. Could you please correct it? I tried various browsers, the results have been the same.
(...) 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 = (...)