WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > User profile Jacek Wojnar > Forum messages

Jacek Wojnar

User

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)?

Designer issues
11.06.2024 10:14

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

Attribute - view items
06.06.2024 10:30

Hi, please try: dbo.ClearWFElemADV() Regards

BPS groups
06.06.2024 08:47

Hi Kuba, as far as I know - no :/ Regards

Attribute - view items
05.06.2024 17:35

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

Hi Jan, You have two choices: 1. Use SQL and check fields WFD_HistorySteps or WFD_HistoryPaths (storing previous steps/paths) 2. It may be easier to use the option "Back to the previous step" (screen)

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.