Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 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
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Apex Tutorial Sample doesn't seem to produce expected results

Hello,
I'm using Apex 19 on an 18.C database. I followed a tutorial https://docs.oracle.com/en/database/oracle/application-express/18/tutorial-mobile-app-create/ . It is a good tutorial but a few things didn't seem to work correctly. I was wondering if I was doing something wrong. It was the third tutorial (Improving Navigation https://docs.oracle.com/en/database/oracle/application-express/18/tutorial-mobile-app-improve-navigation/#BeforeYouBegin) that seemed to give me trouble. I found two issues:
1) Minor issue. The SQL for the List View on the Home Page seemed to be wrong. It referenced pages 4, 8 and 10 but the directions in the modules 1 and 2 seem to create pages 10, 13 and 16. The corrected SQL (I updated script.txt) seems to enable the List View to navigate to the correct page:
select 'Open Projects' as label,
count(*) as value,
'f?p='||:APP_ID||':10:'||:APP_SESSION||':::' as url
from sample$projects
where completed_date is not null
union all
select 'Upcoming Milestones' as label,
count(*) as value,
'f?p='||:APP_ID||':13:'||:APP_SESSION||':::' as url
from sample$project_milestones
where due_date > sysdate
union all
select
'Incomplete Tasks' as label,
count(*) as value,
'f?p='||:APP_ID||':16:'||:APP_SESSION||':::240' as url
from sample$project_tasks
where nvl(is_complete_yn, 'N') = 'Y'
2) The second problem is a little more tricky to me. The WHERE clauses in that same SQL doesn't seem to actually filter any data. When I arrive at the three individual reports, I see ALL data, as though the three WHERE clauses were not there. When I run an individual SELECT statement in SQL Developer, it filters the data as expected. It doesn't seem to work inside the Mobile App. Is there something special I have to do to enable the WHERE clauses?
3) The count(*) as value function doesn't produce a count for the List View.
Thanks for checking.
Phil
Answers
-
After looking at the sample again, I figured out how to display the Count(*) on the List View report. The field identified in the report's SQL (VALUE in this case) can be selected for the Supplemental Information Column or the Counter Column on the report definition. That will place the count underneath the label or next to the Expand button. The reports continue to display all rows. The Where clause in the List View does not affect what is displayed in those linked reports.