search results

(...) Hi everyone! We are currently using BPS 2023.1.2.44 in our office. Is it possible to exclude certain report column s from an Excel export? We need to display the column s in the Web report, but don't want to show them in Excel. Best regards, Christoph

(...) g report, where I want to show all responsible people who have tasks divided on Active task, Active task after deadline, Finished task in time and Finished task after deadline. I've made calculated column : case when WFD_AttDateTime5 < WFD_AttDateTime6 then 'YELLOW' when WFD_AttDateTime5 > WFD_AttDateTime6 then 'GREY' when WFD_IsFinish = 0 and WFD_AttDateTime5 < GetDate() then 'RED' when WFD_IsF (...)

(...) Hello everyone, it seems that in a report, you can only drag column s from one items list. If I try to add a column from another items list to the report, I receive an error message " Error adding items list column - There are already selected column s from items list ...." We need a report that combines column s from various items lists. Does anyone know how to solve this problem? Thanks Lina

(...) Hello, Is it possible to center the item list column label? I see that the form rule allows you to center the value in the column -> SET CELL STYLE. Applying CSS to the entire list of items centers labels, but not all column types (works for picklist column type). Regards D.

(...) Hi guys, got case here where in Webcon's report there is a row from item list. This row is added as a column to the [column s available in report] as on the screenshot, but remains unticked, therefore not visible in the default view on the report. Nonetheless, report still shows multiple lines with same data/instance ID, if there is > 1 item list row with data on the form. This should be the case if the (...)

(...) Hi, if a data row/ data table is based on a BPS internal view to configure, whether the names/translations of the column s should be used. The default value should be true. It's just a waste of time to not only provide the translations the first time but also to update these when the name/translation of the referenced column changes. Most of the time it's forgotten anyway. Best regards, Dan (...)

(...) ave an equipment initialization process (1) , followed by another process of allocating this equipment to a user (2). I have created a Report - "Equipment allocation" and I want to add a calculated column to this report that brings in the "Series" of the equipment from the Initialization process. I have this query: (select dbo.ClearWFElemAdv(WFD_AttChoose2)[which is the "Series" column in proc (...)

(...) Hi, When inserting an item list in a word template, the add-in asks for some column s configuration for the final table. Issue is that modifying "Display name" of a column of the item list is not visible in the final document, it is visible only in the template. The attachment document receives the original item list column name. The "Display name" set for an autogenerated column (like ID) works (...)

(...) Hi, WFD_Att Choose column s have size nvarchar(1000). When using the 'allow multiple values' mode and having translations in the source into 3-4 languages, additionally if the ID is e.g. guid, this value is exceeded very quickly. Is it possible to increase the database size of this type of column s to nvarchar(4000)? Regards

(...) subworkflow. I'm trying to transfer data from the parent workflow (single line of text attributes - 'email' and 'phone') to a table in the subworkflow with the item list update action. The table has column s ('value' - single line of text and 'contact type'(selection list: 1#Mail, 2#Phone)). How to write an SQL query to put different WFD_AttText attributes into one DET_Att column and different Att_Choos (...)

(...) Hi, I'm starting sub-workflow instances from item list. I would like to save sub-workflow instance ID to the related column of item list. I'm using automation having FOR EACH and Start sub-workflow action. All i can see is the possibility to save subworkflow ID to the form field, not item list column s. Is there a better way than having another action updating item list with the IDs?

(...) It would be useful to be able to group the data in the itemlist at the column level and on the main form. Currently, we can group at the level of each step, but sometimes when we have many steps, it would be more useful to be able to set it just on the main form. Thanks, Raluca

Hi! We're stuck with an error using the Send Custom Email action with the default User or Group attribute as the Recipient, after updating from 2023.1.2.123 to 2023.1.3.118. Any tips on how to resolve this issue? Thanks, Patryk

(...) Hello all, I have an item list with a editable column . This works if the item list does not have a lot of lines but if the item list has a long list of lines, this column becomes read-only and the user is only able to edit using the a pencil button that is displayed in each row. Is this a normal behavior? Thank you

(...) Hello, I need to set up two column s to calculate some KPIs for a report. The first one will show the status based on Case statement and date difference: (select case when DATEDIFF(day,WFD_AttDateTime3,getdate()) >0 then 0 when DATEDIFF(day,WFD_AttDateTime3,getdate()) = 0 then 1 else 2 end) The second column should pick the number of instances that have the conditions DATEDIFF(day,WFD (...)

(...) ion such as "array data" (PL: "tabela danych") I tried below example changes in global CSS style, but it didnt work: th[data-key="WFD_AttLong1"] { color: blue; width: 200px; } td[data-column ="WFD_AttLong1"] { color: blue; width: 200px; }

(...) for example - it should be stored only on order, but not on suborders. In the reports i have one report for orders, second one for suborders - on suborders I'm able to show 'customer' using custom column . With SQL like this: ( SELECT dbo.ClearWFElem(WFD_AttChoose2) /* Customer */ FROM WFElements JOIN WFSteps ON WFD_STPID = STP_ID JOIN WorkFlows ON WF_ID = STP_WFID WHERE WF_GUID = (...)

(...) niversal as possible, and I want to pass two parameters to the SQL query. So far, so good. The issue is that I want to pass the same form field as a parameter twice: once as a value and once as a "column name" (essentially as an object value that I can transform in SQL with single quotes to something like WFD_AttText4). This way, in the SQL WHERE condition, it would say something like "and WFD_AttTex (...)

(...) Data sources TAB in Application - add column with "Access to data in the context of system account" NO I need to click one by one to check if is marked or in each attribute "arrow" next to data source and jump to data source and then check is picked ... (in some scenario arrow is not active ...so Application .. then the data source .. pick proper one and then check ... ) Could be easier to see that (...)

(...) Hi, at the moment the column "ElementName" is used as a category /subfolder while the column "Category" is used to display the filename. select Top 3 ATT_ID , ATT_FileType as ElementName , ATT_Name as Category I'm not using these option very often but each time I'm looking at the names in the info icon and get confused. My suggestion would be to add alias and update the documentation, (...)