(...) unity.webcon.com/posts/post/checking-user-and-group-privileges/258/3 So far, I'm able to check Applications and Processes privileges but when it comes to the Business Rules, I get an error for the column they use as Users (users . BRD_Users) : select users . BRD_ID , isnull ( DEF_Name, '' ) as DEF_Name , usage. BRD_Name , usage. BRD_Documentation from WFBusinessRuleDefinitions as users (...)
(...) Hello, I made a report in WEBCON Designer Studio and one of the column s is "Link". However, when I export that report to excel, that column is converted to a simple text (not a link). Can I in some way configure it to receive in the exported excel that column as link? Best regards, Vitalii Lukash
(...) the parent) and DET_WFCONID ={WFCON:3192} Second issue is that, even trying to save the ID from each subworkflow in the item list select {WFCONCOL:3301} as DET_ID, WFD_ID as {DCNCOL:493} (column in the item list) from wfelements where {WFCONCOL:3295} = {WFD_ID} (form field saving the Parent ID) and WFD_Dtypeid = {DT:120} and isnull({WFCONCOL:3301}, '') '' Third issue is that, if (...)
(...) Hi everyone, I would be glad if the following changes would be implemented: 1. Adding the new Input placeholder 2. In case of data tables the display name should be used instead of the column name. This is especially a problem if the data source is a BPS internal view. WFD_AttChoose1 isn't really helpful for translating. :) 3. There's a slight labeling issue. The PathAndTasks sheet doesn't contain the (...)
(...) i everyone, while designing a new Dashboard for my latest application, i am wondering wether it is possible to use the REPORT TILE logic in HTML, so i could optimize the free space usage (eg. a two column table for 2 report tiles instead of two seperate report tiles). Does anyone of you managed this already? Thanks for your help in advance, Bjoern Poller
(...) f, maybe, in further coming WEBCON versions there could be the possibility to add 2 more "section layouts" like i posted in the picture. Mostly the usefull one would be: half side left, and two small column s in the right half. With this layout options designing dashboards and grouping buttons would work much better. Thanks, Bjoern P.S.: Maybe i forgot the third version 25% - 50% - 25%, if someone wan (...)
(...) Hi, ver. 2021.1.3.205 I have a problem with reports. When I hide one of the column s 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 (...)
(...) I have a report that displays data from several processes. If I want to filter by a column which is a global or computed field, for example, the data is prompted only for those that have been loaded. if the data in the filter has been read to the value, e.g. 'o' trying to narrow down to a word that starts with the letter 'p' the search doesn't work. It works well if we filter by column , e.g. author, aft (...)
(...) I hope I can explain it right... I'm trying to add an autocomplete column to an item list that is filtered on a multi select column . So I have a projects dictionary, and want to select a project from that. Each project can have multiple employees working on it, therefore I created a multi-user selection in the project dictionary. When selecting the project I want to get all projects where my account is (...)
(...) big performance drop for reports 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 reports are loaded almost immediately (even those with many calculated column s). It looks like in this version the query has been (...)
(...) ds “on value change” and set the field error if necessary. Currently I use a js-function like this to showing/remove the error message (form display mode: Modern on BPS portal): function showError(column Name, hintText) { let errorLines = $("#" + column Name + " .attributeErrorsPanel li"); if (errorLines.length === 0) { $("#" + column Name + " .attributeErrorsPanel").css("height", "auto" (...)
(...) Hi, we have a column visibility/edit/requirement restriction for every field in an item list. But there is no column visibility restriction for the delete button, so you cannot prevent deletion of some rows. It is something you can do easily with js, but only with classic display form mode. It doesn’t work with modern forms. The problem is that it is not guaranteed that your form rules “Main form -> (...)
(...) Can I use sql function in computed report column s?
(...) Hi there, does anybody know why this error occurs? Happens the following way: - Business rule retrieves datasource column (from [CacheOrganizationStructure]) COS_AD_name by means of a form field value (see 1.png) - Rule works fine if clicked on 'Test' button - This business rule is used in the cyclical action 'Update related workflow instance' with the goal to update a workflow's form values (...)
(...) oes not show the item with the link (as it does in standard attributes). It doesn't matter if the field is read-only or writable - always no link. I suppose the solution could be a separate hyperlink column calculated based on the ID in the choice field, but I have 4 such column s, so there would have to be 8 this way.. way too many. Do you have any ideas?
(...) 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 submitted by 2 people: Test1 and Test2 . When the request is submitted, the Requ (...)
(...) Hi everyone, I have an item list with grouping on one column . I'd like to have this column group collapsed by default. How would I do that? JavaScript? Please consider I'm no js expert so any piece of code or a completely different approach would be much appreciated. Thanks, Martin
(...) olding the items to be sold at the current transaction. These items can be added through standard adding elements (+) button. There is a choice box that opens a list of available items with important column s. You choose one or more items and closing the modal populates the items list with the chosen values. That's an obvious way. But, the obvious way is not really what I'm after. This is because the (...)
(...) (MSSQL database) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has not been initialized.. D (...)
(...) 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