search results

(...) olding the items to be sold at the current transaction. These items can be added through standard adding elements (+) button. There is a choice box that opens a list of available items with important column s. You choose one or more items and closing the modal populates the items list with the chosen values. That's an obvious way. But, the obvious way is not really what I'm after. This is because the (...)

(...) (MSSQL database) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has not been initialized.. D (...)

(...) Hello everyone, I’m trying to set the color of the cell in a report based on a comparison between the current field (AttDateTime1) and another column (AttDateTe4). It works if I compare the CurrentField to a fixed value. As soon as I try with the other field name, it doesn’t work anymore. Is it even possible to have such comparison? Thank you, Martin

(...) ere was no "problem" with the following actions: Update attachment, SDK action, Change value of single field, notifications. 2. Saving report views I had to save each report view to show the new column . It was sufficient to click on the view and hit the save button. 3. Data source I had to remove the field, add it again and correct any usages, where the old column was used. 4. Copying value (...)

(...) s correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors occurred. Operacja została wycofana Concurrency Error Concurrency Error" In attachement you can see the (...)

(...) find optimizations here. Table / index compression is not a solution - compression ratio is barely reaches 0,5% level. I have found a lot of records in this database where attachments are deleted (column ATF_IsDeleted = 1). Is it safe to remove such records from database or it will make inconsistency of the data? Do you have any experience in it? Looking forward for any comments.

(...) igure, it is posible to retrive output value from SQL Procedure? How force "Run sql procedure" action to log ouptut to [dbo].[WFLogs] table? Write-Output in PowerShell is logged to LOG_Description column . How log ouput from sql procedure?

(...) bout SQL optimization. So I did this query on production environments of our 4 random clients. The query shows where probably we should be thinking about putting index, because of high usage of those column s. Of course we all know that putting index on WFElements with attribute column s is not a good idea (maybe if you have secondary BPS_Content for only 1 process could be fine), but there are some examp (...)

(...) ort excel tables only if you have a table container already added. Sometimes it is difficult if we want to process data in excel table coming from third party. Proposal: there is a way to define column mapping for itemlist file importing. It would be nice to have a feature in import action to take into account that one, instead of expecting a table in excel file. What do you think? Thank you! (...)

(...) Is it possible to sort by the selected column (additional column , e.g. priority) in the dictionary selection field? Or to arrange your own order?

(...) ' 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 actually finished by the approvers and t (...)

(...) r job, and i'll receive the document back in version 7 i want to be able to see all changes between version 1 and 7 (x, y). Instead of displaying incremental list of changes between, just show two column s with two chosen by user versions. I see it very usefull for huge forms, where tracking all the changes in each step takes more time. This way there could be a glance view about what changed, and (...)

(...) 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!Table1). In this way the whole (id and name) of column is exported. But I want only id or name.

(...) Hi all! We have to update some column s in a workflow dependent on other column s from the same workflow item, e.g. WFD_AttDecimal1 = WFD_AttDecimal2 * WFD_AttDecimal3. Sounds trivial, but it isn't, especially in a SaaS system, where 'Run an SQL procedure' is missing. Another approach for us was to use 'Update related workflow instance' action, but this approach obviously leads to nowhere (maybe (...)

(...) ator 'ForEach' is a great addition to version 2022.1.2.31, thanks to Webcon Team. Unfortunately I do not find any documentation on that, especially how to iterate over 'Any Collection' and access column s in custom action. If I select 'Any collection' and put some SQL statement in there, is there a way to access specific table column s from generated table result? If I take a look at the configu (...)

(...) Whenever I try to change the language of column "instance number", my report throws up this error "An item with the same key has already been added". How to fix this issue? Please suggest.

(...) s. We've found many cases where an "advanced search" mode would be extremely helpful. To achive this, the configuration section of the choice field, should be extended with an additional checkbox column "Advanced Search (PopUp)". If any field is checked in this section, the popup search window should behave in one of the following ways. 1. Showing an "Advanced Search" button, which would then to (...)

(...) Hi. Is there a way to query the Active Directory only for the department column and add this as a datasource. What I'm seaking is a list of all departments we have in the company. Kind regards Klaus

(...) nary items. On a start step I have the item list where I want to upload some rows from an excel file, then I want to check if uploadet rows exist in the dictionary. If exists, webcon should mark a column in the item list that the entry exists. Do you know how to achieve it? Could you help?

(...) It would be nice if you had the possibility to define the language in which a custom email is sent based on a form field or item list column . We have multiple applications where recipients of e-mails have to addressed in their own language regardless of the user language which is used in the form.