4 Replies Latest reply: Nov 2, 2012 9:46 AM by Brian Jeffries-Oracle RSS

    How to run report from context menu using XML Extensions?

    dz_r
      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.