CODEWITHSUNDEEP
oracle-apex
Faezeh_Ebrahimi
Faezeh_Ebrahimi

Reputation: 69

Report Queries in data dictionary APEX

I want to get the query text of a report query in a application from APEX data dictionary .

The problem is when I select from this tables : ( WWV_FLOW_SHARED_QUERIES ) , it only returns the first query that I've written in that report query . I mean in simple words if I change the report query , the changes won't be applied on the QUERY_TEXT column of WWV_FLOW_SHARED_QUERIES table . Also it won't display all queries of a report query .

Am I selecting from a wrong table for this approach ? Which table from APEX data dictionary should I select ?

Ant help would be appreciated Thanks.

Upvotes: 0

Views: 30

Answers (2)

Koen Lostrie
Koen Lostrie

Reputation: 18695

the wwv_flow* tables are the internal APEX tables. You should not use those for anything. Instead use views starting with APEX_* . These views will always match the current APEX version. They are documented in the view APEX_DICTIONARY. That view has one row per column in each view. Column "0" has the info about the view.

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 143053

I'm querying apex_application_page_regions. For example:

SELECT region_name, 
       region_source
  FROM apex_application_page_regions
 WHERE     workspace = 'NAME_OF_YOUR_WORKSPACE'
       AND application_id = 100
       AND page_id = 560

Upvotes: 0

Related Questions