search results

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

(...) Is it possible to filter on a specific step in the report (view - new view) (regardless of the DEV / TEST / PROD environment)? Unfortunately, when moved to another system (DEV to PROD), the ID of the steps changes. And from the browser level, when adding new views, you need to add the step ID.

(...) Dear All, is there any possibility to display report as calendar type, but with 12 months, as full year view? Currently we only see option to display one month (largest one). Thanks for any response here. Best, Adam.

(...) Hi community, once more I need some help to get things working: Having the task to show a picture within a report in WEBCON BPS 2022.1.2.59 I found this article in the knowledge base: https://community.webcon.com/posts/post/the-picture-form-field/32 Establishing the fields and trying to get the image rendered within a report I had to learn: Only the link generated in the way as described in the (...)

(...) Hi. I have a big SQL from 3-4 apps. Is the possibility to generate report from my SQL data source ?