Scriptrunner to display external DB value

[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?

[Martin Bayer _MoroSystems_ s_r_o__ · Accepted solution]

@jeff singler is it the complete script? I guess you need to process the results properly, something like

sql.rows('SELECT [VEHICLEID] , [CURRODOM] FROM [FUELMASTER].[dbo].[VehicleCK] where [VEHICLEID] like '%{issue.summary}').each { row -> log.error(row.CURRODOM) }

 I just pust logging function to test what value is logged. Can you try this approach?

[jeff singler]

Thank you for your help, I ended up going a completely different route to achieve this but I will need sometime in the far future to do writes to a DB with Scriptrunner so I will be back at this at some point.