Hi, I know it's a workaround but you can make a global constant :-)
ad 1. thanks - so there is hope :-) ad 2. I always have this problem when copying from the expression preview (1). When I copy from the editor it's OK (2)
Hi, I would have two ideas/requests (probably simple) regarding the SQL editor 1. The SQL query editor should have a monospace font 2. The SQL query after copying to SMSS/notepad has unnecessary newlines. Is it possible not to add newlines? regards
Is it possible that the window in Designer Studio for adding/edit user group has a flexible [Users] field and a locked [Group owners] field size. The opposite of now. There are usually more users than owners ;) Additionally it would be good if the users were also sorted alphabetically. Regard
To w takim razie możesz albo: - użyć akcji start podobiegu (i wskazać tam, że startowany obieg ma być niepowiązany z bieżącym obiegiem). - stworzyć URL, w którym w jednym z parametrów przekażesz WFD_ID obiegu źródłowego (do jakiegoś technicznego pola), i tam dodać akcję zmiany wartości wielu pól
Hi Pawel, I don't think I fully understood what you want to achieve, but for starters: 1. if you want to display attachments from another workflow, check what type of column you have selected (screen) 2. you should add the condition DET_WFCONID = {id of your item list} to the query
Cześć, pytanie czy: 1. chcesz od razu wystartować ten element (po kliknięciu ma być sygnatura)? 2. chcesz przekierować do formularza (nie zapisanego) ale z już uzupełnionym informacjami ? Jeśli 1 to wystarczy przekazać do nowego elementu WFD_ID elementu źródłowego i ustawić w URL od razu przej
Hi Paweł, It looks like a bug :/ I checked the 2023 version and it works OK You can do a workaround and check it with SQL e.g. SELECT COUNT(ATT_ID) FROM WFDataAttachmets WHERE ATT_WFDID = {WFD_ID} AND ATT_IsDeleted = 0
Hi Andreia, maybe this will help you: https://docs.webcon.com/docs/2023R3/Studio/Action/Signatures/
to wg mnie najłatwiej zrobić to za pomocą akcji zmień wartość pola i za pomocą SQL wyznaczać np. SELECT MAX(ISNULL(WFD_AttInt1,0)) + 1 FROM WFElements WHERE WFD_DTYPEID = [typ dokumentu]
Cześć, nie wiem czy dobrze rozumiem, ale czy wartość tego atrybutu to ma być ta sama wartość, która wynika z sygnatury (czyli tak jakby wycinek sygnatury)?
Hi Maria, Are you asking about Designer Studio or Desiger Desk? In Designer Studio, I sometimes have situations where the studio throws an error when saving (with different system versions). But I don't think I've ever had a situation where some of the changes were saved and some weren't. Re
może to pomoże: https://blog.sqlauthority.com/2019/06/03/sql-server-fix-msg-15274-access-to-the-remote-server-is-denied-because-the-current-security-context-is-not-trusted/
Dzień dobry, a jak jest zrealizowane połączenie do bazy ORACLE? bezpośrednio w Designer Studio przez żródło danych Oracle czy poprzez np. linked serwer z bazy MS SQL?
hi, in my opinion the easiest way is to make a SQLGrid presenting the data from the list (and set the sorting there) and use this grid to generate the docx Regards
Hi, please try: dbo.ClearWFElemADV() Regards
Hi Kuba, as far as I know - no :/ Regards
Hi Piotr, Do you want to insert a calculated column in the report? If yes, try this: (SELECT ISNULL(WFD_AttChoose5, STRING_AGG (CAST(DET_Att1 AS NVARCHAR(MAX)), ';')) FROM WFElementDetails WD WHERE WD.DET_WFDID = wfelems.WFD_ID) What type of error do you have?
there is a little difference ;) one userguid has "ó" but second has "o"
Hi Damian, interesting case ;) you can check privilages for this document. in the SQL SELECT * FROM WFSecurities WHERE SEC_WFDID = .... maybe you'll see some differences