Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inline Popup Region: Dynamic positioning on report data

fac586May 26 2022 — edited Jun 5 2025

I am working on an APEX 19.2 application with theme/style UT 1.4 Vita.
This features a "Search" page with a main region comprised of three subregions: two static groups of filters in the top row and an IR region below.
The IR contains a "Tasks" column showing a link button with a badge indicating the number of tasks associated with the IR row. When clicked, this opens an inline popup region with a simple classic report showing the relevant tasks. This all works fine, and I have created a similar demonstration on apex.oracle.com:
ClipboardFile.pngAs shown, the default template options for the inline popup region result in it being displayed in the centre of the page, whereas I would prefer it to be contextually positioned with a callout arrow pointing at the clicked "Tasks" button in the IR.
After a bit of searching I discovered that I had apparently solved this problem using custom code in a previous thread. However, whilst that approach worked (and continues to do so) with Cards reports and the after callout position, when using the above option with IRs the popup region and callout have a significant and unwanted vertical offset:
ClipboardFile.pngThe code used in the dynamic action is:

var projectId = this.triggeringElement.dataset.projectId,
    o = { autoOpen: true,
          parentElement: "#projects button[data-project-id=" + projectId + "]",
          callout: true,
          relativePosition: "above" };

$('#tasks').popup(o);

Am I missing something or doing something wrong?
Can anyone explain the offset positioning? Is it a bug? Can it be corrected?
Supplementary question: Can the maximum popup width of 720 pixels achievable through the existing template options be easily increased, or do I have to customise the region template?

Comments

Sdas-Oracle
You can do this from a SQL query using SEM_MATCH table function which allows you to specify a SPARQL graph pattern.
SEM_MATCH retrieves relevant data from the RDF store which can then be joined with one or more relational tables.

For more details on use of SEM_MATCH, please refer to documentation at:
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sdo_rdf_concepts.htm#CHDJACII
880207
Hi,

I am using Jena & SparQL. I am not sure if i can call SEM_MATCH query directly from Jena. As per my understanding Sparql gets converted to SEM_MATCH query.
As i am calling Sparql query using Jena, I want to use RDBMS table data also with sparql query in a single query.

If possible , kindly share an example , it would be of great help

Thanks and Regards,
Manish H
880207
Any view on above comment
Sdas-Oracle
Use of SPARQL from Jena does not currently allow access to relational tables. A workaround you may consider trying would be to first generate RDF triples from the relational tables and then try querying using SPARQL the original RDF data plus the RDF data generated from relational tables.
1 - 4

Post Details

Added on May 26 2022
3 comments
1,072 views