search results

(...) Hello, it would be nice to have an option of inserting a "CAML command" similarly as it is done with "sql command". It would help in setting conditions and checking the outputs of sharepoint actions.

(...) .com/posts/post/approval-process-on-the-item-list-with-row-blocking/138 in order to block rows. I've managed to give access to items list only users mentioned in one of the columns of item list using sql against BPS Users list (see picture attached) , but all rows are available to everyone from this column, not only one row per one user. What am I doing wrong?

(...) I've got following fields: 1. Choice field with connection to MS sql table - name of the supplier. 2. Text fields like address, postal code filled based on the value chosen in choice field from point 1. 3. Another choice field with bank account numbers - another MS sql table filter by ID value from choice field in point 1. Two qestions: 1. By clicking 'x' in supplier name choice field I'd like (...)

(...) Hello, is there a possibility to use existing SOLR as Data Source? I had an idea to show users sql grid, which would show similar items found in database, based on text typed in regular TextInput field. That lead me to Levenshtein Distance algorithm, which might be slow in sql , but i've found that such a thing is already implemented in SOLR (https://stackoverflow.com/questions/1752301/how-to-conf (...)

(...) Hi all! We want to execute a JSON query on a path (actually it is some business rule containing sql query) and send these results to an external endpoint (REST service). The problem is that the query does not reflect current changes in form, since this happens on save. This should be related to database transaction and current values which are not persisted at this moment. Is there even a (...)

(...) After upgrade to version 2022.1.4.174 I get errors on some querries that use . Error occurs when querying another database directly or using join, etc from sql COMMAND or choose field querry. I found that this is related to change described in https://community.webcon.com/download/changelog/117?q=cf05b90, associated with using bps_user on sql COMMANDS. Is there any way to deal with it at sql serv (...)

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