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:
- 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'
- 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?
- The count(*) as value function doesn't produce a count for the List View.
Thanks for checking.
Phil