|title|Create scenarios
|owner|JohnDoe
|created|2005/07/15

.invisible { display:none }

<COLUMN> <OPERATOR> VALUE

[{FormSet form='defectform' 
   status='DefectOpened' 
   title=''
   fields='title,priority,owner,status,defectid'
   page='Defect'}]

[{FormOutput form='defectform' handler='TasksFormHandler' populate='handler'}]
[{FormOpen form='defectform'}]
|Title:   |[{FormInput type='text' name='title' size=60}]
|Priority:|[{FormSelect name='priority' value='Critical;High;*Medium;Low'}] 
|Owner:   |[{FormSelect name='owner' value='*-;NascifAbousalhNeto;JohnDoe'}] 
|[Status|DefStatus]:  |[{FormSelect name='status' value='*DefOpened;DefFixed;DefVerified;DefExternal;DefDeferred;DefNofix;DefNobug;DefFuture'}]
|SAS Defect|[{FormInput type='text' name='defectid' size=60}]

Please enter a free form description of the problem here.\\
Please add log messages and instructions on how to reproduce the bug when available.\\
You may use [WikiMarkup|EditPageHelp], but no HTML:

[{FormTextarea name='description' rows=20 cols=80}]\\
[{FormInput type='submit' name='x' value='Create Defect' size=100}]  (Please click only once!)
[{FormClose}]

----
Back to [Defects].

[{TasksQuery  select='title,created,priority,owner,status,defectid' 
  from='Defect' 
  where 'status~(DefRequested)|(DefOpened)'}]

[{TasksQuery  select='title,source.title,release,status' from='OpenIssue' where='release=2.1'}]

[{TasksQuery select='category,title,status'  
  from='WorkItem' 
  where='owner=NascifAbousalhNeto,status~(WiCreated)|(WiAssigned)|(WiStarted),created>2006/01/01}]

Great idea (I have to try it yet, but in theory it looks great). I especially like the SELECT/FROM/WHERE syntax, which I don't find nerdy, and seems perfectly understandable by MereMortals as well.

I just wish you use a more appropriate name. I guess Tasks comes from the original intent, but as you demonstrate in your examples it can be used for generic page queries.

As far as the name is concerned, MetadataPageQueryPlugin, or QueryPlugin, would be a better, although the latter is already taken (by a badly named plugin too : QueryPlugin

Note that there are several complementary ways to build page indexes, see discussion on IdeaWikiLinksThroughXPATHIncludingSubPagesSupport, I wish all of that be unified and standardized in the engine core.

--JDuprez

--Jerome Duprez, 24-May-2006

---

Thanks Jerome. You guessed right, "Tasks" is the original intent. Note that this is actually a family of plugins: one to create the pages, one to aggregate them, and one to create the page indexes. The last one is called "TasksQuery", which is close to your suggestion.

-- NascifAbousalhNeto

---

This looks nice, but I can't get it to work. Can someon give an example of how the TasksFormHandler is integrated with a form?

--AnonymousCoward, 22-Jun-2006

I added examples and screenshots. Let me know if you still have problems.

---

Is there a wiki running with this plug-in where one could try it out (like a SandBox)?

-- another AnonymousCoward

Unfortunately no, I have it running on an corporation intranet. Sorry. Let me know if you need help with the installation instructions.

---

I was wondering how can I plugin in the system date to the(CURRENT_DATE)in the query like the below example.

Plugin insertion failed: Could not find plugin TasksQueryPlugin insertion failed: Could not find plugin TasksQuery

--AnonymousCoward, 08-Sep-2006

---

Sorry the above comment sample should look like this:

[{TasksQuery  select='title,created,priority,owner,status,defectid' 
  from='Defect' 
  where 'created=(CURRENT_DATE)'}]

--AnonymousCoward, 08-Sep-2006

In the current version there is no way to do this. But it would be possible by adding wiki variable evaluation of the arguments, or JavaScript evaluation support. I will look into adding something like that in the next version.

--NascifAbousalhNeto, 9/9/2006

---

--GregP, 02-Oct-2006

Can you please attach the wiki pages utilised to generate the screenshots. Seems like I can get everything working except for the TasksAggregate

I have it like

[{TasksAggregate page='ProjTask'}]

Where ProjTask is from

[{FormSet form='todoform' 
   status='taskOpened' 
   title='ProjTask'
   fields='title,priority,owner,year, month, day,type,status,type,taskid'
   page='ProjTask'}]

[{FormOutput form='todoform' handler='TasksFormHandler' populate='handler'}]
[{FormOpen form='todoform'}]
. 
.
.

It seems there is a problem with TasksAggregate in the latest version. I will provide a fix in the next update. Sorry about that.

--NascifAbousalhNeto, 03-oct-2006

---

Hello, how to edit record after creation? The way of manual page editing is minimal enougth but the edit form is more sutuable. --Alexander Sokolov, 26-Oct-2006

Hi Alexander, currently that is the only way. I agree that an edit form would be better, and in the future it might be possible taking advantage of the BrushedTemplate metadata editor. But for now, you have to manually change the table. Using the WikiWizard table editor might make it a little cleaner.

--NascifAbousalhNeto, 27-Oct-2006

---

Hello NascifAbousalhNeto once again, Thank you very much for this so usefull plugin! --Alexander Sokolov, 29-Oct-2006

---

--GregP, 16-Feb-2007

As per my question on 02-Oct-2006, when will TasksAggregate be working. You mentioned that you would be updating. Guess you've been busy? :)

Thanks

Wow, time flies. I have - both been busy, and distracted by too many ideas on what to do next with this plugin and ImageGen - including some form of integration. Sorry. I will try to come up with something soon (weeks, not days). -- NascifAbousalhNeto, 15-Feb-2007

---

--ScottParker, 21-Feb-2007

OK, I've tried and tried but can't get any of the TasksPlugins to work. I get the following error in the JSPWiki log:

Wiki.jsp - Plugin failed while executing: java.lang.UnsupportedClassVersionError: org/nascif/jspwiki/plugin/tasks/TasksFormHandler (Unsupported major.minor version 49.0) at java.lang.ClassLoader.defineClass0(Native Method)

I'm stumped. Can anyone help me figure out what's going on and how to fix it?

Hi Scott, I believe this is a JDK version issue. I compiled the plugins with version 5.0. Are you running on a JRE/JDK version 4? -- NascifAbousalhNeto, 22_Feb-2007

OK, I'm not even smart enough to be a Java newbie, but here's what I get on my Windows XP machine when I run 'java -version':

C:\Program Files\Support Tools>java -version
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode, sharing)

I'm thinking that means I'm running version 5. I'm running under Tomcat 5.0. I'd be grateful for any suggestions to get me unstuck. -- ScottParker 05-Mar-2007

I think (not 100% sure) that Tomcat will use the contents of your JAVA_HOME over what is in your classpath. Try typing:

C:\Program Files\Support Tools>%JAVA_HOME%

in the command line. -- NascifAbousalhNeto, 07-Mar-2007

Thanks for the suggestion. Here's what I get when I do 'echo %JAVA_HOME%':

C:\Program Files\Support Tools>echo %JAVA_HOME%
C:\usr\local\bin\jdk1.5.0_11

Still not working. However, I installed the TasksPlugin on my Mac and it works fine. Didn't have to do any environment variable acrobatics. Lesson? Use a Mac. -- ScottParker 13-Mar-2007

---

--AlexanderSokolov, 12-Mar-2007 Hi Nascif,
I developed some changes and additional plugin for your great TasksPlugin.
Please see AlexSokolovTasksPlugin for details.
Best regards,
Alex.
--AlexanderSokolov, 01-Aug-2007
Hi Nascif,
Please see my comments on AlexSokolovTasksPlugin.
Of course, I'll glad help to improve your Greate plugin.
Best Regards,
Alex.