(...) Dear Community, I just discovered that when I select SearchIndex as a source for calendar type report, elements are in different timezone than server time. When I change source to sql source everything is fine. Does anyone experience same issue? Best.
(...) Hello, It would by great to change Keyboard TAB button behavior in sql or js editor. I think TAB should make spacings for beautify code, not change focus to window buttons.
(...) vert the content of the attachment to Base64 (the business rule returns the text value of the last attachment). When the whole thing is handled by TimeOut, I get the error: Message=Error executing sql rule Create Attachment Base64 (Id: 3008) Source=WebCon.WorkFlow.Base StackTrace= at: Evaluation requested at: Evaluation node: AttachmentContentAsBase64 at: Evaluation node: GetAttachments [... (...)
(...) source be a dedicated database table? In this case, I have to use the "Load by default" option in the directory to update the list of items with holiday limits if I want to see real data. Due to the sql procedures used in holiday requests, I do not see the update file after a processed holiday request in the history. Which solution do you use for yourself?
(...) assigned person directly or the substitution person. I was able to get the assigned person directly from System fields, but I wasn't able to get the substitution person. How can I extract, without sql , the substitution person? Thank you, Raluca
(...) st object of type 'System.DBNull' to type 'System.String'. at WebCon.WorkFlow.Base.Managers.ElementCheckoutsRepository.UpdateOrTakeOverParameters.UpdateAfterUpdateTime(WFElementCheckout checkout, sql Command updateCommand) at WebCon.WorkFlow.Base.Managers.ElementCheckoutsRepository.UpdateTimeOnCheckoutWithStealing(Int32 wfdId, String userLogin, String userName, String hostIpAddress, Int32 expi (...)
(...) changes anyone encounters when testing the new version in a single thread. It won't take much of your time and will potentially save you more when others do the same. I will start with this one: sql command: Varriable WFCONCOL_ID : WFD_DTYPEID = {DT:12} and {WFCONCOL_ID:153} = {WFD_ID} has been "translated" to WFD_DTYPEID = 1 and dbo.ClearWFElemId(WFD_AttChoose1) = 2 and is now replaced (...)
(...) Hi community! We have 2 choice fields, first one is a dropdown (field1), second one has behaviour autocomplete (field2). Dependent on selection in field1, datasource of field2 (which is an sql query containing value of field1) changes. This is working as expected. Picker search mode of field2 is set to 'Contains', minimum characters = 3. Regardless of what is entered in field2, all availa (...)
(...) Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not wor (...)
(...) s columns of an item list. Would only be displayed for the test button of the expression editor. Currently it's also displayed for the "Show" buttons which forces me to replace the variable in the sql management studio myself. Best regards, Daniel
(...) Hi, Is there a set of rules, an instruction on how to directly (using insert-sql ) import data into the database (into the WFelements table)? Which field values should we generate so that there are no problems with the operation of the application. Of course, WFF_STPID - step ID, WFD_DTYPEDID - form ID depends on the process, and the rest, e.g. RowVersion (some hexadecimal value) ? And other?
(...) sage is displayed: "403 - Forbidden: Access is denied.\r\n You do not have permission to view this directory or page using the credentials that you supplied." I checked the security settings for sql LowPrivilegeUser. Has anyone encountered this error in a newly configured webcon environment? 04.07.2023 Closing. The error was caused by an IIS setting. IP Address and Domain Restriction (...)
(...) Hi all! Is there any official (or unofficial) documentation on Webcon designer studio parameters, like --sql or --iedebug? Is there an other way to logout from designer studio, without havin designer studio started? The problem is, studio does not start anymore and I want to try a different Url or browser login, but I am not able to change this. Best regards, Nik
(...) Hi all, I need to schedule a daily email (let say like an email from a sql job), but I didn't find how to do it. It is a possible to do that from WEBCON? Many thanks, Ovidiu
(...) Hi everyone, I wanted to ask if anyone knows where or in which table the "Fixed values list" are stored. I am using a "Start a subworkflow (sql )" to migrate data from our old sharepoint workflow tool to Webcon. Unfortunately, it seems that Webcon has decided that 'Choice fields' always require a GUID#Name to be populated. (Without this format I get an error and the subworkflow does not run). (...)
(...) Hi, I have a problem with the execution of sql queries in different environments using a Default connection (after moving the system to AZUR-e servers). sql Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parame (...)
(...) pecific Application. We can dig into the BPS Studio and check Application, Process, Worfklow, Document Types permissions. We can check actions, business rules, etc. We can try to do it better via sql or/and WebCon BPS Application. It is well described here: https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3 Sometimes we need to use groups which are cross Application (...)
(...) Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS sql ) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS sql , too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Kl (...)
(...) reate report that will be showing all instances , which current logged user had task to do in the past. Some user can have more than one task in workflow. Is it possible to prepare such report and in sql filter make a join statement similiar to this: SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY [WFD_ID] ORDER BY WFD_ID DESC) rn FROM [BPS_ConfigProd_Content].[dbo].[WFElements] (...)
(...) Hello everyone In a process I run a cyclic action in the Global Actions. This action contains a "Start a subworkflow (sql )". When the subworkflow action is executed I just get the message 'Incorrect syntax near '}'.' in the *Last error* field. As seen on the screenshot There is no '}' in the sql query of the subworkflow action... So now I am facing the mystery where exactly this error occurs (...)