tag:blogger.com,1999:blog-5874979429188093780.post8901294807725841138..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: Yes-No Check Box in Query CriteriaAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-5874979429188093780.post-62673260759406247322016-10-02T12:48:35.450+02:002016-10-02T12:48:35.450+02:00I have updated download link, try now.
AndrejusI have updated download link, try now.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-50631105659643568882016-10-02T11:19:53.699+02:002016-10-02T11:19:53.699+02:00HI
can I have this application getting page not f...HI <br />can I have this application getting page not found error upon clicking the clink to download the application.<br /><br />Thanks for your time.rahulnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-56122505950849949112014-04-04T12:55:40.727+02:002014-04-04T12:55:40.727+02:00Hi Andrejus,
I have a acquirement to give auto sug...Hi Andrejus,<br />I have a acquirement to give auto suggest behavior to an attribute which is in a query criteria. There are so many posts on how to do it in forms. <br />Is there a way to do this?<br /><br />Regards!<br />Sameera Anonymoushttps://www.blogger.com/profile/05470530743766145986noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-84713709880171493032013-08-26T10:34:20.373+02:002013-08-26T10:34:20.373+02:00Great post Andrejus,
I was implementing a similar...Great post Andrejus,<br /><br />I was implementing a similar usecase. but the only difference is in my case, the YES_NO column is saved as a Number datatype(Oracle DB). And, the possible values it can have are 1/0.<br /><br />But when i deploy and go to the JSF page, i am getting following Error.<br /><br />JBO-25009. Can not convert from java.lang.Boolean to oracle.jbo.domain.Number.<br /><br />I Guess, there is some type cast exception because, i made YESNO view attribute to be rendered as checkbox.<br /><br />Also, i did not understand the importance of LOV . In my case i did not have LOV in my project.<br /><br />How to get rid of this JBO-25009 error.<br />venkathttps://www.blogger.com/profile/00843466183782288186noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-81111408713428061592013-05-07T16:34:27.949+02:002013-05-07T16:34:27.949+02:00Hi Andreju,
I've the same use in my applicatio...Hi Andreju,<br />I've the same use in my application. When I check the check box first, its setting the value for the first time. If I uncheck, its not unchecking the value in the model. How can I get the new values for these check boxes in my VOImpl.<br /><br />Thank You.SreeVardhanhttps://www.blogger.com/profile/05183761522401306048noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-64411297909591191022011-04-20T22:19:57.377+02:002011-04-20T22:19:57.377+02:00Unfortunately I dont have MySQL installed, not usi...Unfortunately I dont have MySQL installed, not using it.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-4050411350508069962011-04-20T22:04:00.430+02:002011-04-20T22:04:00.430+02:00That's correct. I used your project in Oracle...That's correct. I used your project in Oracle Express Edition and it works (though I had to fix a line of code)<br /><br />In MySQL, you can search with the Yes-No check box, and the correct rows are returned. If you type in a RegionName to search again, no rows are ever found. RegionName HAS to be blank, which pretty much leaves the Check Box as the only way to search which isn't very useful.<br /><br />Ideas?Raynoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-84646959938607749002011-04-20T21:46:36.886+02:002011-04-20T21:46:36.886+02:00Hi,
I correctly understood, it doesnt work only o...Hi,<br /><br />I correctly understood, it doesnt work only on MySQL?<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-78752267129106898852011-04-20T21:37:51.848+02:002011-04-20T21:37:51.848+02:00Hi Andrejus,
I know this post is a bit old, but h...Hi Andrejus,<br /><br />I know this post is a bit old, but hopefully you'll get notification of this comment.<br /><br />I tried to implement this in MySQL to varying success.<br /><br />The checkbox search seams to work, but it apparently breaks the rest of search capability. For example, you can't search w/ RegionName. I verify that you still can search w/ RegionName using an Oracle db (at least w/ Express Edition).<br /><br />I reimplemented your example in MySQL (slight variations in names as when I tried to just refactor to MySQL it didnt work), and is available here<br /><br />https://rapidshare.com/files/458398787/YesNoSearchBox_MySQL.zip<br /><br />I've also included a sql file to build and populate the region table.<br /><br />Thanks.Raynoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-22095032106294423692010-08-17T17:57:50.227+02:002010-08-17T17:57:50.227+02:00Hi, you can't add it inside af:query.
Andreju...Hi, you can't add it inside af:query.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-40338866587544720542010-08-17T13:34:49.431+02:002010-08-17T13:34:49.431+02:00Hello Andrejus,
I´m using adf query component...
...Hello Andrejus,<br />I´m using adf query component... <br />How can i add a LOV with autosuggest behaviour inside the query criteria?<br /><br />Thanks.<br />RegardsUnknownhttps://www.blogger.com/profile/16146431216047249860noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-48212385635022692182010-05-28T02:26:09.017+02:002010-05-28T02:26:09.017+02:00hello
I wonder if you can do reports in adf11ghello<br />I wonder if you can do reports in adf11gAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-72225678656988865412010-05-26T12:32:34.205+02:002010-05-26T12:32:34.205+02:00Thanks a lot Andrejus :)Thanks a lot Andrejus :)Tilhttps://www.blogger.com/profile/17336556642731696725noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-61159231993356779732010-05-26T11:05:52.913+02:002010-05-26T11:05:52.913+02:00Yeah, its possible to do this programmatically. I ...Yeah, its possible to do this programmatically. I have new blog post scheduled for this weekend, where I will describe it ;)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-55446892119129128872010-05-26T10:50:44.309+02:002010-05-26T10:50:44.309+02:00Thanks Andrejus :) this is good
i want to ask you...Thanks Andrejus :) this is good <br />i want to ask you last question <br />is it possible to call reset <br />every time i enter the viewall page to get all rows or no.<br /><br />thanks a lot <br />Great post .Tilhttps://www.blogger.com/profile/17336556642731696725noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-596697000122957682010-05-26T10:38:37.858+02:002010-05-26T10:38:37.858+02:00Hi Til,
I see - initial specification was incorre...Hi Til,<br /><br />I see - initial specification was incorrect :)<br /><br />Yes, I reproduced your problem. In order to fix it, make sure you have Query Automatically = false and additionally in viewAllCountriesPageDef - make sure CountriesVOCriteriaQuery is set with TrackQueryPerformed=Page. It will not bring any results, when returning from Edit region.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-49778713634946147472010-05-26T10:19:44.813+02:002010-05-26T10:19:44.813+02:00Thanks Andrejus :)
but the senario i want you to ...Thanks Andrejus :) <br />but the senario i want you to make is that <br /><br />1)keep all fields empty<br />2)press search this will make to view all queries<br />3)type Brazil in the country name<br />3)press ass button <br />4)press cancel<br /><br />this will filter the criteria with Brazil<br /><br />:)<br /><br />this is the trickTilhttps://www.blogger.com/profile/17336556642731696725noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-16845765901443344662010-05-26T09:30:13.665+02:002010-05-26T09:30:13.665+02:00Hi,
I tried with Query Automatically = false and ...Hi,<br /><br />I tried with Query Automatically = false and automatic query is not happening on your sample, its why I suggested it :)<br /><br />I type Brazil, press Add New Row buttons - another task flow region is opening with Edit and there I press Cancel - no automatic query.<br /><br />Please check better ;)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-74550376896332255172010-05-26T09:19:12.565+02:002010-05-26T09:19:12.565+02:00Thanks Andrejus but this problem happens also when...Thanks Andrejus but this problem happens also when i <br />set Query Automatically = false<br />i tried this <br />the solution i guess will help this is not the better but i have i want to call Reset button in search criteria before i enter the page <br />How could i do this .Tilhttps://www.blogger.com/profile/17336556642731696725noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-31155919925005229852010-05-26T09:09:48.183+02:002010-05-26T09:09:48.183+02:00Hi Til,
I checked your sample app. You need to se...Hi Til,<br /><br />I checked your sample app. You need to set Query Automatically = false UI Hint for View Criteria in View Object. Then it will query only when user will press Search.<br /><br />Its always recommended to use Query Automatically = false for better performance.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-35815779610478181852010-05-26T08:36:20.046+02:002010-05-26T08:36:20.046+02:00Thanks Andrejus but i think you didn't got wha...Thanks Andrejus but i think you didn't got what i mean <br /><br />This is the example that i mean <br /><br />http://rapidshare.com/files/391651084/HRTest.rar.html<br /><br /><br />If you Run the index page you will get the table will all rows in it.<br /><br />if you write brazil in the Country Name and didn't Press Search but go to edit page .<br />when you came back from the edit page to the main page you will see that it will filter the table in the viewAll page with brazil i don't want that <br /><br />i want when i cam back from the edit page if i didn't press search the page remains as i left it.<br /><br />i wish you run this example and test this .<br />thanks in advance.Tilhttps://www.blogger.com/profile/17336556642731696725noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-68443162818251539272010-05-25T21:40:59.544+02:002010-05-25T21:40:59.544+02:00Hi,
You will get blank edit page, if you go to ed...Hi,<br /><br />You will get blank edit page, if you go to edit with doing query first - iterator will be empty.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-69100976809446526472010-05-25T11:44:21.193+02:002010-05-25T11:44:21.193+02:00Hi Til,
Its clear now, I will look into it and wi...Hi Til,<br /><br />Its clear now, I will look into it and will post update, probably tonight.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-4095053408264252852010-05-25T10:51:45.985+02:002010-05-25T10:51:45.985+02:00hi Andrejus ,
i have two jsff pages on task flow
v...hi Andrejus ,<br />i have two jsff pages on task flow<br />view page and edit page <br /><br />the view page have search criteria <br /><br />when i write some thing in the search criteria and didn't press search and go to the edit page <br /><br />when i came page to the view page from the edit page by pressing back button the search criteria in the view page is executed with the values in it .<br /><br />i want when enter the view page if the search criteria have values in it not to be executed untill i press search .<br /><br />if this is not clear i can make example and send to u .<br /><br />thanks in advance.Tilhttps://www.blogger.com/profile/17336556642731696725noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-44897034636736843832010-05-25T09:59:36.415+02:002010-05-25T09:59:36.415+02:00Sounds like too many requirements, can you explain...Sounds like too many requirements, can you explain more simple? :)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.com