WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for sql

(...) exception has occurred while executing the request. | agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36 | href: | ex: System.Data.sql Types.sql TypeException: sql DateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."

(...) and assign it to the user, but unfortunately I don't know how to update the standard process from the dictionary process. Do any of you have an idea how I could do this? Or would that simply be an sql update command that I would then have to make on the field of the standard process? Thanks for your kind help in advance.

(...) Hello, Do you know how can i find what query is exactly executed when i'm using raports in WEBCON. What sql SELECT is inside, I knew that i can find it some where in the console(debug mode) F12, but I can't find it right now. Or there is some database table with this ?

(...) Hi all! I am currently struggling with 'Add privileges' action. I want to use a predefined datasource (sql query based on WFElements), this is shown under (1) in attached picture. The datasource I am using selects all elements from a specific formtype and needs additional filtering in sql query window (2). But I am unable to do that, every attempt so far resulted in syntax error. I am (...)

(...) My database goes into "Recovery Pending" mode which causes a program HTTP error 502.5. Restarting the sql Server service solves the problem, but this has happened several times, does anyone know why this is happening?

(...) I am looking for the solution regarding REPORTS. I want to restrict the reports in the way that authors can only see their own requests. I was trying to do it with sql , but I failed, I saw suggestion that it can be restricted on the user priviliges for entire app level, but I can't find solution. Please help :D

(...) hin Webcon. Specifically, I am interested in understanding whether there is a possibility to visualize a document by providing a link that points to a document stored either on SharePoint or within a sql Server database. My goal is to enable the automatic display of the associated document in preview mode when a user selects a record in the application. Has anyone had experience or insights into (...)

(...) ally applied filter of the vacation chart generating engine. The user should decide what dates spread the want in each of therse groups (history and plans) by forming an appropriate filtering the the sql query. The vacation chart can be used for several other applications than just vacation. The currently applied filtering restricts these uses, really.

(...) and 'phone') to a table in the subworkflow with the item list update action. The table has columns ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an sql query to put different WFD_AttText attributes into one DET_Att column and different Att_Choose values into one DET_Value column into the 'value' column, so that the 'email' and 'phone' attributes get (...)

(...) Hi, I've cases where one choose field updates another choose field. If the data source is not a sql database this can take some time. Setting the first field takes about 1 second, (1) in the attachment. Getting picker search results 540ms Validate picker control 460ms The setting and validation of the target field (2) takes again 1700ms and another 390 ms for executing a form rule. Setting (...)

(...) Is there any way to compare the Production and Test environments? To compare the configurations of the same process between systems? In order to track changes. Do you have any sql , etc.? Do you use github or something else?

(...) io reports that the connection is in use. The usage sheet reports that the connection is not in use. I found where it is used... I searched in studio and indeed the 'Workflow' connection was used in sql command.

(...) the "Update Item List Values" action, so I used a workaround: "Clear Item List" + "Update Item List Values" / Add new rows from the data source. Do you also have such a problem? However, using the sql query instead of the BPS source and filter works fine. My BPS version: 2023.1.3.76 Regards D.

(...) report based on these 2 columns. It is working fine, until Assignee/Manager is multiple value. If there are 2 persons assigned, it doesn't bring that instance in the report. This is my formula (sql filter): and (WFD_AttChoose1 like trim('##currentloginname## ' )+'#%' OR WFD_AttChoose6  like trim('##currentloginname## ' )+'#%') Do you have any tips? T (...)

(...) of a choose field from a data source throws and this causes an error, it's not easily possible to see the actual "request" which was used to get the data. There are ways around this: - In case of sql and you have access to the server you could activate the sql profiler - In case of rest/soap requests you could add an http interceptor which can be used as a proxy. If you don't have access to (...)

(...) eitung Produktion, Pfad: Ja) Concurrency Error Log Error code: 100 Einzelner Wert: Attributwert von "Symbol - Fehlerhafte Rezepturen" auf "" geändert. Concurrency Error bei System.Data.sql Client.sql Connection.OnError(sql Exception exception, Boolean breakConnection, Action`1 wrapCloseInAction) bei System.Data.sql Client.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj (...)

(...) if I have signature of flow "ZAM/2024/03/00188" then "The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction." if I do sql SELECT [ATT_ID] FROM [WFDataAttachmets] where ATT_WFDID='{2592}' and in test field is "20008" then I see in designer 4 attachments but in action from (menu button) -> error .. the same (...)

(...) Hello, We have set a working Oracle connection. There is a procedure with 2 params, one IN, another OUT. Running a Business Rule containing a sql Command against the Oracle connection: declare l_out NUMBER; begin ZZ_WEBCON_TEST.TEST_PROCEDURE(P_IN => {BRP:21}, X_OUT => l_out); end; where {BRP:21} is a Business Rule decimal parameter. The Rule is working, Oracle procedure gets executed (...)

(...) /copy-attachment-to-other-workflow and https://community.webcon.com/forum/thread/3240 [quote="Daniel"] you using the function would be one option. Other are: - Set the local parameter using an sql command - Use the for each function to iterate through the attachments - Use the for each function in combination with a data source - Use the for each function in combination with "any collection (...)

(...) Could be nice to add BB Code or other tags used in Forum or information what type of Tags can be used for me I would like to use: [code][/code] or [code="sql "][/code] using code wil help read code - see attachment [quote][/quote] or [quote="name"] [/quote] [B][/B] - bold [i][/i] - italic ect. then is nice to use FF plugin or type tags ...