question Re: Creating FIX Script which can be re-used for different values in Developer forum

Creating FIX Script which can be re-used for different values

HT — Fri, 10 Jan 2020 10:28:13 GMT

Hi,

i have created a fix script to modify fields in the Incident table.

In some cases we need to add values after creation.

Managed to create the fix script, but the values i need to supply to the Incident table contain a different INC id everytime i run the script.
Is there a way to make the script 're-usable' ... that is... Current when i use a new ID to search for and supply the values, i need to save the FIX Script, which results in a new version .. We will end up with a lot of versions this way.

Fix script looks like this:

(number and u_external_relation_id will both have different values everytime i need to run the script)

updateIncident();

function updateIncident(){
try{
gs.info('Fix Script started for updateIncidentID');
var inc = new GlideRecord('incident');
inc.addQuery('number=INC0014924');

//inc.setLimit(10);
inc.query();
if(inc.next()){

inc.u_external_relation_id = 'INM000000452354';

inc.setWorkflow(false);
inc.update();
}
gs.info('Fix Script Ended for updateIncidentID');

}
catch(ex){
gs.info('Exception is: ' + ex);
}
}

Thanks

Re: Creating FIX Script which can be re-used for different values

Kalaiarasan Pus — Fri, 10 Jan 2020 10:35:13 GMT

You can create a system property and use it in your fix script. This way you would just need to update the property everytime before running the fix script.

Re: Creating FIX Script which can be re-used for different values

Goran WitchDoc — Fri, 10 Jan 2020 10:36:27 GMT

Hi,

You could easily just have it as a function in a script include and call it from scripts - Background. Script include could look something like this:

And then in the scripts - Background you just call it like this:

new incUtils().updateExtRel('INC0014924','INM000000452354')

//Göran
Feel free to connect:
LinkedIn
Subscribe to my YouTube Channel
or look at my Book: The Witch Doctor’s Guide To ServiceNow

Re: Creating FIX Script which can be re-used for different values

Goran WitchDoc — Fri, 10 Jan 2020 10:37:03 GMT

Just remember updating a system property will flush the whole cache each time you update it 😃

//Göran
Feel free to connect:
LinkedIn
Subscribe to my YouTube Channel
or look at my Book: The Witch Doctor’s Guide To ServiceNow

Re: Creating FIX Script which can be re-used for different values

Kalaiarasan Pus — Fri, 10 Jan 2020 10:39:49 GMT

There are pitfalls in every approach but yes the script include approach is better in terms of reusability.

Re: Creating FIX Script which can be re-used for different values

Goran WitchDoc — Fri, 10 Jan 2020 10:44:48 GMT

absolutely, just wanted to mention it since many people don't know about the cache flush when you change values 🙂

//Göran
Feel free to connect:
LinkedIn
Subscribe to my YouTube Channel
or look at my Book: The Witch Doctor’s Guide To ServiceNow

Re: Creating FIX Script which can be re-used for different values

HT — Thu, 16 Jan 2020 20:39:30 GMT

Great,

didn't think about using a function for this.

Thanks!

Re: Creating FIX Script which can be re-used for different values

apjohn2 — Mon, 05 Aug 2024 13:22:33 GMT

I did not know this and as I have some junior developers on the team whom I've seen do this for various use cases I am happy to know this now! Thank you Goran!

Re: Creating FIX Script which can be re-used for different values

Goran WitchDoc — Mon, 05 Aug 2024 17:40:50 GMT

It's inspiring to see that things like this still hold true. 😀