(...) D where [group].COS_DisplayName = '' AND [users].COS_IsActive = 1 AND [users].COS_AccountType = 1 Besides the Display Name you may want to use the AD name of the group. It can be found in table CacheORganizationStructure in column COS_AD_Name. 3.2) SQL query for second approval step in what the approvers of the first step shall not be assigned To be able to distinguish between tasks act (...)
(...) on I still have comunicate at workflow designer: "The database contains workflow instances associated with this step. You must delete those elements first in order to delete the step". On which SQL table I can find that archive elements? Any ideas how can I fix it? Thanks advance for your help.
(...) Hi, I have a following problem. I've created a data table form field that downloads data from SQL query. In that SQL query I have a following where clause, which compares a date from Oracle table to a date from a form field that is completed by an user (it is "user's date"): "where table 1.date = User's date: date acc. browser settings(text)" and it doesn't work because of different date format (...)
(...) Hi, I am trying to move multiple related child instances through an action. I tried doing that with the “Move workflow (SQL)” action. The query I used can be found in the Attachments. The table I get also looks fine, but I still get the Error "Incorrect column PATH_ID format". I already checked all of the IDs, they should all be fine. I used the following thread as a reference: https://alterpaths.c (...)
(...) Hello, just struggeling with setting up the REST API to create new elements from external app. It works fine in application context but I do not find a suitable guide on how to do this in user context. Do I have to enter the username and user e-mail-address in the mask as I assume? What is the "Authorized Redirect URIs" good for and where do I get this from? And: What is the main purpose o (...)
(...) Hi, it is posible to export data from item list to Excel in action but only id from column value? Only way i found is map item list to excel table (Sheet1!table 1). In this way the whole (id and name) of column is exported. But I want only id or name.
(...) s there an official listing of what is not allowed in SaaS? Because Building and Testing a project on-premise, and having no way of knowing if something will break on PROD because of that is not acceptable . Is there a way to test for it? Or at least have something to read through to workaround this from the start(dev), and not when it is deployed on live... Best regards, Fabian
(...) on on that, especially how to iterate over 'Any Collection' and access columns in custom action. If I select 'Any collection' and put some SQL statement in there, is there a way to access specific table columns from generated table result? If I take a look at the configured XML I only see {ANYCOLLVALUE} macro. Hope the question is clear enough, Thanks in advance, Nik
(...) Hi community! In some scenarios it is necessary for us to render datatable s on form containing some custom links or buttons. For this reason we built following SQL statement for testing purposes: SELECT 'Internal' AS ID, 'Click me' AS HTML UNION SELECT 'Azure' AS ID, 'Link' AS HTML And we used this datasource in a datatable field on form. However, we have some interesting results. (...)
(...) Hi @all, I´ve many processes they use the same rest-request to fill choice fields, table , etc. But the request requires a dynamic values in _url-parameter_ or _request-body_. At the moment i´ve to clone the *same* data source for every process... not nice ;-) ! A parameter would solve the problem - like as parameter into rules! Thanks and best regards Daniel
(...) all setups as requested and to leave the configuration sub dialog. When I wanted to save the entire process including the new configuration I received an error telling: There was an issue within the table storing the web service configuration caused by a value NULL. Testing around I found this work around: 1) Delete the web service action template you want to change. 2) Rebuild it from scratch. (...)
(...) Hi all! We want to add some rows to an item list with 'Change item lists values' action. The SQL query should take a JSON array (which is perfectly valid) from UI element and return a table for adding new rows to this item list. Unfortunately this does not work. There seems to be some parsing on Webcon side, which eliminates all elements in the JSON array, apart from the separator, which resul (...)
(...) that prevents any application from being exported: When the assistant analyzes the environment the following error message is delivered: see below Using the GUID given in the error message on the table 'dbo.translates' I receive one line with columns that seems to deliver the error. Sadly I am lacking information on the columns 'TRANS_ELEMID' and 'TRANS_OBJID' to furtherly investigate this issue. (...)
(...) Hello, During an export I get a process export error like below: Invalid reference tag occurences: Business rule (13551) - "Column "BasicDesignerXml" in table "WFBusinessRuleDefinitions" contains a variable referencing object "Form field" with an ID of 11805. Referenced object does not exist" The thing is I don't have any form field with ID 11805 and I don't use any business roles in that (...)
(...) ld make use of the existing functionality "column edit restriction". With this we could define whether the action should be displayed for this row like it is possible to define whether a cell is editable or not. Best regards, Daniel
(...) the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission was denied on the object 'table _name', database 'database_name', schema 'dbo'..." Using SSMS the server where the SQL is installed, I can SELECT the data from the table s. What could be wrong? Thank you in advance for your (...)
(...) Hello, here is a question that I have not found suitable hints so far. As our customer is sort of in a hurry, I want to place this question here: Can a multi-factor-authentication be used with the Mobile App for WEBCON BPS? The customer uses AAD for authentication and I would assume that setting MFA there would invoke the app to ask for the 2nd factor if the password was saved. But this doe (...)
(...) added into a multiple lines text field containing already information, i.e. a question asked. The text field is in rich mode. 3) Question I would retrieve the email content from the attachments table and add this to the text file. Does this work similar to a picture or do I have to do another approach? Thank you for your help in advance. Best, Ingo
(...) Hello all, I have a process that would require the automatic start of workflows in webcon. The format of the email content is text and a table however I can change it to be fields only. I have everything set up but I'm only able to copy the content into a text field but I need to have the information as an item list. Does anyone tried to do this? How can you pick up the text field and work it (...)
(...) ttachmentsController.StartAttachmentUpload(StartAttachmentUploadParams startParams) at lambda_method4700(Closure , Object ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.Awaitable ObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoke (...)