search results

(...) Hello, I wonder if this is a bug or feature... I have a form field named "Dział" ("Department") 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 (...)

(...) Hi All we have a large report build in one of our processes (list of all invoices which contains >350k items) which is now not loading for users. we have rebuilt it in SOLR and it is fast like TGV train but we had some calculated columns based on item lists which we need to rebuild. Is there any manual, KB article that describes this or anyone having expierience?

(...) When creating the report s it would be useful to have the option of joining the WFElements table to other external tables in order to show data from other systems in the same report without the need to duplicate this data on Webcon. ​This way the integrations with other systems would be even easier and there would be no need to duplicate data that already exist in some other system. Can you consider deve (...)

(...) Hi, ver. 2021.1.3.205 I have a problem with report s. When I hide one of the columns and then I would like to change the position of the other column in the report and then I have an error... http://webcon.net/WEBCONBPS/db/1/app/21/element/1037860/form/view?returnurl=%2Fdb%2F1%2Fapp%2F21 url: https://webcon.net/WEBCONBPS/api/logger | action: ip: xxx | msg: "stack": "TypeError: Cannot read properties (...)

(...) Hi, After upgrading from 2021.1.3.205 to ver. 2021.1.4.84, I can see a very big performance drop for report s that have more than 250k items. Very often they don't even load at all. All indexes and sql statistics are rebuilt. After verification, I found the reason, it is the column 'assigned to'. After removing this column from the report , all large report s are loaded almost immediately (even those with (...)

(...) I know that in webcon report there is only possibility to show only one "Item list" attribute but is there any possibility to create some technical data table or atribute to show more than one list? Or maybe you can give some example of SQL function which select more than one "Item list". Thank you in advance for your help.

(...) Can I use sql function in computed report columns?

Is there a way to query the database or check in the designer studio about the number of form fields created in our application?

(...) We have a visibility restriction (hidden for few security groups lev1-lev4) on a form field and visible for few other groups. I have created a new report and added the form field which has visibility restriction to the report but it is not displaying any data due to the visibility restriction. As an admin also I cannot see data. How can I fix this issue?

Hi there, I'm trying to work out a rule to color backround of a date cell. The condition would be "if the date in the current field is greater than today, then color backround, else dont change the color". Currently the not working JSON code is: { "content": "=CurrentField", "style": { "background-color": "=if(CurrentField > today, '#FF0000', '')" } } I've also tried differen

(...) Hi, We have 2 processes: Accounts and Payables . I have created a report for those 2 processes with global form fields fields. Among them there 2 people picker fields. The report is pulling all the requests without any issues but when I tried to filter on the global people picker Column, it is not showing the data. Example: we have a Requestor people picker Technical form field. There are few r (...)

(...) We have 2 processes: Accounts and Payables . I have created a report for those 2 processes with global form fields fields. Among them there 2 people picker fields. The report is pulling all the requests without any issues but when I tried to filter on the global people picker Column, it is not showing the data. Example: we have a Requestor people picker Technical form field. There are few requests su (...)

(...) Hello everyone I have question about Suggested report - when there is many threads and many values in categories not every value in each category is shown. Only firest 10 most common values are shown. I need to use filters to received less common data. For example - I know that Tomasz is author of some threats, but he is not visible in category "Author" becuase amount of this threats is less th (...)

(...) e items is not very usable for salesmen who need to find objects by several properties at a time (in my case: area, price, number of rooms, etc), as the list allows only for a simple search. However, report s do great job and allow all the necessary filtering and grouping. Using a report would be a perfect start for a sales transaction. I was working on a solution to allow salesmen browse through a r (...)

(...) Hi, because of the lately very, very poor performance of SQL-report s I have changed some report s to Searchindex. The SQL-report s always only show the workflows that the user has access to, after I changed it to SearchIndex every user sees everything in the report , but of course then can't open the instances they dont have permission to. The predefined Filter is set to all. Is there anything I can do (...)

Hi Guys, Has Webcon any function or script to extract the [Comments] field in the "human eadible" way? Lets say DATE | AUTHOR | COMMENT TEXT. Selecting from WFD_Description for particular ID gives me output like below. It is becoming more complicated if I have two or more comments, divided by ','. SELECT WFD_ID ,WFD_Description FROM [BPS_Content].[dbo].[WFElements] where wfd_id=xxxxx

(...) Hello everyone, I’m trying to set the color of the cell in a report based on a comparison between the current field (AttDateTime1) and another column (AttDateTe4). It works if I compare the CurrentField to a fixed value. As soon as I try with the other field name, it doesn’t work anymore. Is it even possible to have such comparison? Thank you, Martin

(...) The report ing and filter options of WEBCON BPS are already great. However we have customers who would like to have a filter "all but..." or "not" like we already have "Begins" and "Contains".

(...) Hi, We have updated our webcon to the latest 2022 version "2022.1.1.53 Standalone", but after update the "Generate RS report " action is returning error while execution as below: Error in Menu button action Generate Initial Detail report . The HTTP request is unauthorized with client authentication scheme 'Ntlm'. The authentication header received from the server was 'NTLM'. The remote server re (...)

(...) Dear Webcon Community! Problem: you cannot use datarow fields on portal report s. Proposal: make it possible as it was a calculated field on report , running as subquery What do you think? Thank you! BR, Peter