(...) 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.Extensions (...)
(...) Hi all, I was wondering what the best practice is when using SQL queries in Webcon with attributes, table s or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This mean (...)
(...) I recently noticed a problem with sending emails from my environment. The most likely cause was the wrong password for the application pool account. I see a lot of entries in the WFMails table 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 (...)
(...) CriterionFactory.GetAutomationCriterion(Automation automation) at WebCon.WorkFlow.Studio.Logic.Helpers.UsageSearch.NodeCriterion.NodeOwnerCriterionFactory.GetOwnerCriterion(DbNodeType type, IExportable Entity entity) at WebCon.WorkFlow.Studio.Logic.Helpers.UsageSearch.BranchGenerator.CreateMissingBranch(DbNodeCriterion criterion, String columnInfo) at WebCon.WorkFlow.Studio.Logic.Helpers.Usa (...)
(...) ntry vs national holidays in the country? Like having the calendars for Portugal Holidays, Spain, etc I know that we have to manually insert the holidays in the System configuration for calendar's table but in this case, the idea is, if I'm abroad and inserting extra hours, by defining where I am, the system could check if it's an holiday or not. Thanks!
(...) Hello, I have a short question. I want to generate an Excel file with my data from the BPS datasource. I created an Excel template with a worksheet(test) and a table (mytable ) and a action create excel. I write the assignment like this: test!mytable and my data to the right cell. But I always get an error. (Invalid cell name) If I just want one data set and just write the cell names for each l (...)
(...) Hi everyone, I wanted to ask if anyone knows where or in which table the "Fixed values list" are stored. I am using a "Start a subworkflow (SQL)" to migrate data from our old sharepoint workflow tool to Webcon. Unfortunately, it seems that Webcon has decided that 'Choice fields' always require a GUID#Name to be populated. (Without this format I get an error and the subworkflow does not run). N (...)
(...) 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 table s. It is purely for reading data. Kind regards Klaus
(...) Hi everyone, I've been working on a "to do" app and I thought that a calendar report view showing the tasks to be dane with their date would be perfect. In the calculated columns of my standard table report I have a calculated column with a red square for an overdue task and green for all the "to be done n the future" ones. Works great. I created the same for the calendar report and there is a problem (...)
(...) ataAttachmets 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 table s. But i also have a button making me back to previous step ( i am using Start Element()) and then when i try to add attachment it is going to be added only in table [BPS_Content].dbo.WFDataAttachme (...)
(...) Hi, in an Azure Active Directory environment it would be great to add an option to the people field which would configure it, whether external /guest users are selectable at all. Default value should be false. A customer worked around this by limiting the selection to a BPS group and adding AAD Groups as members of the group. No external user was a member of the AAD group. Technically this w (...)
(...) ike 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 using SQOL queries? Thank you!
(...) 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.