tag:blogger.com,1999:blog-5874979429188093780.post4492387912829937184..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Oracle ADF Tuning: Preventing SQL Query Execution on Page LoadAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5874979429188093780.post-62084662717095959792016-06-25T08:18:09.452+02:002016-06-25T08:18:09.452+02:00Hi Andrejus,
I have one scenario could you help to...Hi Andrejus,<br />I have one scenario could you help to solve that.<br /> Start-Date End-Date <br />Record 1 02-Jan-16 01-Jan-17 CHANGEButton<br /> <br /> <br />Click On change button <br />userenter startdate&end date new start date new end date <br /> 02-Mar-16 05-Jul-16 <br /> <br />The pervious existing Record1 status becomes active=N we need to update below mention way <br /> <br /> New start date after user entered dates <br /> Start-date End-Date <br />Rec1 02-Jan-16 01-Mar-16 <br />Rec2 02-Mar-16 04-Jul-16 <br />Rec3 05-Jul-16 01-Jan-17 <br /> <br />How achieve this in java using stored procedure please help me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-55824119653217686172016-02-29T13:18:00.857+01:002016-02-29T13:18:00.857+01:00Hi Andrejus,
this works which is fine by me. For ...Hi Andrejus,<br /><br />this works which is fine by me. For the sake of curiosity and continuous improvement :), just wanna know whether after these years, this is still the best approach for such case.<br /><br />Best Regards, Pedro.Unknownhttps://www.blogger.com/profile/14189170988915055213noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-52075940078734707152013-08-25T14:47:45.782+02:002013-08-25T14:47:45.782+02:00No, is called once - this is task flow method call...No, is called once - this is task flow method call.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-90701366092921382912013-08-23T14:40:06.053+02:002013-08-23T14:40:06.053+02:00Hi your example is working but the initPage() meth...Hi your example is working but the initPage() methods is called twice,so its inserting two records in the viewObject so i cant perform other operations on the page like execute etc..<br /><br />Any idea.<br />Thanks<br />SyedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75697909143956758262012-04-24T04:02:13.729+02:002012-04-24T04:02:13.729+02:00continuation of my previous comment ....also forgo...continuation of my previous comment ....also forgot to add this ....<br />if I delete whatever I typed in the 'search' input box , it should also NOT display any data again ... <br />thanks a lot.Unknownhttps://www.blogger.com/profile/10245083485696167142noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-4824106570465253222012-04-24T03:55:55.069+02:002012-04-24T03:55:55.069+02:00Hi Andrejus,
I have a ViewObject Query table(s...Hi Andrejus,<br /> I have a ViewObject Query table(select * from table) which loads by default on page load on my .jspx page. <br />My use case is display nothing 'no data to display' (on table) on page load ... like you're inserting a blank row (which is also fine) but ONLY display data when I do a "Search" (i.e click on a 'search' button )(I have a ViewCriteria query which performs the search)<br /><br />I tried to apply your example on mine ...but all I could get to is i'm able to insert a blank row on page load (with your code) but after initial page load , I want to be able to display data after I perform a 'Search'Unknownhttps://www.blogger.com/profile/10245083485696167142noreply@blogger.com