search results

(...) Hi, I don't know if this is possible in the BPS 2025 version, but for earlier versions I miss the ability to center the text (and make it bold) on request for each column of the item list or sql GRID data table. I don't think it's possible to set the background color for the column label. Regards, D.

(...) e the step ... where I have 1 person and no waiting for other to finish - it was easy .. but if in step I have assigned 2-3 people and one of then is behalf then ... is more difficult ... sql query: [code="sql "] SELECT WFH_ID as 'ID of history', WFH_STPID as 'Krok ID', WFH_FinishDurationDateTime AS 'Data ukończenia kroku', WFH_LeaveCurrentStepPath, WFH_LeaveCurren (...)

(...) arted. (21.01.2025 14:13:30) 'Build elements attachments query step' completed in 0ms (21.01.2025 14:13:30) 'Get attachment metadata' started. (21.01.2025 14:13:30) Downloaded 1 metadata rows from sql in 0ms. (21.01.2025 14:13:30) 'Get attachment metadata' completed in 0ms Exception at ID: 93238 Error occurred: WebCon.WorkFlow.Service.SolrIndexer.Steps.AttachmentNotFoundException: Attachment (A (...)

(...) ive. In my scenario I will have very often negative steps Solution 1 option to solve all path put to positive step and use wait for all positive and forget about problem Solution 2 set sql query where it will wait for all subflows doesn't matter positive / negative and if all will finish then will go by 1 path common for all results. I did sql QUERY: [code="sql "] SELECT e. (...)

(...) eciate any advice, ideas, or suggestions on how to approach this. Any pointers on how to capture and log these actions would be incredibly helpful. I was thinking of potentially tracking the internal sql queries but I need to know which user accessed the data specifically and I'm not sure I can engineer a solution that tracks background queries anyway. And this does not solve the issue of users acces (...)

(...) ecution for one row took 87ms seconds while another took 4279ms. I don't have the slightest idea, why this happened, how I can track this or how to prevent it. My best guess is, that a bulk of sql commands needed to be executed and this one was in a queue which execution was delayed. The version is WEBCON BPS 2023.1.2.99. Best regards, Daniel

(...) erver and then perform upgrade on the new application server, but the installation fails when connecting to the Search Server: 06-02-2025 19:02:51 msg: Step2 src: Upgrade 06-02-2025 19:02:55 msg: sql version: 14.0.3480.1 src: sql ServerVersionChecker 06-02-2025 19:02:59 msg: Url to Solr: http://[SERVERNAME]:8983/solr/BPS_Activities/query?q=*:*&q.op=OR&indent=true&fq=TS_Insert:[2025-01-06T19:02: (...)

(...) Hello, I would like to create a new data source in the MSsql Database category that would retrieve information from a list of values ​​​​from the form and other attributes on the same form, but I don't know what such a correct query should look like. Currently, my query is only able to retrieve information from the attributes themselves, but not from the list of values. Edit: I found the solutio (...)

(...) hi, I would like to create a calculated column for a report with a list of items. This column, using sql , should fetch data from another process. I want to map it based on the DET_Att23 ID for each row of the report:: select sum(DE.DET_Value2 - isnull(DE.DET_Value17, 0)) as nn from WFELEMENTS join WFELEMENTDETAILS DE on WFD_ID = DE.DET_WFDID where WFD_DTYPEID = '212' and DE.DET_WFCONID = ' (...)

(...) Hi Guys, Is there any way to configure paging for the item list? Got one with > 280 rows, initiated from the sql query. I cannot use data table to display the data only, as users need to add comment for each row in one of the columns.

(...) g a BPS data source > Filtering section [The bug] In a data source filter, when using the ALL_TRUE operator, the WHERE condition in a generated query is prematurely simplified, what results in an sql error. [Workaround] Chain AND operators. [Fix] Please fix the sql translation of the ALL_TRUE operator :)

(...) ed. While this is not necessarily an issue, it may become one depending on the search phrase. In our case it takes almost one minute until the search is executed. This is due to the fact, that the sql server breaks the search phrase into a a lot of parts which has a dramatic effect on the the query. A little background, the search result returned 4 rows and we have only 10795 workflow instances (...)

(...) Hi, I'm having a dilemma about comparing two date objects. My thinking is when I do sql queries to retrieve data from objects it will give you already stored db results, but with webcon functions you actually get value before it is actually stored. It does not work this way, so i'm looking for a way to do it. In conclusion, it should compare date before change and after change (this is triggered on m (...)

(...) will save the instance changes. add extra field in the item list with boolean that will examine is something changed or not. - parsing current values with js and creating json which can be read via sql , this could potentially be more complex

(...) Is it possible to insert into wanted dictionary related item via sql query or else ?

(...) n any ports other than HTTPS/HTTP (443/80) on the application server to run the Designer Studio on a remote machine (not on the application server)? - or open traffic from that remote machine to the sql server

(...) Hi, while we can create business rules which act similar to table valued / scalar functions, we can't pass the columns/data to them. The inner business rules are executed before the outer sql command is executed. This comes in really handy in a lot of cases but also has it's limitation and will require creating repetitive code. I would suggest the following: Create a new "type" "sql functio (...)