Find Duplicate fx_price records and Discover which record should be kept/Deleted - Support and Troubleshooting

Find Duplicate fx_price records and Discover which record should be kept/Deleted Summary There should always be only one fx_price record where the fields id, table and field are the same value

This is a script that can be used to determine the stored database value of the record and which fx_price record should be kept and which should be deleted if you have 2 duplicates

This will only consider records that the parent is null as multiple records can exist for multiple currency type

Release All

Instructions //Populate the variables tbl and fld with the table and field you wish search

//Replace with the table

//replace with the field

var tbl = ' '; var fld = ' '

var fxp = new GlideAggregate('fx_price'); fxp.addEncodedQuery('table=' + tbl + '^field=' + fld + '^parent=NULL'); fxp.addAggregate('COUNT'); fxp.addHaving('COUNT','=','2'); fxp.groupBy('id'); fxp.query() while (fxp.next()) { gs.print(fxp.id + ' => ' + fxp.getAggregate('COUNT'));

var dbval = new GlideAggregate(tbl); dbval.addQuery('sys_id',fxp.id.toString()); dbval.addAggregate('SUM',fld); dbval.setGroup(false); dbval.query(); while (dbval.next()) { gs.print('Stored Database Value: ' + dbval.getAggregate('SUM',fld)); var amount = parseFloat(dbval.getAggregate('SUM',fld)).toFixed(4).toString();

Related Links This script is limited to only search 2 values