Jacek Wojnar

Hi, here you have something that might help you: https://stackoverflow.com/questions/34794713/sql-datediff-without-weekends-and-public-holidays You need to make a form rule for changing the value (connect to both dates) and in it use a business rule that calculates the number of days.

Hi, you can subtract the "number of days between two dates" calculated using DATE DIFF, from the number of days off calculated with the query below: SELECT count(WODC_ID) as numberOfDays FROM WorkingDaysConfigurations WHERE WODC_Date >= start_data AND WODC_Date

Hi try to add an IF condition inside the rule and do: IF ( "Manager z AD" EMPTY ) THEN substring (...) ELSE EMPTY OR maybe change the condition (screen)

ok - I understand :-) it's just that using substring always carries a certain risk of incorrect data (that's all :-) ) In some ADs, for example, the user's DisplayName is made so that it is "Last Name, First Name" (with a comma in the middle). Then such a mechanism is not very reliable. If ther

"I'm afraid it gives me only users with license ... not all users in AD ..." ----- have you checked this? this should return ALL users - not just those with licenses. but if you really want to cut it out from the string (although in my opinion it's not very certain) try this from the screen

maybe this is a workaround ;) but you can always make a SQL data source with users. e.g. SELECT COS_BpsID, COS_DisplayName, COS_ManagerDisplayName FROM CacheOrganizationStructure WHERE COS_AccountType = 1

Hi, you can make a form rule (and put it in the "Style and behavior" -> "Form rule to be executed on value change") and use javascript to check the regex only if source != "External" https://www.w3schools.com/jsref/jsref_regexp_test.asp But obviously, this is only a js validation, so I wou

Hi Lena, you can try add style "visibility:hidden;" to hide cell and style "visibility:visible;" to show cell.

Hi Marcin, I just realized that you export these using the "Generate Excel file" action (I simply checked with the "export" button from the form). Did you try to force sorting in the initial query? I checked and it looks like WEBCON exports the rows with the action in the order they were added

Hi, I checked and when exporting to Excel it sorts according to this setting (screen)

Hi Mihai, I don't know if it's normal but I have the same behavior ;) Ad. 1 - it seems like a small bug, but the most important thing is that it works :-) Ad. 2 - In my opinion for a business rule it seems to make sense, because if you display it outside the foreach loop, the system has no contex

Hi, yes, it is possible. You can set it from the form configuration at a specific step

ok - sorry - I searched for something similar but I didn't find it ;)

I would like to propose a change to the Process Import/Configuration grid. It would be great if the names: Data sources, Fields, Constant etc. were in a separate column (if it were possible to sort/filter by this column it would be great :-) ). With many data sources, finding the one I don't wan

Hi, attached is an example of reading the name to the id from the fixed values ​​list. 1 - column with ID 2 - Data source ID 3 - column with ID#Name (from the fixed values ​​list) "item" is the column name returned by the "SplitToTable" function query: SELECT DET_Value1 ,(SELECT TOP 1

1. Fixed value list - you can read fixed value e.g. from a query like this " SELECT dbo.ClearWFElemId(item) as ItemID ,dbo.ClearWFElemId( dbo.ClearWFElem(item)) as ItemName ,dbo.ClearWFElem( dbo.ClearWFElem(item)) as ItemDescription from dbo.SplitToTable((select WFS_StaticValues ​​FROM [dbo]

ok - now I understand. What type of data source do you need to connect? fixed value list, BPS internal view or sql (or something else)? I think the easiest thing to do would be to add an INNER JOIN to your query and read the necessary values.

Hi, The question is, what do you want to achieve? Where do you want to connect the data source? You can connect the data source to e.g. sqlgrid or choose field and you don't have to write a separate query. https://docs.webcon.com/docs/2024R1/Studio/ConnectionsAndDataSource/DataSources/.

Hi, I had a similar case once. The cause was the use of {AP: xx} (with a space in the middle) in one of the hyperlinks. Interestingly, it worked correctly in the TEST environment, so I didn't notice that there was an incorrect tag. The problem was with importing to another environment. Proba

as what I checked, it can be calculated by summing the WFH_FormEditDurationToLeave column from the WFHistoryElements table.