Mixed Bag of Tips, Tricks & Resources - Part 1
The ServiceNow developer community has a vast combined knowledge with lots of developers who are willing to share what they’ve learned (and more joining the ranks every day). Over the years, I have benefited from their blog posts, YouTubes, and various other content.
Every once in a while, I stumble across information that catches my attention, information I think might come in very handy someday.
So, I’m sharing a collection of some of them here:
How to do massive, slow, database operations (create, update, delete) efficiently in ServiceNow with event-driven recursion: https://snprotips.com/blog/2018/10/11/how-to-do-massive-slow-database-operations-without-slowing-down-your-instance
Controlling the sys_updated timestamp or sys_updated_by fields on a record: https://www.youtube.com/watch?v=7Jnrftc66pI
The fastest way to find if at least one record exists, using Gliderecord + setLimit() + hasNext()
https://community.servicenow.com/community?id=community_blog&sys_id=1a5a7fdedb34c850d82ffb2439961996A function that will let you check the SQL query and its performance. gs.trace() appears to be yet another undocumented function in ServiceNow that will let you see the SQL query that the system generates whenever we issue a query() command
https://community.servicenow.com/community?id=community_blog&sys_id=2a007dd0db7648d414d6fb24399619fdWhich instance do you use to pull your production update sets from? A Twitter thread with some interesting discussions: https://twitter.com/rfedoruk/status/1164999558394470400?s=20
Auto-tag records - configuring tags to assign automatically.
Here is the docs link:https://docs.servicenow.com/bundle/quebec-platform-user-interface/page/use/common-ui-elements/concept/administering-tags.html#t_ConfigureTagsToAssignAutomatic
Credit goes to Michael Moody for his YouTube post: https://youtu.be/63Re9wJwZnA
For more, check out Part 2 of my Mixed Bag of Tips, Tricks and Resources