scriptrunner script to display external DB value Edited

[jeff singler]

Hello,

    I am exploring a way to read from an external DB, locate a value that pertains to a name we store in the summary field.  For instance my MS SQL query and groovy would look close to this:

DatabaseUtil.withSql('fuel') { sql ->
sql.rows('SELECT [VEHICLEID] , [CURRODOM] FROM [FUELMASTER].[dbo].[VehicleCK] where [VEHICLEID] like '%{issue.summary}')
}

Then I would like to write the CURRODOM value to a custom field.

I can get data returned in general that looks like this (if I remove the where clause):

[[VEHICLEID:000000G1, CURRODOM:135874], [VEHICLEID:000000G2, CURRODOM:064523], [VEHICLEID:000000H9, CURRODOM:679841]......

I would like the CURRODOM number formatted to only be displayed as a number like 135874 in the custom field.

How can this be accomplished?