search results

(...) than X) and it's painting the entire row. In the new release there are new item list actions which allow to paint one cell but I don't know how to write the change value (probably I will have to use SQL command for this). Any ideas? Thank you all Andreia

(...) There are some new functions for the item list but they only work as form rules and for action (even creating a business rule, form rules don't work as it needs to a TRUE/FALSE result). Even using SQL Command I think it would only work for a subquery because I need to check the value on each row. I've used the Select Values in combination with GetNames function but I was not successful with my id (...)

(...) for each new record entered. I can't seem to create an "application wide" variable that I can reference, create a new proposal # and then increment by 1. Now that I think about it like that, can I SQL query the # of records for the workflow? (Still fairly new to queries in webcon, any help would be appreciated). Thanks

(...) rently we experience timeout issues after some time of inactivity on WEBCON BPS site. Sometimes it's few minutes, sometimes about 1 hour. See example in attachments. Please notice that WEBCON BPS and SQL Server (VMs) are placed in Azure. Does anyone experience same issues? Any feedback is more than welcome :)

(...) It would be great to be able to pass any attachment id to the 'show first attachment on page load', e.g. via SQL query editor.

(...) Is it possible to use CTE Tables in SQL commands in the attribute configuration? If yes, could someone show me an example?

(...) ere would be three e-mails with different content to be sent. Currently i'm thinking about creating a simple workflow to send an e-mail. The workflows would be started with the "Start a subworkflow (SQL )" action based on the itemlist content. Are there other/better approaches to solve this scenario?

(...) Hi community! We implemented a document template with certain fields coming from a custom datarow (based on SQL -Query). We deployed the solution and the document template to PROD and everything was fine. After that we added one new field to the datarow (SQL query was modified) as a new requirement and added the new field also to document template. On DEV system everything looks fine, we deployed (...)

(...) l gave some alternative ways under: https://community.webcon.com/forum/thread/699/15 P.P.S. (2021-08-17): I found temporaly solutuions for editing ATT_ID and continuous numbering with an action (Run SQL procedure) for those who can't wait -> https://community.webcon.com/forum/thread/699/15

(...) Hi all, I'm having a problem in Studio with a Form Validation rule using SQL . I have an item list that is populated with lines if the user select a Sales Order in another field or manually filled if there is no information on the SO. There is a column that is mandatory to be filled whenever the item list has any rows and I tried many examples to construct a validation form rule in order to h (...)

(...) there some option inside the SDK? I haven't found one, so I'm thinking about passing ids/translations via the PluginConfiguration. I just thought about querying a data source. Maybe I could create a SQL view which is utilized by the data source. Did someone do something similar and has some experience? Best regards, Daniel

(...) be assigned in the next step? What I've tested so far: - Verified that the variable 'System fields\Assigned persons' contains the current persons during path transition, exit and entry. - Created an SQL statement which returned the latest row from WFElementTasks, and executed this in an action during path transition, exit and entry. They all returned the old row. - SDK object RunCustomActionParams.T (...)

(...) two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server. Regards Klaus

(...) ment") and it is the type of "Choice tree". When I try to create a report with forms containing this field, the field is accessible depending on report source type... when the report source type is "SQL Source" - the field is accessible when I choose "SearchIndex source" - it disappears from the list of accessible fields... Did anyone face same issue? Is it for a reason, or is it malfunction?

(...) value. It would make more sense to group according to the display option the grouped column is set to. Especially because i dont know how to do calculated columns in SOLR reports like i used to in SQL -reports. ;) I have attached a screenshot to make clear what i mean.

(...) Hi All, I have a workflow where I use “Start a subworkflow (SQL )” action. I also have a “Wait for sub-workflows(system step)” step where I wait until all the subworkflows will end. I configured the “Wait for sub-workflows” to go back to “register step” when one of the subworkflows finished negative. See picture And here are my problems: Let say I started 3 sub-workflows and one of them went ne (...)

(...) Hello folks, I have to create a Word file with data from several workflows and therefore created business rules with SQL Commands in them to help me with that. The problem is, those business rules are nowhere to be found in the Business Rules section of the Word Add-in. Several other rules are shown, but those with SQL Commands in them are just not there. Is this a known behaviour, or a bug, or is (...)

(...) Hi everyone, I had the requirement to calculate a reminder date based on a due date. This should be x days before while respecting the working day calendar. SQL Command for calculating a date _after_ the base date, attachment (1): select Top 1 [CAL_WorkingDate] from ( -- Top: number of working days before the base date SELECT TOP {BRP:13} [CAL_WorkingDate],[CAL_IsWorkingDay] FROM (...)

(...) er a new installation according to the instructions "WEBCON BPS standalone installation" (windows 2019 and updates, .net 4.7 installed automatically with the system, .net core hosting bundle 2.0.9, MSSQL 2019 express, Ms SQL Server Management Studio 18, IIS with Windows Authentication) -in the browser error http 500.19 - internal server error. Additionally, it is not possible to start the website co (...)

(...) nospaced. Simply it's easier to read code, when it's monospaced. In attachment you can see and compare how that simple lines are better aligned, with monospaced font. When you edit some more complex SQL Queries, or when you deal with some custom HTML element - it would make life just easier. There is some question, how to deal with with those Webcon Variable blocks - how they should be aligned, but (...)