OpenText LiveLink - Retrieve content of a LiveReport from database query

How to query DTree (DataID) for the content of a LiveReport (retrieve the live report's sql 开发者_Python百科content)?

You can't get the actual output of the Report, as the Report needs to be run to generate the results, but you can return the SQL that it would use from the ExtendedData CLOB which contains a Livelink Assoc object, one of the properties in there is SQL, which contains the SQL - including Replacement variables such as %1 etc - so this may not actually give you usable SQL.