Jacek Wojnar

this column stores information about how long the element was in a specific step

have you checked WFH_FormEditDurationToEnter or WFH_FormEditDurationToLeave ?

Hi, I don't know exactly what you need but the table WFHistoryElements contains who and when changed elements. Alternatively, the table WFElementCheckouts contains currently edited documents

it might be difficult without SQL :/ maybe the solution is (if possible) to set some flag (technical field) on the documents you display, so that the last one is marked as active or alternatively, you can use advanced filtering and try to search for the last elements there (but then you would ha

Hi, in my opinion using SQL data source (with TOP) would be easier in this situation. Where do you want to use such filtering (what business case)? Does the filtering depend on the current item or can you do it globally in the data source? In the business rules you can indicate whether it sho

Hi, what kind of error do you have? and do you have a SDK license? Regards

ok. In this case, I think there are two options: 1. List of items BUT rows would have to be updated by child flows OR you can use SQL row columns which always show current data 2. SQL grid - always shows current data. I think the second option is a better solution. I don't know how many colum

Hi, you can try using SQL: select cast(N'xxxx' as varchar(max)) collate SQL_Latin1_General_Cp1251_CS_AS

Hi, yes, using Data Table (SQLGrid) can be a workaround but in my opinion this behavior is correct - because the user (especially if he doesn't have edit rights) shouldn't see data that isn't actually saved on the form (those rows aren't in the database)

Hi, I checked both conditions: "SELECT 0" and "SELECT WFD_ID FROM WFElements WHERE 1=0" for both new timeouts are no longer created when entering a step. Of course adding a condition does not affect previously created timeouts. However, going through the path (exiting and entering the same

Hi, first check the WFConfigurations table but in the TEST database. In the WFCON_ID column look for these unfound IDs. Then you will see what attributes are involved. Check their configuration, in particular the tabs: "Style and behavior", "Visibility" and "Editability and requiredness". FLD

Hi, About Idea 2 - I think it's enough to use SplitToTable() in this case. example: SELECT item as ATT_ID FROM dbo.SplitToTable(>> column with ATT_IDs

sorry but I don't understand. If you add such a condition then simply the timeout will not be added to new documents - that's all. Why would it kill the whole process?

Hi, I think the easiest way to do this is with the "change items list values" action. Example in the attachment

Hi, here you have some information about diagnostic mode: https://community.webcon.com/posts/post/diagnostics-and-form-behavior-registration-mechanism/215/40

Hi, as far as i know you can't change the order of the standard menu buttons (but it should be possible to do it using js)

Hi, I think (like Daniel), that it would be easier to do it with a SQL condition in the first query. You can add the condition AND EXISTS ( SELECT 1 FROM CacheOrganizationStructure WHERE COS_AD_givenname like '%%' AND COS_AD_sn like '%%' )

Hi, have you tried just adding the condition "SELECT 0"

ok - now I understand. you would like a larger (multi-line) window to enter the message :-) Yes, that would be a good change.

Hi, I haven't tested it, but it looks like it should work from version 2023.1.3.202 --- edit --- Sorry - I just read that it's about the description of the path and not the step :/ sorry for the confusion - but maybe WEBCON fixed that too ;)