Jacek Wojnar

Hi, you can try adding in the filter field "Product category" condition "OR group = EMPTY"

Hi, here you have a very similar case: https://community.webcon.com/forum/thread/6080

Hi, maybe this is a stupid question but do you have the Domain/Organizational unit filled in? And did you reload the configuration of services afterwards?

Hi, you can achieve this by using the default value and filling it from the last document of the same author (last seems better than first because some data may have changed over time). Below is an example query that returns the email from the last document of the same type, same author. The se

Hi Wojtek, in your case you should indicate in the mapping the list (not specific columns)

Hi, if you want to add break line to the word document (and you concat two fields) you can use "Data row" and add CHAR(10) between your fields

If you want to check if exists the same fullname in the form of the same type, you can use bellow SQL. xxxx is the ID of the FullName field SELECT CASE WHEN NOT EXISTS ( SELECT 1 FROM WFElements WHERE WFD_DTYPEID = {DTYPE_ID} AND WFD_ID != {WFD_ID} AND {WFCONCOL:xxxx} = '{xxxx

Hi, attributes can be set horizontally inside a group. If you add an attribute UNDER the group in the tab, you should be able to achieve what you are talking about.

hello, you can achieve this by changing styles to "Global CSS styles" example in attachment

Hi, the first problem is that you have some numbers as ID in the 'Odpowiedzialny' field (I would expect logins or BPS_ID here ;))? what do these numbers mean and where do you have the logins of these users?

hi, you can use standard functionalities and import Excel to Item list and based on the list start workflows with the action "Start a subworkflow (SQL)"

Hi, you can replace this "COS_BpsID = SUBSTRING('{S:642}', 1, CHARINDEX('#', '{S:642}') - 1)" with this "COS_BpsID IN (SELECT dbo.ClearWFElemID(item) from dbo.SplitToTable('{S:642}',';'))" this will support multiple values ​​in your column and you won't need to use SUBSTRING

Hi, you can use a Data Row type field and check the "Indicator field" option. If the query returns 2 it will be green, if 0 it will be red. https://docs.webcon.com/docs/2023R2/Studio/Process/Attribute/DataPres/SelectField In the "WHEN" condition (marked on the screen) you can check if a full

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.