tag:blogger.com,1999:blog-5742906279879067605.comments2023-03-22T10:10:34.716+01:00Oracle & APEX GeekeryChristian Rokitta ♠http://www.blogger.com/profile/07809391154664980631noreply@blogger.comBlogger117125tag:blogger.com,1999:blog-5742906279879067605.post-86521013024133892622021-03-15T12:26:06.761+01:002021-03-15T12:26:06.761+01:00can we use sql function to get min or max date. pl...can we use sql function to get min or max date. please share syntax if you could.Anonymoushttps://www.blogger.com/profile/16373553473943217310noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-70807492162945125272021-03-15T11:58:54.512+01:002021-03-15T11:58:54.512+01:00hi,
it is working fine but it icon goes to left af...hi,<br />it is working fine but it icon goes to left after using this code in dynamic action. how to resolve thatAnonymoushttps://www.blogger.com/profile/16373553473943217310noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-40588995846590690692019-10-29T23:55:43.516+01:002019-10-29T23:55:43.516+01:00lovely just when i need it most...thanks bro.lovely just when i need it most...thanks bro.Koloohttps://www.blogger.com/profile/00436850485796854701noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-8069834396299700632018-07-27T10:24:17.380+02:002018-07-27T10:24:17.380+02:00For those of you that are using apex accounts i us...For those of you that are using apex accounts i used the following workaround for the Remember Me option. <br /><br />I created and after authentication process that used apex_util.set_preference to remember the username and ip_address when Remember me was checked. I had to modify the Clear cache process on the login screen to clear only the username and password an leave the Remember me item untouched. The variable user for set_preference was sys_context('USERENV','ip_address') which retrieved the pc's IP. <br /><br />apex_util.set_preference('AUTOLOGIN',:APP_USER,sys_context('USERENV','ip_address'))<br /><br />This way i could use APEX_UTIL.GET_PREFERENCE('AUTOLOGIN',sys_context('USERENV','ip_address')) to read the username before header in the login page. <br /><br />If APEX_UTIL.GET_PREFERENCE('AUTOLOGIN',sys_context('USERENV','ip_address')) was not null the i'd log in the user with some dummy credentials (user Demo, password Demo) that i had previously created and had no authorization. <br /><br />So now i had my user logged in with some dummy credentials. <br /><br />The only thing left was to create another before header application process to set the current application user to the value already stored in the AUTOLOGIN preference:<br /><br />wwv_flow.g_user:=APEX_UTIL.GET_PREFERENCE('AUTOLOGIN',sys_context('USERENV','ip_address'));<br /><br />I'm not sure how safe this method is but for my use-case it worked like a charm. Maybe someone else would find it useful. <br /><br />Sorin Apalaghiehttps://www.blogger.com/profile/02057190577161795045noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-9397134165498246212018-05-31T14:12:30.503+02:002018-05-31T14:12:30.503+02:00Thanks for very useful feature I was searching for...Thanks for very useful feature I was searching for the same. Now I have implemented successfully as per your given instructions but it's not working on those pages which have checksum required. Can you please guide or suggest any workaround.<br /><br />I'm using Apex 5.1 with ORDS 3.0.12<br /><br />Thanks once again. Waqarhttps://www.blogger.com/profile/00723110095271731044noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-65984237296304860752016-07-28T13:30:50.612+02:002016-07-28T13:30:50.612+02:00Yes. but 1 flaw what I see is value is not preserv...Yes. but 1 flaw what I see is value is not preserved on next day It shows current day's date by default. Date picker should disable past dates but that should be while selecting new date.<br />If I am setting any date which is not older than today, then next day it should show me same date that I had chosen for that record unless I select any further date.Anonymoushttps://www.blogger.com/profile/08753674839107496637noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-14460356700127879762016-06-27T07:06:57.797+02:002016-06-27T07:06:57.797+02:00Thank you so much for publishing your notes 😀Thank you so much for publishing your notes 😀Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-25551302251816565892016-06-10T03:34:08.035+02:002016-06-10T03:34:08.035+02:00Thanks for the reply. Somehow it can display the i...Thanks for the reply. Somehow it can display the image but with all employee with the same image. Is there anyway to pass the id from the query? Yeah sure, after I finish the chart, I will show to you. N DESIGNhttps://www.blogger.com/profile/00554964286159862634noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-33475732065382552382016-06-09T10:27:43.514+02:002016-06-09T10:27:43.514+02:00Hi,
You just need to modify the List Template and...Hi,<br /><br />You just need to modify the List Template and facilitate the #IMAGE# attributes in your template definition. Next use the image columns in your list's query (see the query help).<br /><br />I haven't tested this with images instead of text yet. If the formatting breaks, you might need to adjust a bit of the CSS.<br /><br />If you are able to show, I would like to see you result.<br /><br />Regards,<br />ChristianChristian Rokitta ♠https://www.blogger.com/profile/07809391154664980631noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-60881588843159614352016-06-09T04:32:46.512+02:002016-06-09T04:32:46.512+02:00hye, can I know how to display image of each emplo...hye, can I know how to display image of each employee in the chart? I really hope you can replyN DESIGNhttps://www.blogger.com/profile/00554964286159862634noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-65720940383950552052016-05-13T14:18:31.562+02:002016-05-13T14:18:31.562+02:00Hi Olivier,
Yes, it does. In fact, the demo is ru...Hi Olivier,<br /><br />Yes, it does. In fact, the demo is running on apex.oracle.com, which is APEX 5.<br /><br />Cheers,<br />ChristianChristian Rokitta ♠https://www.blogger.com/profile/07809391154664980631noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-82923063331716397132016-04-28T16:11:40.573+02:002016-04-28T16:11:40.573+02:00Christian
Does this trick also work with APEX 5.0...Christian<br /><br />Does this trick also work with APEX 5.0Olivierhttps://www.blogger.com/profile/01752771015371980892noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-82255428298366192822016-03-12T22:59:21.910+01:002016-03-12T22:59:21.910+01:00it is very good news about apex 5it is very good news about apex 5Anonymoushttps://www.blogger.com/profile/11910320392295302376noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-1389602557383926342016-02-03T16:58:01.960+01:002016-02-03T16:58:01.960+01:00Hi Christian,
Thank you very much for your fast a...Hi Christian,<br /><br />Thank you very much for your fast answer. I understand what you said now ! WW_FLOW_CUSTOM_AUTH_STD.LOGOUT is deprecated in Apex 5.0, instead I used successfully APEX_AUTHENTICATION.LOGOUT. I am faced with another problem. Page 0 does not seems to be executed. After signing in, checking 'remember me' , I close the page. I run the application from the Designer, I land on page 1, the Home page (which is Public). I can see the cookie 'REMEMBER_ME' is still there. But I am not automatically signed in. I need to sign in again if I want to access to pages requiring authentification. It seems that page 0 (which is page number 0 in my application) does not seems to be executed.<br /><br />Best regards.<br />ChristianChristianhttps://www.blogger.com/profile/16502351919898781103noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-51275739143829378282016-02-02T11:24:25.966+01:002016-02-02T11:24:25.966+01:00Hi Christian,
Well, you "signed out". T...Hi Christian,<br /><br />Well, you "signed out". This explicitly removes the "Remember Me" cookie. This is nessesary, in case you want to sign in as a different user or just "really" want to sign out.<br /><br />The Remember-Me works if you just close the browser, without singing off.<br /><br />I think this would be the behavior one would expect.<br /><br />Kind regards,<br />ChristianChristian Rokitta ♠https://www.blogger.com/profile/07809391154664980631noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-84087686597306723082016-02-02T09:43:44.692+01:002016-02-02T09:43:44.692+01:00Hi Christian,
I tried you demo on apex.oracle.com...Hi Christian,<br /><br />I tried you demo on apex.oracle.com. I signed in checking the box 'remember me'. Then I signed out. When I signed in again, I still get the authentication page with the 'remeber me' box not checked.<br />What is wrong ?<br />Thank you.Christianhttps://www.blogger.com/profile/16502351919898781103noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-9627187861551612292015-10-19T10:00:22.638+02:002015-10-19T10:00:22.638+02:00Hi Karen,
Keep in mind: this information is UNCON...Hi Karen,<br /><br />Keep in mind: this information is UNCONFIRMED!<br /><br />Cheers,<br />ChristianChristian Rokitta ♠https://www.blogger.com/profile/07809391154664980631noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-71503769368041756022015-10-16T17:34:33.087+02:002015-10-16T17:34:33.087+02:00Thanks Christian - great to hear, good to know for...Thanks Christian - great to hear, good to know for planning upcoming projects and migrations.Karenhttps://www.blogger.com/profile/10849355472384661874noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-84814685511842843952015-04-10T01:04:53.571+02:002015-04-10T01:04:53.571+02:00This approach is still usable in 4.2. But there ar...This approach is still usable in 4.2. But there are alternatives, like using the ORDS REST service to provide different (human and Search Engine friendly) URLs for APEX applications. Have a look at this presentation of mine, discussing this subject: http://www.slideshare.net/christianrokitta5/oracle-apex-urls-septimized-andChristian Rokitta ♠https://www.blogger.com/profile/07809391154664980631noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-6477843457742086962015-04-08T13:05:48.073+02:002015-04-08T13:05:48.073+02:00This was very helpful and straight forward, thanks...This was very helpful and straight forward, thanks Christian. Thumbs UpAnonymoushttps://www.blogger.com/profile/09258209632305069172noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-66381491788268990942015-04-08T13:04:46.681+02:002015-04-08T13:04:46.681+02:00This was very helpful and straight forward, thanks...This was very helpful and straight forward, thanks Christian. Thumbs Up.Anonymoushttps://www.blogger.com/profile/09258209632305069172noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-5132997701559152412015-01-27T04:50:13.053+01:002015-01-27T04:50:13.053+01:00Is this only valid for APEX 3.2 ? Can't we use...Is this only valid for APEX 3.2 ? Can't we use this for APEX 4.2 ?Thirohttps://www.blogger.com/profile/10265942917605181505noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-54353561526865634932014-08-20T12:42:53.147+02:002014-08-20T12:42:53.147+02:00Hi Jose and André,
The link was broken due to a s...Hi Jose and André,<br /><br />The link was broken due to a server migration. I fixed the URL and the CSS is available for download again.<br /><br />Cheers,<br />ChristianChristian Rokitta ♠https://www.blogger.com/profile/07809391154664980631noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-11492272250220027292014-08-12T18:24:11.695+02:002014-08-12T18:24:11.695+02:00hi, the file is not available for download anymore...hi, the file is not available for download anymore, how can I get the css?Andrehttps://www.blogger.com/profile/04157190234956911286noreply@blogger.comtag:blogger.com,1999:blog-5742906279879067605.post-53090420159105692972014-08-11T20:23:03.309+02:002014-08-11T20:23:03.309+02:00Hi, this is a very good solution, unfortunately na...Hi, this is a very good solution, unfortunately nav_imgemb.css patch seems to be unavailable. <br /><br />It will be repaired to download. <br /><br />Thanks,<br />Jose VergaraAnonymoushttps://www.blogger.com/profile/00285434554846331677noreply@blogger.com