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?
