search results

(...) hi I have datetime type fields i.e From and To , i want to check in current db table (WFElements), if datetime exist or not between two dates validating on form submit path using sql query . Issue: all the time showing validation error message , My validation Sample below: select case when ( SELECT count(*) FROM [BPS_Content_Prod].[dbo].[WFElements] where wfd_attchoose1='{1189}' (...)

(...) Hello community. I wrote SQL query for On timeout – Insert condition (SQL). My query is returning true value, but action is not working. See figure for details. Any idea what could be the problem? Thank you.

(...) ropdown. I'm using js and global variables right now, but this doesn't work after saving the form with custom values - I'm lacking some control state info. (I've tried to achieve it with document.query Selector, but without luck).

(...) start subworkflows from (depending on field value) where this line of the item list is "copied" to the new workflow. Creating the WF item is easy, but the table stays empty. Is this a bug in my query or doesn't it work at all? Kind regards Klaus

(...) Hello community, I am trying to color whole ITEM list rows with SQL query . I followed, the article https://community.webcon.com/posts/post/coloring-the-background-of-the-item-list/195/3 but even the simplest SQL query (same than in article) generates the error (see figures enclosed). Any idea what I am doing wrong? Any example of your working SQL query for ITEM list coloring? Thank you.

(...) 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 su (...)

(...) . I have created a Report - "Equipment allocation" and I want to add a calculated column to this report that brings in the "Series" of the equipment from the Initialization process. I have this query : (select dbo.ClearWFElemAdv(WFD_AttChoose2)[which is the "Series" column in process (1)] from wfelements where wfd_dtypeid=102[which is the form id of process (1)] and wfd_id=3557) In my seco (...)

(...) 0' ... further conditions) vs (select Count(*) from WfElements childs join WFDocTypes on childs.WFD_DTYPEID = DTYPE_ID and DTYPE_GUID = '0000' where .... further conditions) I didn't test this query so it may be off and there could be syntax errors, but I think it's clear what I want to tell. Best regards, Daniel

(...) 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.

(...) '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 good (...)

(...) "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.

(...) ne know how to use the 'Edit a list element' action to update a document element in a SharePoint document library that is in a sub folder in the SharePoint document library? I am trying to use a CAML query and while I can find documents in the root document library, I can't get the CAML to find documents in a sub folder in the document library. I should mention that this appears to be WEBCON specific s (...)

(...) Hi! So I have this Item List in "Orders app". Lets say it has 10 columns. 6 Of those columns can be editable depending on subprocesses or other proceses. So there is a query , that if returns 1 it means that column can be edited by a user, if 0 then the column in this row is blocked. For that I am using "Column edit restrictions" from the "Permissions" tab in the studio. And it works great. For few r (...)

(...) Is there any way to hook into an api that is hosted on a localhost? I have a locally fired server, I use FastAPI (the tool is built in python). In browsers the API works. However, when I try to run a query on a form I get this message. I have already tried restarting DNS, disabling the firewall. The server is on startup and the server is listening on port 8000. I am new to webcon and just learning. Th (...)

(...) he problem appeared? Version installation: current -> 2023.1.3.76 target -> 2023.1.3.118 In changelogs there was information about changes as to the columns in the AdminWFEventLogs table. Last query from profiler: IF EXISTS(SELECT * FROM sys.columns WHERE Name = N'WEL_Details_Deprecated' AND Object_ID = Object_ID(N'dbo.[AdminWFEventLogs]')) BEGIN (...)

(...) f subfolders for attachments, depending on when they where added. As far as i understand, i will need to use the action 'Delete a list element'. I see that i can either give it an ID or use a CAML query (first time user here; just started reading about it). I most definetely need to use the CAML query since there can be more than one document that needs deleting but i am also curios about that ID. (...)

(...) g for the Subworkflow and there a Tab that should get the status. For that I created a Data table and put the technical field as the filter. And when I test this I get a huge error message from the query test. With that I think that I am either doing something increadibly wrong, or it will be a simple thing like a checkbox I am missing. Which of the 2 is it and how do I fix this? Thanks in adva (...)

(...) ExceptionServices.ExceptionDispatchInfo.Throw() bei System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) bei WebCon.WorkFlow.BusinessLogic.Helpers.Sqlquery Logger.d__10`1.MoveNext() --- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde --- bei System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() bei (...)

(...) Hello everyone, I have to generate a Choice Field based on a query that have an aditional filter. The filter should only allow entries that are higher than a Decimal Field in the Form. Somthing like in the Picture. But this did not work.... Has someone an Idea?