search results

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

(...) Hello all, I have a data table field where I'm selecting the fields using a SQL query . One of the field is a picker and I want to show just the Text and not the ID. I've tried many options but as soon as I try using the Database-Name, it's giving errors. I believe it's because the option has space on it : 'Non Ok'. But the system should overcome this right? Even using the DBO function, it doesn't (...)

(...) ered if they are used in an item list data row column.: https://community.webcon.com/forum/thread/5247 I tested the most common/likely elements and to verify which are supported by using this SQL query : select 'a tag' + ''+ 'button tag' + ''+ 'div tag' + ''+ '' + ''+ 'img tag' + ''+ 'input tag' + ''+ 'p tag' + ''+ 'span tag' + ''+ 'strong tag' + ''+ '.class'+char(123)+'display:none'+ c (...)

(...) into process [1] via a subworkflow. The data that comes from process [2] is in an item list and should all be entered individually (as separate instances) into process [1]. Before this, however, a query should be made as to whether the respective instance of the specified person has already been entered in process [1]. Problem: I can't seem to access the value of the item list (qualification) in (...)

(...) ce with something. I am currently working on a Business Rule that should return a value using SQL. The Business Rule needs to be as universal as possible, and I want to pass two parameters to the SQL query . So far, so good. The issue is that I want to pass the same form field as a parameter twice: once as a value and once as a "column name" (essentially as an object value that I can transform in SQL (...)

(...) } = '{WFD_ID}' The big question is, why was it working in the first place and only failed in production? The production database contains way more data and the SQL server decided to execute the query differently. Test system: The index of the choose column wasn't used, which "magically" allowed the query to work. Production system: The index of the choose column was used which contains text an (...)

(...) alParams/UserSynch/SynchConfig/LDAP I'm trying to make it work, but all entities (users, and groups) are being synchronized as groups. From the error log it seems like Webcon is generating LDAP query with an error - the OR - | - operator seems to be in wrong place: - (8/12/2024 8:29:33 PM) Searching LDAP://ldap-server:389/DC=ldap,DC=goauthentik,DC=io?uid,gidNumber,objectClass,accountExpires,ad (...)

(...) a subworkflow". Issue: all attachments of the parent workflow are copied Idea 2: I create the instances and create an action template to copy the attachments from the parent workflow using a SQL query , reading the ATT_ID from the attachment column. Issue: with single attachments per line it will work, with mulitple I get an error as webcon stores the Att_ids with a comma (e.g. 6603,6604) which (...)

(...) In which table can I find information about the time of editing a given ID by a user? Mayby do you have a query ?

(...) emList = #{BRP:151}#; setTimeout(() => { var itemListElement = document.getElementById(itemList.fld + "_" + itemList.id); if (itemListElement) { const provenientaElement = itemListElement.query Selector('th[data-key="#{SFLD:512}#_#{DCN:512}#"]'); if (provenientaElement) { const textElement = provenientaElement.query Selector('.header-cell__content__text'); if (textElement) (...)

(...) Via public api we can query reports and views. However, they lack of the possibility to apply filters, search in specific fields or apply a full text search. Basically all the things we can do within a report on the portal To achieve this, we currently have to use the undocumented internal api, that reports use when we apply filters and search for elements. This works perfectly so far, but it w (...)

(...) ly idea right now is to remove the class which causes this via JavaScript in the HTML field, so that it is aligned with the other controls (2). document.getElementById("SEL_HTML_#{WFCON:7009}#").query Selector(".grid-template__panel .upsidePanel__content").classList.remove("upsidePanel__content") or with CSS: #SEL_HTML_#{WFCON:7009}# .upsidePanel__content {margin-inline-end: 0px;margin-inli (...)

(...) Hi everyone! After upgrading to version 2025 we noticed that the Advanced settings are not working in the same way as they were in the previous versions. The query that was working just fine before is not doing its work. Does anyone else have the same experience? If this helps, this is the query that we're using: IF ( /* Number of all child workflows */ SELECT COUNT(*) FROM WFElemen (...)

(...) dont fall for the issue that hit us today. I wanted to share some info regarding the update from 2022 to 2023, as we ran into some very unsatisfying issues with SQL COMMAND business rules that are query ing field IDs. It hit us on some neuralgic spots in our main workflow, causing quite some pain right now. If you still have to update to 2023 make sure you test every SQL COMMAND based rule (and da (...)

(...) [Webcon 2024.1.1.130] (i thin it was working in 2022.1.4.404 - but I need double check] I have action to update item list where source is Parent Item list. The sql query is working but filters .. works if there is no polish letters :| so: [code='SQL'] SELECT d.DET_WFDID AS 'ID elementu', d.{DCNCOL:1135} AS 'Sygnatura Audytu', d.{DCNCOL:1132} AS 'Tytuł raportu 8D', d.{ (...)

(...) and API call fails with 401 The question: is there a way to have that global constant request suffix NOT ENCODED when concatenated with the server base URL? As it is part of the call address, not query params for the call. Thanks, Mihail

(...) nd all type of data in columns are correct: VAC_UserID VAC_From VAC_To VAC_VACTypeID SQL: select * from [V_Urlopy_Historia] After some tests we've done: After manually entering the sql query on TEST SERVER (2024.1.1.161) that indicates a specific time range, user and vac_type - data appears in the report. BUT ONLY if the query concerns a maximum of 2 days. If the query has more than 2 da (...)

(...) of the action will fail, if the integer values are not the same on both systems. In the worst case the value does exist for item list on both systems but for different ones. You can use the below query to get all actions which have a faulty configuration. Best regards, Daniel SELECT TOP (1000) ROW_NUMBER () OVER ( order by actionDefinition.ACT_ID asc) as RowNumber , actionProcess.DEF_N (...)

(...) The problem is that in my leave of absence workflow I have an action that sets up substitution for the time a person is out of office. When I run a test (see left side of the enclosed screen) the SQL query shows correct dates of substitution (the same as te person's absence). When the acton runs the substitution is set to last for one day longer than expected. Why is this like that? Where am I doing so (...)

(...) e step ... where I have 1 person and no waiting for other to finish - it was easy .. but if in step I have assigned 2-3 people and one of then is behalf then ... is more difficult ... SQL query : [code="SQL"] SELECT WFH_ID as 'ID of history', WFH_STPID as 'Krok ID', WFH_FinishDurationDateTime AS 'Data ukończenia kroku', WFH_LeaveCurrentStepPath, WFH_LeaveCurrentStepD (...)