Jacek Wojnar

Hi, it depends ;) if queries to different tables can return the same column names (using aliases) then YES. Just do UNION ALL and in WHERE give conditions specifying which tables are to be displayed. e.g. SELECT col1 as name, col2 as age FROM Table1 WHERE condition1 UNION ALL SELECT col3 as

Hi, you can achieve this by making a column of type "Data row" for example: SELECT {S:DET_ID} as DET_ID

Hi, sorry, I was not precise ;) In the query you need to map your Befahigungsanchweis column to ATT_ID if you can have multiple attachments you will probably need to use the splittotable function (but firstly I suggest checking on one attachment per row)

Hi, you don't have to do a join on the WFDataAttachments tables. Instead, return the column from the list of items in which you have the attachment (Befahigungsanchweis) Do you expect more than one attachment in one row?

Hi, it looks like the fields "_suma xxx " are text fields. If so (and it has to be) you need to convert them to a number (screen) But it would be better to make these fields as numeric ;)

Hi, I think that in this case it is best to: 1. when starting a new workflow remember the row ID 2. in the started element, on the start path add the action copy attachments from another workflow and using SQL, select only those attachments connected to a given row.

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