Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Mylyn/Incubator/Generic Industrial Connector"
(→Generic Task Structure to map to any SQl DB) |
(→Generic Query Structure to map to any SQL DB) |
||
| Line 35: | Line 35: | ||
There will be a Query window allowing (full text) selection on: | There will be a Query window allowing (full text) selection on: | ||
| − | + | - taskId : match a specific ID | |
| − | - taskId | + | - owner : match a known owner from a list |
| − | - owner | + | - summary : match a string in a description |
| − | - summary | + | - priority (as P1, P2, P3, P4 or P5) : match one or more priorities |
| − | - priority (as P1, P2, P3, P4 or P5) | + | - completed : match true or false |
| − | - completed | + | - completionDate (null is not completed) : match before, after and null |
| − | - completionDate (null is not completed) | + | - creationDate : match before, after and null |
| − | - creationDate | + | - dueDate : match before, after and null |
| − | - dueDate | + | - notes : match a string in a description |
| − | - notes | + | |
and possibly: | and possibly: | ||
Revision as of 06:36, 13 March 2008
This is a temp doc space for the generic SQL connector for mylyn.
Contents
Temporary SVN
svn://bugs.industrial-tsi.com/mylyn_gsc
Members
Maarten Meijer
Wim Jongman
Plan
Generic Task Structure to map to any SQL DB
These are mainly the fields from AbstractTask
- repositoryUrl - taskId - owner - summary - priority (as P1, P2, P3, P4 or P5) - completed - completionDate (null is not completed) - creationDate - dueDate - notes
Further more a generic Task can hold:
- a list of TaskComments and - a list of TaskAttachments.
But how?
Generic Query Structure to map to any SQL DB
There will be a Query window allowing (full text) selection on:
- taskId : match a specific ID - owner : match a known owner from a list - summary : match a string in a description - priority (as P1, P2, P3, P4 or P5) : match one or more priorities - completed : match true or false - completionDate (null is not completed) : match before, after and null - creationDate : match before, after and null - dueDate : match before, after and null - notes : match a string in a description
and possibly:
- in the list of TaskComments and - in the list of TaskAttachments.