I didn't know addEncodedQuery could be so DEADLY

Подписаться 5 тыс.

Просмотров 2 тыс.

50% 1

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...

Опубликовано:

12 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@robertthedukefedoruk5607 Год назад

Watch your other query methods too! .get() is risky as well! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WxszcO3aKPE.html If you want more technical ServiceNow content, check out my Toolbox playlist: ru-vid.com/group/PLkQDoKoP0MAP0gwpL2OEMZJzmm7t872th

@aditya7428 Год назад

Great editing!

@palekarakshay 11 месяцев назад

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

@robertthedukefedoruk5607 11 месяцев назад

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!

@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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XQxZnRwKcws.html fixed

@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