× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2013-11-01T23:04:51Z  · last modified 2013-11-01T23:04:51Z

generated HTML - link from table page to sheet that can bring the table into view


Dev
Kin-Hong Wong
kin-hong
QA swissarmyknife(*)
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version Future

Here's a possibility to consider for a future release.

When we view the Table page for a specific table, the sheet link could send us not only to the sheet, but to the table within that sheet.

This would be very helpful for extremely large images with many tables in a sheet.

As a test, I came up with a hack on a report I already generated. This is super basic and doesn't take into account overlapping entity objects.

On the Sheet HTML page

1. in css give the image a z-index:1000

<img src='sheet_sheet 5.png' usemap='#sheet 5' style='z-index:1000'/>

2. create a transparent div that is of similar dimensions to the relevant table in the image, give it position:absolute, top and left coordinates close to the image map's coordinates for its linked area of that table, give that div a z-index:-1. 

<map name='sheet 5'>
<area style='outline:none' target='main' shape='rect' coords='555, 505, 686, 616' href='view_..Table_3.html' alt='Table_3' title='Table_3' >
</map><div style="z-index:-1;background:transparent;position:absolute;top:505px;left:555px;border:none 0px transparent;width:130px;height:109px;" id='table_3'>
</div>

 

3. give the div an id like id="table_3" so we can point to it from the link pointing to the sheet.

On the Table HTML page

4. on the table html page, where the link to the sheet exists, add #table_3 to the end of the link into that sheet

<h2>Sheet</h2>
<a href='sheet_sheet 5.html#table_3' target='main'>sheet 5</a>
 
This should send the browser to that table, scrolling horizontally and vertically to reveal the top left corner of that table. 
 
take a look at my similar screenshot

 

1 attachment

Issue #10679

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017