Rules, JS, SQL
Hi everyone! Am I blind or there is no function oposite to COLLECTION, that would remove an element from collection? How do you manage to overcome the lack of this function? I came up with an idea of making a JS form rule that takes a collection and removes a value given in one of the parameters. It works. But there are limitations that make the solution inelegant. First of all the form rule can not return a value (in opposition to business rules, but those however can not contain Javascript (...)
Hi all, I have a question, in a report view like the one attached, I mean the right hand side where the outstanding tasks are, is it possible to intervene to add a description? I have for example an urgent request which is also marked on the form, is it possible to include such information in this view, possibly change the colour of the tile or title. Can I do something to make it stand out? Maybe someone has already struggled with this.
Hello, Does anyone know if it is possible to achieve the following functionality: - I would like to insert a button in an item list column. I can achieve that so I don't need help with this (WebconBTN_01.png). This code produces the kind of button from WebconBTN_02.png image. - When this button is clicked, I want to set the DET_Att1 (it's a Yes/No field) to 1 (not run the action from the screenshot). Can someone help me out? Can this be achieved with javascript? If yes, how? Thank yo (...)
Hello, I'm trying to create a rule in JS that will listen to my checkbox value change. checkbox -> TRUE do something checkbox -> FALSE do something else I've created a HTML field with a simple <script> InvokeRule </script> inside.. placed my rule, and error. :) Can you help at all? Thank you!
Hello Community, it's time to ask my first question...so please, be understanding and polite ;) Business case: 1. I have a dictionary process, let's say 'Products', with 'Tags' text field, which contains tags (eg. black, bike, red). Every tag is separated by ','. 2. I have another process, for example 'Order'. On this form, user can enter what he is looking for, on 'Description' field. I want to check if any word from order's 'Description' field matches the 'Product' tag and return the n (...)
Hello, I have a process (start - finish) that creates an instance and remains in the "Finish" state. Here, I have the following form fields: "Quantity TOTAL" (Floating-point number) and "Quantity" (Data table). In that data table, I have other instances from a different process, and in one column (Quantity Requested), I calculate the sum. How could I save that sum in Quantity TOTAL and have it consistently updated? (i mean - transferring the Aggregation type Sum value in my form field). (...)
Hello, I have a parent process with Item list. This item list is list of tasks. I can add positions to this list and I have a button to initialize this list as a tasks. In this list I have a title, responsible person, status of the task and section (it should be item list with attributes in the form?). When I add the position and put in all data (title, person responsible and section) I hit the button, and I make new process Task to responsible person - new workflow. I have 2 problems: (...)
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.
Hi, I don't know if this is the right place, but I put in HTML element in dashboard. I want to get data from forms or reports and display them modified with CSS, JS. Is there any tips to do it? Is it possible? Regards Adam
I'm having trouble running the SQL subworkflow. The query entered during the configuration works fine in testing. However, when I try to run the subworkflow in the application, I receive an error message that says, "An error occurred while executing the start subworkflow (SQL) action at the path. (Step: Verify application, Path: Submit for review) Incorrect syntax near the keyword 'from'." What could be the cause of the error if the test query displays values correctly?
Hi, I used in data sources " Current BPS databases" in field type choicefield clause IF. It's was worked until did upgrade at last verison 2022. After upgrade, When I select a value from field show id value not name value. Thank you, Raluca Lupu
Hi, I want to limit one column in list position , which is multiline text to show only first 40 characters smth like: <?php echo substr(get_the_title(),0,40).' ...'; ?> after click in '...' it will show all text
Hello, I have the following scenario: - Webconapps - Data Sources > Connections > MSSQL Database > Azure_SQL: I have server name, database, user and password filled. When I click Test, I get "OK" so Webcon can connect to the database. However, when I try to create a MSSQL database Data Source and chose the above connection, I get the following error: "Unknown error: The SELECT permission was denied on the object 'table_name', database 'database_name', schema 'dbo'..." Using SSMS the (...)
Hey everyone! Is there a way to keep line breaks (CR-LF) in the output of the SQL Command used in a Business Rule? I'm selecting values from DET_LongText1 which has line breaks. I'm attaching 3 images to show what I mean. 1. Webcon Form: What I see on the frontend. 2. Notepad++: What I see in Notepad++. 3. Output: What I see in the email if I output the value of the field with a Business Rule. I can't output the form field directly because it is coming from an Item List. Do you have a (...)
Hello, I'm trying to start a subworkflow from an item list. My item list will have the candidate for Positions and it will not be filled at the same time, each time there's a candidate for an offer, the user creates a row. To start my subworkflow I'm using as conditions having the candidate name as not null and a flag set to true and i'm using this as an execution condition with the following SQL: if exists ( select 1 from WFElementDetails where DET_WFDID={WFD_ID} and DET_WFCONID={WFCO (...)
Is it possible to get an email notification when somebody is posting a comment without pressing any "move to next path buttons"? In the screenshot the yellow area.
Hello, I have a workflow and after clicking on the path button I want to assign it to the another workflow as a sub-workflow. In start step I have an attribute where I can choose the instance of workflows and after clicking the path button, this workflow will be a sub-workflow of choosen workflow. I don't know if I write it clearly :) Regards Adam
Hi everyone, maybe someone else is using some internal JavaScript objects and if this is the case, check whether you are using window.initialModel and make adjustments. In R2 it's gone. Most of the objects of the initialModel can be accessed via the liteModel. /api/nav/db/${parameters.dbId}/element/${parameters.instanceId}/desktop If you have no idea what I'm talking about, than everything is fine. :) Best regards, Daniel
Hi We recently changed the version of Webcon from 2020 to 2022 and I came across this problem. In the report we used a calculated column to show comments: (SELECT ISNULL (dbo.f_clear_description(wfelems.WFD_SIGNATURE), 'None')) However, from what I can see in database, the comment format has changed and now when using this function I get an error: "Invalid length parameter passed to the LEFT or SUBSTRING function." In the attachment, I marked in green old comments, and those starting w (...)
Hi all, does anyone know why this error is showing or how to fix it? It appears when I try to change the position of the fields in the form.
+48 12 443 13 90