search results

(...) Adding possibility to add SQL row as a column could be also a workaround to achieve that. Right now (BPS 2020...434) is is only possible to add instance number from system fields to mass notifications.

(...) ts/post/using-calculated-columns/196/3) but that's not my case. What I would like to do is join the items from the report to a table in a different database (on the same server) or to an existing MSSQL data source. In many processes I have a global field with the unique identifier. I would like to use this key for a 1:1 join. I can show the join results on the form (using Data row field type) but n (...)

(...) Hello everyone, did someone update the database compatibility level from the default 'SQL Server 2008 (100)' to a newer one and can share their experience? I really would like to make use of those "new" functions instead of using hard to read workarounds. Best regards, Daniel

(...) Hi all, i hope you are well. We have moved our PROD-Environments Databases to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old databases are offline. Currently there is still an alias configured, that routes (...)

(...) or group" field where the picker is limited to a group. 2) I added the "SearchAllTables" stored procedure to look for any occurrence of the BPS_ID of the group. https://ignas.me/tech/searchalltables-SQL -stored-procedure/ Note for myself: I should add a second stored procedure which only searches through relevant tables. Best regards, Daniel

(...) CON BPS. I would like to have at least the last modifying users migrated as well. How could i achieve this? Was thinking about setting a technical field to the last modifying user and then doing an SQL Update on the element after migration. Sure this is not the way that is officially supported. But is there another way?

(...) cation for the new candidate. There are some issues with this, I'm not able to initialize the item list with the dictionary details (only DB or Sharepoint is available), I don't want to do this by SQL query because in the future I will need to do maintenance work if something changes. And the user doesn't want to click Add for all the options needed. I don't have many ideas on how to this. (...)

(...) instances that have the searched term somewhere in the metadata. If i do a global search I get hundreds of hits - so the documents are properly indexed, and can be found when searched. The report is SQL based. Portal Version is 2020.1.3.411, but I couldn't find anything in the bug fix lists about a behaviour like this. Although there were a few bug fixes prior to version 411. I have the same behav (...)

(...) ication containing people related to a company respective business entity. Over the time it is possible they would change the company and so also the business entity. I found a dirty way by using an SQL Update directly on the WFElements table, but I am struggling by running this query by (cyclic) action on a separate path. The path is walking through fine according to the history, but no changes in (...)

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