tag:blogger.com,1999:blog-8677649049588007585.post4945465204668472643..comments2018-02-07T03:29:21.897+00:00Comments on PL/SQL Challenge: Final beta test for PL/SQL Challenge 2.2Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-8677649049588007585.post-9806156988209269092012-04-19T12:45:20.341+01:002012-04-19T12:45:20.341+01:00Thanks, Kim, I will look into that.Thanks, Kim, I will look into that.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-1675535947638748562012-04-19T11:41:38.907+01:002012-04-19T11:41:38.907+01:00Regarding the auto-complete:
Viewing the HTML sou...Regarding the auto-complete:<br /><br />Viewing the HTML source of the login page shows the input form with these parameters:<br /><br />&lt;form action=&quot;wwv_flow.accept&quot; method=&quot;post&quot; name=&quot;wwv_flow&quot; id=&quot;wwvFlowForm&quot; autocomplete=&quot;off&quot;&gt;<br /><br />autocomplete=&quot;off&quot; tells the browser, that it should not remember what previously has been typed in the inputs. With autocomplete on, the browser remembers, so that next time you can just type the first letter or two and you get an automatic dropdown picklist where you can select what you typed previously in that input.<br /><br />Maybe it is an attribute of the form in Apex whether to generate the HTML form with autocomplete off or on?Kim Berg Hansenhttps://www.blogger.com/profile/06491635470794828550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-41867905049762161622012-04-13T19:24:47.913+01:002012-04-13T19:24:47.913+01:00Yes, unplayed (and closed) practices will be autmo...Yes, unplayed (and closed) practices will be autmoatically removed.<br /><br />Regarding your idea for a &quot;dynamic self test&quot;, very interesting idea. I will add that to our ER list for the future. <br /><br />Autocomplete: I am sure there is more we could do here, and I will also add that to our ER list.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-14794218731944705712012-04-13T13:06:57.362+01:002012-04-13T13:06:57.362+01:00Steven,
1. I sent you an email with a document at...Steven,<br /><br />1. I sent you an email with a document attached with screenshots (you must have received it by now).<br /><br />2. Sometimes, when I navigate to the plsql challenge site my loginname is filled in as Iudith also wrote, but sometimes it is not. It is not only a matter of how my browser reacts, because when I log in into my webmail, my username will appear when I type in a letter. I don&#39;t know if it is possible in apex to get this going. What I do know is that it is possible to accomplish an autocomplete list based on the contents of a column, especially if you use version 4.1 or higher. <br />Well, we will see what the result will be.<br /><br />Kind regards,<br /><br />MargaMarganoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-56193939879534485692012-04-11T19:42:23.926+01:002012-04-11T19:42:23.926+01:00Hello All,
Regarding Marga&#39;s question about Au...Hello All,<br />Regarding Marga&#39;s question about Auto-complete:<br /><br />My browser always shows me the e-mail address already filled in<br />on the Login page. I think it is a direct result of having cookies enabled in the browser.<br />I even did not use the &quot;Remember me&quot; for having this done,<br />which would probably mean to remember the password as well.<br /><br />It is not exactly the same as the Auto-complete, which would mean that you enter the first letter(s) only and have the others filled out automatically, but I think it is exactly what you need if you are the only one playing from the same browser.<br />If several people use the same browser, then probably the cookie will always remember the last one used.<br /><br />Regarding the self-practice quizzes:<br />As far as I understand, when you create a self-practice you also choose a time limit within which you are supposed to take the quizzes. Does this mean that at the end of this time your self-practice would be automatically deleted ?<br /><br />Could it be that further, even if not in this release, we could<br />build a &quot;dynamic&quot; self test whose parameters only will be preserved indefinitely (under a custom name of our choice), while the quizzes list itself will be generated/optionally refreshed on demand each time when you ask for it, like for example:<br />&quot;Show me all the advanced quizzes of the last quarter&quot;.<br /> <br />All the new features are great indeed, a fantastic work !<br /><br />Thanks a lot &amp; Best Regards,<br />Iudithiudithhttps://www.blogger.com/profile/04905902445036068357noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-89688023219252134832012-04-11T13:59:13.708+01:002012-04-11T13:59:13.708+01:00Marga,
1. Before you choose the feature (and whe...Marga, <br /><br />1. Before you choose the feature (and where it shows you the number of quizzes per feature), you also select the amount of time since you originally took the quiz. The default is a month. It is possible that all 5 of those were within the date range. So two things here: <br /><br />a. we should add logic to show numbers next to features that reflect the exclusionary date period (but I don&#39;t think that will be in place for the release).<br /><br />b. it could be a bug. Could you please send me an email (steven@stevenfeuerstein.com) with your email address used to log in to PL/SQL Challenge, and the specifics of your selections when setting up this practice?<br /><br />2. Auto-complete for login: I will look into it, but isn&#39;t this something that can be done by easily in your browser?Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-20432724757359359652012-04-11T08:23:03.585+01:002012-04-11T08:23:03.585+01:00First of all: nice work!
Some observations:
Pract...First of all: nice work!<br /><br />Some observations:<br />Practice:<br />1. I choose &#39;Quizzes never played&#39;, maximum number of quizzes = 2<br />I have chosen the features of the technology on which I would like to be quizzed and it showed there were 4 intermediate and 1 advanced in it.<br />When I finished the wizard I got the following error:<br />Error ORA-20000: Unable to Create Practice There are no quizzes for your practice. Please adjust your criteria. <br />2. How can I review the practice quizzes I have taken?<br />Login:<br />Is it possible to put auto complete on the field for username(email adress)?<br /><br />That&#39;s it for now.<br /><br />Marga.Marganoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-12966491125635929932012-04-05T18:06:28.836+01:002012-04-05T18:06:28.836+01:00One player asked for the following:
Enhance the L...One player asked for the following:<br /><br />Enhance the Library page as follows: 1. Allow players to search library by technology (topics tree), competitions (current view) or author. 2. Add indicators to the quizzes to show if there is an objection, discussion, etc. and the last date on which a comment was made.<br /><br />I have also been thinking for a while that the Library page needs work. But I am also concerned about &quot;jamming&quot; lots of information into the current interactive report on the Library page. <br /><br />So what do you think of the following: <br /><br />1. Add a selector at the top of the page for the technology of interest (PL/SQL, SQL, etc.) and also one for author, letting you focus your searches on quizzes by a particular person.<br /><br />2. Change from a single interactive report to a set of tabs:<br /><br />By Feature: click on this tab to select a feature from a tree (as you see in Practice and Quizbooks). Then click Next to see a report of all quizzes about that feature (or any feature below it in the tree). So you could, for example, check the &quot;Dynamic SQL&quot; feature and see quizzes related to dynamic SQL.<br /><br />Competitions: the current interactive report, focused on helping you see/check results of your answers to quizzes.<br /><br />Contested: shows you all quizzes for which a player has submitted an objection.<br /><br />Help Needed: shows all quizzes for which a player has submitted a request for help.<br /><br />Discussions: all quizzes for which there is a discussion posted.<br /><br />By breaking things up this way, each tab could show information that is relevant to that type of search.<br /><br />Looking forward to your feedback, SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-66152537543624715492012-04-05T17:19:10.157+01:002012-04-05T17:19:10.157+01:00We have added your chart request to our ER list.We have added your chart request to our ER list.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-57621546970522555162012-04-05T17:11:10.384+01:002012-04-05T17:11:10.384+01:00Similar to the existing version, when viewing an i...Similar to the existing version, when viewing an individual&#39;s profile, the graphs only present the first 12 months of activity, rather than the most recent 12 months and/or all activity if greater than 12 months, with no option for changing the date range or viewing all activity.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-80696814070787547382012-04-05T13:44:01.138+01:002012-04-05T13:44:01.138+01:00Most of plain text in Library, Question, Ranking n...Most of plain text in Library, Question, Ranking now has different font (&quot;Trebushet MS&quot; instead of former &quot;Tahoma&quot;) which, having the same font size, looks smaller but occupy more space. <br />Regarding code I now can not confirm any changing the font.Vitaliyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-87786908516539148222012-04-05T11:37:14.992+01:002012-04-05T11:37:14.992+01:00Iudith, great idea about a date range for the Quiz...Iudith, great idea about a date range for the Quizbook. We have added this (this is for Quizbooks by Competition).<br /><br />Vitaliy, could you please clarify your concern about text and code font sizes? Where is this happening? Can you zoom in, in your browser, to increase the font size?Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-55848793307672410452012-04-05T06:27:13.333+01:002012-04-05T06:27:13.333+01:00Plain text and code font sizes are less than in 2....Plain text and code font sizes are less than in 2.1. Rather, ones are too small :(Vitaliyhttps://www.blogger.com/profile/03394959689295703518noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-9108686321492830612012-04-03T18:46:16.364+01:002012-04-03T18:46:16.364+01:00Hello Steven,
I just made a first quick visit on ...Hello Steven,<br /><br />I just made a first quick visit on the beta-site, and I only can say a single word: AMAZING :) :) :)<br /><br />All what the PL/SQL Challenge developer team has accomplished<br />here is simply GREAT !<br />I can only express once again the frustration I feel by not having any experience with APEX development ... when I see so many exceptional features implemented, I have a feeling of &quot;well, maybe it is too late to start with a product that is already so mature ?&quot; , though , there is always a hope, at least theoretically :)<br /><br />I am sure it will take us some time to get familiar with all the nice new features, so just a few quick comments:<br /><br />1. As I understand from your answer to the previous post, <br /> the scoring for the competition itself will continue to be <br /> calculated in the same way, and this is ok.<br /> Together with this, I can only welcome extremely positively<br /> the idea of rewarding players for their overall participation<br /> on the web site.<br /> I do know very well how dedicated you should be for putting <br /> aside other things and committing yourself to the <br /> PL/SQL Challenge under its many aspects, and it could be<br /> really frustrating if, let&#39;s say it directly, no one remarks<br /> your endeavors if you are not ranked among the top leaders,<br /> so, I can only say &quot;Chapeau&quot; for this idea !<br /><br />2. Regarding the Quizbook feature, I would suggest a small<br /> addition that I suppose might be trivial enough <br /> to implement in comparison with the exceptional filtering<br /> already existing:<br /> For the Knowledge base option, if possible, to allow for<br /> simply filtering by a chosen period (From Date, To Date),<br /> that would allow us to create a Quizbook of ALL the quizzes<br /> played in a given period, in the same order as they were<br /> played, for our future possibility &quot;to re-live the life <br /> later !&quot;.<br /> Of course, such a date filtering can come in addition to the <br /> other existing ones or simply be used alone for a complete <br /> history book, in fact the best-seller that once I suggested !<br /><br />I am sure I will continue to praise further all the new features, I only need the time to dive deeper :)<br /><br />Cheers to the whole team, you can be really proud of your accomplishment !<br /><br />Thanks &amp; Best Regards<br />Iudith Mentzel<br />( a frustrated &quot;non-knower&quot; of APEX )iudithhttps://www.blogger.com/profile/04905902445036068357noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-24427652195448207382012-04-03T15:53:18.090+01:002012-04-03T15:53:18.090+01:00One player send the following feedback:
I have ju...One player send the following feedback:<br /><br />I have just checked beta site. There are a lot of good new features there. I will just mention some: practice, retaking quizes, quizbook and so on. What is not clear: trophy1, trophy2, 3 and 4 - what do all those trophies mean? Could not find explanation. <br /><br />And what I don&#39;t like So significant change in scoring... :( A lot of new ways to get points - some are doubtful to me. Week 100% - might lead to extensive cheating. 2 * Week 100% = Quarter 100% - not too equal Viewed Quiz Results - I hope only once? points for comments - might lead to cheating, when friends or colleagues will approve comment And what is most important - the competition will be less clear and transparent Example: you compete with somebody for the first place. Before final day you have advantage 100 points. You take the last quiz well and feel good. But tomorrow you might find yourself to be only the forth or in the tenth place. Other guys just published a lot of threads, comments, filled it their profiles and so on. What does it have in common with PL/SQL language and challenge?<br /><br />My response:<br /><br />We will add explanations of the trophies, but generally they reflect different levels of accomplishments.<br /><br />This players has strong feelings about a &quot;significant change in scoring.&quot; But there is no CHANGE in scoring, if by scoring you mean the daily quiz ranking. We have simply added another way to measure your participation on the website. Suppose you are strongly committed to improving your PL/SQL skills, but (a) you cannot manage to play every day and (b) you are not, and will not for a long time be, an expert. So you can make extraordinary efforts and yet your ranking remains high (though hopefully steadily improving over time).<br /><br />The activity points offers a way to demonstrate your efforts at improving your knowledge of PL/SQL and your expertise in writing PL/SQL programs, and they are not intended to be competitive, at least not in same way as the daily quiz (and other quiz) rankings. It&#39;s just like the points system at websites like Stack Overflow. You might not be able to rate very high in competitive play, but you CAN rate high in your engagement with discussions, with studying the knowledge available on the PL/SQL Challenge site, and so on.<br /><br />I hope this makes sense. I actually never thought that there would be anything objectionable about this.<br /><br />SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.com