This discussion is archived
4 Replies Latest reply: Nov 2, 2012 7:46 AM by bjeffrie RSS

How to run report from context menu using XML Extensions?

dz_r Newbie
Currently Being Moderated
I have found an example how to run SQL command from context menu:

<items>
<folder type="TABLE">
<name>UserDefined ContextMenus</name>
<item TYPE="TABLE" reloadparent="true">
<title>Create SYNONYM</title>
<prompt type="check">
<label>PUBLIC</label>
<value>PUBLIC</value>
</prompt>
<prompt>
<label>NEW SYNONYM NAME</label>
</prompt>
<sql>
<![CDATA[CREATE #0# SYNONYM  #1# for "#OBJECT_OWNER#"."#OBJECT_NAME#"]]>
</sql>
<help>
This action create a SYNONYM (optionally public) for the selected table.</help>
<confirmation>
<title>Confirmation</title>
<prompt>SYNONYM "#1#" for "#OBJECT_NAME#" has been created.</prompt>
</confirmation>
</item>
</folder>
</items>
</prompt>


But instead of executing SQL command I need to show result page of report based on SELECT statement.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points