APEX 21.1.5
Hi, I'm trying to use the FOS - Tooltip plug-in. The page linked shows this example:
What appears to be happening is that when I hover over a row in an IR/IG I got a tooltip with info both in and out of the IR/IG.
I'd like to do the same thing. Specifically, I have a IG that references a temporary staging table. I want a tooltip that shows when the respective record was created, but that is on a different table that I would have to get with a SQL query. (And I don't want to save the created time field on the staging table if I don't have to.) The FOS document doesn't seem to specify how they went about this example in detail…
It says:
If the business requirement is more complex i.e. multiple columns have to be displayed, or custom styling is required, you can use the "HTML Expression" attribute to define the tooltip contents. Using #COLUMN# syntax you can substitute column values from your SQL results in the HTML code.
I did find the “HTML Expression” attribute specifically when “SQL” is selected as the source. However, I am not sure what the #COLUMN# syntax is (I did Google, but with respect to this I'm not sure how that would work). Toward the bottom of the page, FOS shows the settings for some of their examples but not for this one, apparently.
My question is how do I reference an element within my IG (say, “ORDER_ID”) to put into my query; how do I then specify the affected element (should be for every single row in my IG); and do I really need to do anything with HTML Expression?
Thank you!