Update Derby Jira Report XML VTI to access more fields

• Key: DERBY-4014
• Type: Improvement
• Status: Closed
• Resolution: Fixed
• Priority: Minor
• Assignee: Kathey Marsden
• Reporter: Kathey Marsden
• Component/s: Demos/Scripts
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.1.1

Description

It would be useful for backporting reports and other Jira analysis reports to have the apacheVanillaReport access more of the item fields. Some missing are assignee, version, fix version, resolution,

Comments

[Kathey Marsden]

Attached is a patch to add
 "reporter", "assignee", "resolution", "created", "updated", "votes", "version", "fixVersion"

to the VTI

[Rick Hillegas]

Hi Kathey. Looks good to me. I applied the patch and then ran the demoFileVtis.sql script. One thing I noticed is that the fixVersion elements are all concatenated, so the sample row that is selected by the apacheVanillaReport vti has a fixVersion field which looks like this: "10.2.2.110.3.1.410.4.0.0". You might want to think about how you want to handle that. Here are two suggestions:

1) Write a wrapper function that reformats that field for you. So you would write a query something like this:

select myFormatter( s."fixVersion" )
from table( "apacheVanillaLogFile"( 'file:///opt/DerbyTrunk/java/demo/vtis/data/ApacheServerLog.xml' ) ) s

2) You could also change XmlVTI.parseRow() to do something other than just concatenate identically named child elements. E.g., insert a space between the text contents of those children.

[Kathey Marsden]

Thanks Rick for looking at the patch. I think option 2 sounds better. Do you think a space is most appropriate or would it be better to have a more distinguishable characters like ^ for separation?

[Rick Hillegas]

Hi Kathey. Since you're actively using this vti, I think you should do what makes sense to you. Later on, for extra credit, we could change the XML vtis to take a second argument: the desired separator character. So the user would type a query like this:

select myFormatter( s."fixVersion", ' ' )
from table( "apacheVanillaLogFile"( 'file:///opt/DerbyTrunk/java/demo/vtis/data/ApacheServerLog.xml' ) ) s

[Kathey Marsden]

Attached is an updated patch for this issue. It has the same changes from the initial patch plus it:
- Changes XMLVTI.parseRow to separate multiple occurances of the same tag with spaces.
- Changes derbyBuild/JiraConnector.java to take an optional all parameter to export all the issues. This is a bit out of the scope of this issue but will be useful for taking bug reports with the VTI. I will commit this tomorrow unless there are comments.