WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Most commented > Rules, JS, SQL

Rules, JS, SQL

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?

MVP

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

MVP

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

MVP

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

Hi, is it possible to do it via javascript is the main question. i know that this could be done via sdk(c#) and there is already an example guide of it on the forum, but i was wondering would it be possible to create a parser in javascript, that can be loaded maybe by the hotfolders option ?

MVP

Hello everyone, I’m still learning how to use JavaScript effectively with WEBCON BPS. Currently, I’m working on a project that involves an HTML button/JavaScript triggering a file download at the end: JAVASCRIPT: // Save the PDF and offer it for download const pollerPdfBytes = await pollerPdf.save(); const blob = new Blob([pollerPdfBytes], { type: 'application/pdf' }); const url = URL.createObjectURL(blob); const link = document.createE (...)

Dear WEBCON Team, is there an option to only SHOW or HIDE the cell of the current row (in the specified column)? With the Form rule in the Screenshot the whole column is affected. Same for the Mark Required / Mark Not Required Rule. Thank you & Best Regards, Lena Schmidbauer

Hello, I have a simple question, just out of curiosity, what does: ATT_IsSecret good for? I never used it and today I saw it and I realized I know nothing about it. If anyone has any knowledge, please share. Thank you, Best regards

Hello, I have a little problem. My scenario is something like this: I have an item list, with 3 columns A, B(not important here) and C and I want to disable column C(data row), if column A(choice field) has value 1#Mother, for example. Even if it's a new row just added by the user at that moment, even if it's a row added previously by other user in another step.. I just simply want that column C to be "enabled" only for a certain condition. What I did, I followed the steps from this threa (...)

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

MVP

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.

Hi, I'm having trouble converting the contents of an attachment to BASE64. On the system step I have a TimeOut that calls the transition path after a minute. In the traversal path, I have an action that calls a web service. The frame uses a business rule to convert 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 (I (...)

I've got a contract database workflow. One of the fields on the form is Project/Department field which is the same as user department in AD users list. Two users: Adam and his boss John. Is it possible to: 1. show in the report only these records, where current user login (account) department is equal to Project/Department felds. 2. on the app home show instances not only created by the current user but all instances created by John's team? At he moment John is seeing Adam's data but this n (...)

Does anyone know if it is possible to provide translations for the Form Rule Functions ALERT and CONFIRM? I tried with "MyText$$DE$$Mein Text" but that doesn't do anything. Cheers Pasquale

MVP

Hello, I tried create sql script for created a global business rule with existing multiple global business rules . I tried use of multiple global business rule ( with parameters) in one global business rule (with parameters). Every global business rule used has parameters. The business rule that appeals to the other business rules has parameters that are mapped in the appealed rules. I get the error when I testing. I explained the error and showed the code in the attached image. Thank y (...)

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings