Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

page item (date picker)

progMay 4 2013 — edited May 7 2013
I have added a date picker to my report . and in the report source I've added a where clause to filter the report as per the selected date(which is one of the columns in the table) but there is nothing shown.
where DATE =:P23_DATE

when I remove the where clause all the records appear and when I return it ..nothing there.
can someone help me?

Edited by: Beena-IT on May 4, 2013 7:19 AM
This post has been answered by Howard (... in Training) on May 4 2013
Jump to Answer

Comments

Philip Sommer
Answer

Hi Yogesh,

Take a look at the Cookbook example for the router at https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=corerouter&demo=module
Setting up the new router should be fairly similar to the old one.
I implemented the login screen in my application as follows. (Don't know if this is best practise, but it works.) This is also very similar to the router example above.
Create a oj-module element in your main/index HTML to switch between login and content screens/modules.
During application startup - e.g. in your root viewmodel constructor - configure the router paths for login and content. Default should be login.
Check the login status of the user. If login is valid, directly navigate to content; Else stay on the login page.
(Optional) If you have more than one content-screen/module you may want to return your user to the one he last visited (if the login is still valid). In this case, I made a simple extension to the OJ CoreRouter which keeps track of the last routing state in the SessionStorage. I then simply restore the cached state.

image.png
Obviously, you will need to change this for the GoogleAPI, e.g. the validateToken() call would need to be replaced/changed.

Kind Regards,
Philip

Marked as Answer by user525840 · Sep 1 2022
John JB Brock-Oracle

As usual, Philip is correct. The CoreRouter is not that much different from the older ojRouter, and the methods used for actual Login integration are the same.

user525840

Thank you John and Philip.
I will try to implement this logic in my application.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 4 2013
Added on May 4 2013
#apex-discussions, #date, #item, #page
3 comments
128 views