Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
customise interactive report add spatial filter operations

659067
Member Posts: 11
Hi there,
I am currently doing a project in APEX involving spatial data. I am interested to know if it is possible to extend the existing interactive reports to include spatial filters / operators. I have seen on this page: http://dpeake.blogspot.com/2008/03/advanced-interactive-reports.html that you can make 'links' to interactive reports, so the parameters the user provides can be used in the 'custom' interactive query.. but the question for me is how to include the required SQL in the statement that apex executes. Also, how to modify the form interface in the UI for building the filter. An example SQL might be something like this:
-- select everything from table 1 within 100 meters of the specified feature in table 2
SELECT t1.record_id, t1.field1, t1.field2
FROM table1 t1, table2 t2
WHERE t2.record_id=2 and SDO_WITHIN_DISTANCE(t1.geometry, t2.geometry, 'distance=100 unit=meter') = 'TRUE';
Why do i want to include this in the interactive report stuff ? well i like the idea of the applied spatial filter being listed alongside the others with the ticks that can be enabled/disabled, and i'd rather all the filters be presented in one place. Later, a map should show the subset of the records after all the (non)/spatial filters are applied.
I have some vague idea that maybe i should be using a column that is a function accepting parameters (maybe using a view?) to hide the spatial stuff from apex, but i thought i'd ask if anyone has done anything like this before and has any tips.
cheers,
-i
I am currently doing a project in APEX involving spatial data. I am interested to know if it is possible to extend the existing interactive reports to include spatial filters / operators. I have seen on this page: http://dpeake.blogspot.com/2008/03/advanced-interactive-reports.html that you can make 'links' to interactive reports, so the parameters the user provides can be used in the 'custom' interactive query.. but the question for me is how to include the required SQL in the statement that apex executes. Also, how to modify the form interface in the UI for building the filter. An example SQL might be something like this:
-- select everything from table 1 within 100 meters of the specified feature in table 2
SELECT t1.record_id, t1.field1, t1.field2
FROM table1 t1, table2 t2
WHERE t2.record_id=2 and SDO_WITHIN_DISTANCE(t1.geometry, t2.geometry, 'distance=100 unit=meter') = 'TRUE';
Why do i want to include this in the interactive report stuff ? well i like the idea of the applied spatial filter being listed alongside the others with the ticks that can be enabled/disabled, and i'd rather all the filters be presented in one place. Later, a map should show the subset of the records after all the (non)/spatial filters are applied.
I have some vague idea that maybe i should be using a column that is a function accepting parameters (maybe using a view?) to hide the spatial stuff from apex, but i thought i'd ask if anyone has done anything like this before and has any tips.
cheers,
-i
This discussion has been closed.