search results

(...) e Base. Additional options to expand on this could include:  Calculating “FileName” and “FileType”  Using categories  etc. Here’s the MS SQL SELECT statement to copy and reuse (replace the {...} placeholders with the actual field values as shown in the image): SELECT   CONVERT(image, CAST(STUFF('{10380}', 1, CHARINDEX(',', '{10380} (...)

(...) FROM WFDataAttachmets WHERE     ATT_WFDID = {WFD_ID}     AND dbo.ClearWFElemID(ATT_Attribute1) = 1     AND ATT_IsDeleted = 0   In this field, you must define an SQL query on the WFDataAttachmets table that returns the ID of the attachment to be signed. For this scenario, the query is limited to the current instance and filters attachments from the To be signed c (...)

(...) exception in this regard. This article aims to outline timeouts based on example scenarios across the following areas: automations, operations performed by the service, HTTP requests, T-SQL transactions, It highlights which of these limits are configurable and which are determined by the underlying infrastructure. The article does not cover limits that may affect the behavior o (...)

(...) Hi, with the introduction of BPS Portal we got a few additional options were we can add "code" and where variables from the expression editor would be useful if not even mandatory. 1. Report - SQL Filter, there are a few variables there already 2. Calculated field in Reports and BPS internal view, no option to use existing variables 3. Report - advanced formatting, no options to use existing varia (...)

(...) Hi, just a simple, easy request - can you please add a usefull code editor to SQL rules, JavaScript rules and HTML fields details ? Sure, one can copy paste the code from external editors, but it takes time, having an embedded editor would be a great feature.

(...) Hi, so HTML attributes are great, but only untill you try to do something with them - like hide for example... or export - import Seems like you keep them all in a single SQL field:-( So, some JS manipulation is needed, rule editor is useless. Can you make normal HTML attributes - every attribute in separate SQL field?

(...) positive. I thought about using the advanced settings, but I have no idea how. Documentation: You can also define the path dynamically. To do this, select Use advanced settings and create a suitable SQL query in the Advanced path choice field. When is this executed? a) When the first sub-workflow is started b) When one sub-workflow finishes c) When all sub-workflows are in state finished Verificat (...)

(...) l to users from item list? I think it will be nice to have this option directly in "Send a custom email" action configuration". For now you have to use intermediate solution to get users list using SQL /CAML querry.

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