How to find previous object´s data in UC4 database

Document ID : KB000089763
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
How to find previous object´s data in UC4 database
Resolution:
Detailed Description and Symptoms

This article describes how to find objects saved with versions management in the database?


Investigation

Ticket S# 191403?


Solution

This data is saved within the OX table. Copy this to a editor like notepad++ and change the character setting from Hex to ASCII.

Using the following statement you will use the SQL builtin converter.

MSSQL:

select *, CONVERT(varchar,ox_content) from ox

 

Oracle:

need to test this. will be inserted.

?