Extract LiveReport Output via Database Query
Asked 5 months ago
Modified today
Viewed 168
times
Asked By Devarapalli Raja Vardham
0
How to extract the SQL definition of a LiveReport using its DataID from the DTree table?
Answers
0
The actual output of the Report cannot be retrieved directly, as it must be executed to generate results. However, the SQL definition used by the Report can be accessed from the ExtendedData CLOB, which contains a Livelink Assoc object. One of its properties, SQL, holds the query logic. Note that this SQL may include replacement variables (e.g., %1, %2), which means it may not be immediately executable or usable without resolving those placeholders.
Answered by Fayaz S T 5 months ago
Your Answer
Latest Topics
💬 0 Answers • 👁️
36 Views
💬 0 Answers • 👁️
128 Views
💬 0 Answers • 👁️
174 Views
💬 0 Answers • 👁️
167 Views
💬 0 Answers • 👁️
168 Views
