I didn't know addEncodedQuery could be so DEADLY

If addEncodedQuery doesn't have a valid query string, ServiceNow will NOT stop the query. This could mean you query WAY more records than you intend. Scary proposition if you're doing updates or deletes on a table via script! Here we explore the damage that can be done, and how to prevent it.
API Docs for isValidEncodedQuery: developer.serv...#SGR-isValidEncodedQuery_S
Looking for #ServiceNow talent or opportunity?
🤝 Need coaching or mentorship? theduke.digital...
👑 Duke Digital Media sponsorships & consults: theduke.digital
👑 Write your resume like a KING: theduke.digital...
💥 My 1500+ subscriber ServiceNow mailing list: bit.ly/fedoruk
🔗LinkedIn: / rfedoruk
🎙️ CJ&TheDuke Podcast: feeds.transist...
💎Donations: paypal.me/robf...

[@robertthedukefedoruk5607]

Watch your other query methods too! .get() is risky as well! kzbin.info/www/bejne/janWq5aFaMZ-hqc If you want more technical ServiceNow content, check out my Toolbox playlist: kzbin.info/aero/PLkQDoKoP0MAP0gwpL2OEMZJzmm7t872th

[@aditya7428]

Great editing!

[@palekarakshay]

Oh wow, did not know isValidEncodedQuery existed !! And love the edit. Thanks

[@robertthedukefedoruk5607]

You're welcome. Technically I didn't know either until one of the guys on SnDevs slack was telling me about it. Game changer though.

[@mateobilandzija1847]

I love these Videos 😂😃 Fantastic content as always

[@robertthedukefedoruk5607]

Thanks Mateo! Shares are always appreciated!

[@user-sd1zp4kl6t]

Also, always do a dry-run that doesn't update anything but only outputs logs. but i know, this is a video about encoded queries. shorf ure, i mean surefor, i mean for sure

[@robertthedukefedoruk5607]

Truth! Dry runs are importnat

[@danielc.oderbolz8754]

Dear Duke Thanks a lot for this valuable video! I want to add one tiny thing: There is a property to control this: glide.invalid_query.returns_no_rows Set this to true to avoid this issue.

[@robertthedukefedoruk5607]

I'd argue its still a good idea to check the return. "Just return zero" doesn't mean your code knows what to do with that. Also, for the indie consultants out there, may not have the option to arbitrarily turn on properties.

[@danielc.oderbolz8754]

@@robertthedukefedoruk5607 Agreed that this is not a Panacea. But it might be easier to turn on a property rather than fixing all the code that does not check the validity of the encoded query. It's just an additional safety net.

[@robertthedukefedoruk5607]

kzbin.info/www/bejne/joLbi6GIrLCWrdU fixed

[@anakcloudifs5374]

hahaha 1:35