WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts

latest posts

MVP

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

In reply to: Adrian Motyka

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 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?

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings