(...) S. I would like to have at least the last modifying users migrated as well. How could i achieve this? Was thinking about setting a technical field to the last modifying user and then doing an SQL Update on the element after migration. Sure this is not the way that is officially supported. But is there another way?
(...) Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database 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 Country) and 'City' So in City (...)
(...) NS_ELEMID and TRANS_OBJID = 9 and trans_lanid = (select TOP 1 LAN_ID from TranslateLanguages where substring(LAN_Name,0,2) = substring('{USERLAN}',0,2) )),'') as path, CASE WHEN WFH_LeaveCurrentStepdate is null then '' Else convert(varchar(20),WFH_LeaveCurrentStepdate ,113) END as Left_Step_at, TRans_name, STP_TypeId, WFH_LeaveCurrentStepdate , 1 as SortCategory FROM WFHistoryElements left outer joi (...)
(...) process for the RH where for the different subsidiaries there are different documents and salary benefits for the new admission. The point is when the subsidiary is selected, the form should be update d with the list of documents needed and send them in a notification for the new candidate . There are some issues with this, I'm not able to initialize the item list with the dictionary details (onl (...)
(...) Dear all, what would be the best practice to update /change the Business Entity of an instance? Background: I would like to create an application containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggling (...)
(...) Message Log for my Action Message Address of a Sharepoint list: https://visionboxdomain.sharepoint.com/sites/customers/Lists/Calendar Inserting values: Title: Renovation Doc, Location: PT, Eventdate : 3/12/2021 12:00 AM, Enddate : 3/14/2021 12:00 AM, Description: Renovation of doc, fAllDayEvent: , EventType: renovation, MasterSeriesItemID: , Workspace: Log Version: 3 Duration: 729 ms (...)
(...) all, I'm taking some time to explore the possibilities of Sharepoint and Webcon. I have a process set up to approve internal documents and they need to be renewed after 1 year from the previous date . I was trying to set up the beginning of the process in the Library List (and in the future use the renewal date do display the Start Workflow option for the line) and took the example of https: (...)
(...) query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing I'm trying to this but it's not working. Hope anyone has ideas for th (...)
(...) o unexpected errors later on which will be hard to debug. Here's a little script to change it. SELECT name AS [Name], SCHEMA_NAME(schema_id) AS schema_name, type_desc, create_date , modify_date , 'Alter schema dbo transfer ['+SCHEMA_NAME(schema_id) +'].'+name from sys.objects where SCHEMA_NAME(schema_id) not in ('dbo','sys') I did this in two steps so that I can ver (...)
(...) stead of null. This may lead to empty Step and Form Type columns in reports and other objects using internal views. If you are already affected by this you can decide whether to wait for a fix or update translates table. update [Translates] set TRANS_Name = null where TRANS_Name = '' I created a support ticket for this. Edit: This will be fixed with an upcoming version. Best regards, Daniel
(...) Hello, I would like to prevent users entering duplicate values in item list. The solution on KB is out of date and doesn't work. How do I prevent the user to enter a value that already use in the item list ? Thank you.
(...) r" for getting the latest check-in data. Our problem now is, that the smallest interval (1min) is still to long, the maximum value good enough would be 30 sec, otherwise the guest has to click the update button in most of the times cause of the long waiting-time. It would be great, if you could add 30 sec. to the available values next time or even better: just an empty field for personal configurati (...)
(...) e is also used as an execution condition. This could work, but this is kind a ugly. I would hate it to have multiple actions for the same thing. It's only a matter of time until the other's aren't update d/errors are fixed in the one but not in the other. Is there any other optoin/idea? Best regards, Daniel
(...) step are no longer working. I have multiple cases in my company where I need to use a flow control step to evaluate if the subworkflow should start or not and it stopped working after I got the update . I don't know how to fix it or come up with an workaround and I'm awaiting on the support. This happening for all control fields, even if there is no subworklow starting. Anyone is facing th (...)
(...) () at System.Windows.Forms.Control.SetVisibleCore(Boolean value) at DevExpress.XtraNavBar.NavBarGroup.SetControlContainerVisibility(Boolean visible) at DevExpress.XtraNavBar.NavBarGroup.Update ControlContainer(Rectangle clientBounds) at DevExpress.XtraNavBar.ViewInfo.NavBarViewInfo.Update GroupBounds() at DevExpress.XtraNavBar.ViewInfo.NavBarViewInfo.Calc(Rectangle bounds) at Dev (...)
(...) r even been available by the provided version of the 'Winnovative HTML to PDF Converter' engine. WEBCON BPS utilizes version 7, while the current version is 15. As far as I could find out version 7 date s back to 18 Feb 2012. https://winnovative-html-to-pdf-converter-applic.software.informer.com/versions/ Version 15 has been released on 28 Oct 2019 https://www.nuget.org/packages/wnvhtmlconvert/15.0. (...)
(...) Hello all, Does anyone configured a calculated column in the reports to calculate the difference between current date and a date field from the form? I was trying days (getdate () - form field) but it's not accepting the days formula. Thank you!
(...) be executed on registered account only. Valid PortalAppPoolIdentity username from database is empty. Source=WebCon.WorkFlow.Service StackTrace= at WebCon.WorkFlow.Service.WCFService.WCFService.Validate PortalAccount(Int32 dbId) at WebCon.WorkFlow.Service.WCFService.WCFService.PowerShellExec(String script, String login, String password) System.Exception: WCF Service can be executed on registered (...)
(...) Hi, we just update d on Friday to Version 2021.1.4.36. Just now a user called and showed me that she is getting an unknown exception error when trying to add an attachment to a manually created new instance. She has the rights to do so, and can add attachments as soon as the instance is manifested in the DB through save button that directs to the same step. So there is a known workaround, but it wo (...)
(...) Dear WebCon Team, we just update d to 2021.1.4.55 and recognized, that the so long working function "Attachments Count" does not work properly any longer on the intital step of a workflow as long there is no Instance ID. For Example I would like to validate if there is an attachment uploaded or not (see picture). If I do a path on the step itself --> Instance ID --> the rule works fine!!! I think it (...)