Hi Michał,
I'd check if there is broken inheritance but not on form level, but on step/form/attribute level.
This doesn't make the form icon red on the tree, but it still breaks inheritance just on lower level than form.
Hi Michał,
I'd check if there is broken inheritance but not on form level, but on step/form/attribute level.
This doesn't make the form icon red on the tree, but it still breaks inheritance just on lower level than form.
Hi,
Thanks for the reply.
Your method works for an action performed on a path, -> but the data source won't hook into the transaction, so it is not possible to work on data in a transaction -> action needs to be moved to next steps where Data Base data is updated -> so it is not good in some scenarios.
UPDATE:
I've already figured out why CTE didn't work on Data Table -> in earlier versions of Webcon semicolon before
;With T1 as
(Select ISNULL(Old,'') as Old, pivotcolumn1
from WFHistoryElements...
It was ok in 2025.2.1.42 - in 2025.2.1.91 it throws an error :)
Glad it's solved, I won't add a ticket then, semicolons are statement terminators in SQL so the behavior seems logical with that added to the context.
Error message isn't pretty, and explaining unfortunately.
Indeed, the straight forward query would return nothing, but at least you have the chance to work on it and solve whatever problems arise once data is archived. We solved the last problem - SQL vs archived elements, then we've got stuck with Webcon control not doing anything. Seriously annoying. To overcome this we have to think to an additional item list to throw at it with the last combination of children just before archiving the parent-children structure.
I'd suggest leaving a user voice, so Webcon will have a chance have a take on this topic ;)
Hi Mihail,
Archiving moves data to different tables/databases, and removes them from the main WFElements, WFElementDetails tables as far as i am aware.
If your custom queries try to get data from those, there just simply isn't any data to get, as those are moved to archive database (assuming you are archiving by moving to archive db).
This could result with datarow not rendering, although for datatables it seems like Webcon explicitly turned that preview off (we're not yet using arch. functionalities, so didn't had a chance to check it).
Indeed, the straight forward query would return nothing, but at least you have the chance to work on it and solve whatever problems arise once data is archived. We solved the last problem - SQL vs archived elements, then we've got stuck with Webcon control not doing anything. Seriously annoying. To overcome this we have to think to an additional item list to throw at it with the last combination of children just before archiving the parent-children structure.
Hi Mihail,
Archiving moves data to different tables/databases, and removes them from the main WFElements, WFElementDetails tables as far as i am aware.
If your custom queries try to get data from those, there just simply isn't any data to get, as those are moved to archive database (assuming you are archiving by moving to archive db).
This could result with datarow not rendering, although for datatables it seems like Webcon explicitly turned that preview off (we're not yet using arch. functionalities, so didn't had a chance to check it).
Hi,
When instances are "live", datatables / datarows are just nice objects to use. However, when an element is archived, datatable shows "No data preview for an archived element", while datarow does not render at all.
Scenario: a parent and 1+ children. You can have a datatable in the parent's form to show the list of children along with some relevant info, and each child may have a datarow to show the same about the parent. While parent & children are not archived, everything is just fine, but when you archive any of these elements, datatable/row gets empty and datatable shows that "No data preview ... archived ...".
Data sources are custom T-SQL, but I suppose that's not the problem.
I need to show the data within datatable / datarow no matter the element status.
Thank you,
Mihail
Hi Michał,
besides CSS / JS there's also an option to hide this button with the 'HIDE ITEM LIST BUTTON' form rule.
Regardless of way, the Usages tab should help you find the reason, even if it's done by CSS/JS.
Best regards,
Daniel
Assuming you don't need to fetch data from the current transaction, as a workaround that doesn't require major changes (like changing the data source to a connection at each point of use), I suggest changing the connection in your data source configuration from "current BPS database" to a new connection to the same database. Then the data source won't hook into the transaction and the error won't occur.
Hi,
Thanks for the reply.
Your method works for an action performed on a path, -> but the data source won't hook into the transaction, so it is not possible to work on data in a transaction -> action needs to be moved to next steps where Data Base data is updated -> so it is not good in some scenarios.
UPDATE:
I've already figured out why CTE didn't work on Data Table -> in earlier versions of Webcon semicolon before
;With T1 as
(Select ISNULL(Old,'') as Old, pivotcolumn1
from WFHistoryElements...
It was ok in 2025.2.1.42 - in 2025.2.1.91 it throws an error :)
Hi Michał,
maybe there is some js script (or css)?
you can try to add a new step, in the matrix enable ONLY this list on it and see if it will be possible to add/remove rows. This way you will check if there is something wrong with this list or if other attributes/scripts do it.
Hi everyone,
I have a problem in a project that I took over some time ago from another developer. Specifically, the "add" button for the item list only appears on the first step, where the item list is visible. On every subsequent step, although the list is editable, there is no "add" button to allow adding more rows. Similarly, on the following steps, there are no action buttons like "clone" or "delete." I have checked the editability in these steps—both on the attribute and on the matrix (inheritance is not broken)—and made sure that it is not being manipulated by any form rule.
I am using version 2025.2.1.91.
Does anyone know what might cause this?