tag:blogger.com,1999:blog-5874979429188093780.post1771097596280867492..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Applying View Criteria from Application ModuleAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-5874979429188093780.post-60358508006162794502017-03-11T07:22:28.647+01:002017-03-11T07:22:28.647+01:00Hello Andrejus,
What is way out, if I don't wa...Hello Andrejus,<br />What is way out, if I don't want to apply the same view criteria everytime I run the VO. Is it possible to declaratively add this specific view criteria only when I need it?Smithhttps://www.blogger.com/profile/08449913375910624870noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-7837103199323911832014-06-27T13:20:07.180+02:002014-06-27T13:20:07.180+02:00I can't see why would this not work. Your erro...I can't see why would this not work. Your error message is too generic.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-87474389227548835822014-06-27T13:12:41.371+02:002014-06-27T13:12:41.371+02:00Hi Andrejus...I am rudra
I tried this scenario in ...Hi Andrejus...I am rudra<br />I tried this scenario in my system, But i'm getting this exception..<br /><br />oracle.jbo.SQLStmtException: JBO-29114 ADFContext is not setup to process messages for this exception.<br /><br />please help..<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-31772420766414015672014-03-11T12:13:21.178+01:002014-03-11T12:13:21.178+01:00Hi Andrejus,
I am trying a similar task, Could you...Hi Andrejus,<br />I am trying a similar task, Could you please guide. <br />In a jspx page I have two sections, left hand side showing Department ADF Form with Navigation , and on other side I want the Employee table to be displayed with department id filtered based on the left hand side<br />Department Navigation.. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75325040032249921832013-06-11T11:40:23.379+02:002013-06-11T11:40:23.379+02:00Hi Andrejus,
Based on your post i have created tw...Hi Andrejus,<br /><br />Based on your post i have created two named criterias for my view. One is for Search By Id and the other is for Search By Date. I want the View query to be executed based on: first named criteria if Id is not null and second named criteria if Date is not null but, not both at a time. So, how and where are we deciding which named criteria to be executed?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-18739597128672679692012-01-17T06:55:04.565+01:002012-01-17T06:55:04.565+01:00Hi Andrejus,
Could you please tell me how to pass...Hi Andrejus,<br /><br />Could you please tell me how to pass a list as bind variable.<br /><br />If suppose in the below query I need to give the three values from Bind Variable.<br /><br />SELECT * FROM emp where empno in (7369,7566,7782);<br /><br />Please give your suggestions.<br /><br />Thanks,<br />DineshDineshhttps://www.blogger.com/profile/12807106991492651175noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-28646476347575557072011-03-07T11:20:11.551+01:002011-03-07T11:20:11.551+01:00Hi,
This is different. Here we just enforce VO in...Hi,<br /><br />This is different. Here we just enforce VO instance to be filtered always.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75521338946474068552011-03-07T11:06:51.660+01:002011-03-07T11:06:51.660+01:00I guess using the groovy method is better. We have...I guess using the groovy method is better. We have done it similarly but sometimes ADF directly refreshes the iterator bound to the VO, without giving our code a chance to set bind values. Resulting in error as that bind variable is required.dApple Grewhttps://www.blogger.com/profile/17329934024949552966noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75969255746812558062011-02-18T18:34:26.764+01:002011-02-18T18:34:26.764+01:00Ok, so this is pretty cool. How would you recommen...Ok, so this is pretty cool. How would you recommend doing this when calling it from a autoSuggestBehavior tag?<br /><br />Thanks,<br /><br />JetJoe The Jethttps://www.blogger.com/profile/07744315366378276609noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-27617459242486043082011-02-18T18:26:31.319+01:002011-02-18T18:26:31.319+01:00Happens, no worry ;)
AndrejusHappens, no worry ;)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-41535454373529221952011-02-18T18:22:57.628+01:002011-02-18T18:22:57.628+01:00Ok, I didn't realize that ensureVariableManage...Ok, I didn't realize that ensureVariableManager is an inherited method!<br /><br />My bad.<br /><br />Thanks for the reply!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-41461507013651940822011-02-18T07:40:57.853+01:002011-02-18T07:40:57.853+01:00Anonymous, where you see the heck? :) You can sear...Anonymous, where you see the heck? :) You can search for ensureVariableManager, its easy.<br /><br />Look into EmployeesViewImpl.java available in Model project. <br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-31445024610938933792011-02-18T01:52:40.216+01:002011-02-18T01:52:40.216+01:00What the heck is ensureVariableManager????
I can&...What the heck is ensureVariableManager????<br /><br />I can't find it at all in the zip file. :(Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-62273567728319375872010-05-20T22:16:22.490+02:002010-05-20T22:16:22.490+02:00Andrejus,
I am getting a class cast exception mes...Andrejus,<br /><br />I am getting a class cast exception message when I am using my view criteria for "ADF Query panel with table". <br /><br />Here are the steps I followed:<br /><br />1. created a view criteria on a view object<br />2. all binding parameters are set to be optional<br />3. all binding parameters are set as Strings<br />3. Dragged the view criteria as a query component (ADF Query panel with Query table) on to the design layout<br /><br />and the error when I clicked the Search button is:<br /><br />javax.el.ELException: java.lang.ClassCastException: oracle.jbo.common.ViewCriteriaImpl cannot be cast to oracle.jbo.ViewCriteriaRowAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-29831998298412967882010-03-31T17:09:53.593+02:002010-03-31T17:09:53.593+02:00Hi Marcus,
Yes, agree. I have blog post about thi...Hi Marcus,<br /><br />Yes, agree. I have blog post about this case as well - http://andrejusb.blogspot.com/2010/01/storingaccessing-objects-in-adf-bc.html<br /><br />Thanks,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-71711052564659562812010-03-31T16:12:18.237+02:002010-03-31T16:12:18.237+02:00Well done Andrejus....
using default values fo...Well done Andrejus....<br /><br /> using default values for binding variables is a nice feature too;<br /><br /> you could use groovy expression like...<br /><br /> adf.userSession.userData.idCenarioCompMarcos Ortegahttps://www.blogger.com/profile/18203027394870687269noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-84308166875316268202010-03-31T12:01:14.157+02:002010-03-31T12:01:14.157+02:00Hi Timo,
I agree with you, but its how it works c...Hi Timo,<br /><br />I agree with you, but its how it works currently.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-59601007414182593142010-03-31T08:33:33.205+02:002010-03-31T08:33:33.205+02:00Nicely done Andrejus,
the only part I don't ag...Nicely done Andrejus,<br />the only part I don't agree to is calling executeQuery each time the setter of the bind variable is called.<br />While this is suitable if you only have one variable it is not wise to do so if your criteria has i.e. three variables. This would cause three executions of the query.<br />In this case I expose a method in the application module or the VO and call this.<br /><br />TimoTimohttps://www.blogger.com/profile/02235677287513180235noreply@blogger.com