u/FilmDowntown1145

How to translate reference field display values based on user language?

I have a reference field " License type" pointing to "cmdb_sw_license_calculation" table that has 14 records with name being the display value in english

I want to keep the same records/sys_ids, but display the name depending on the user's language, for example:

EN: By CPU cores

FR: Par cœurs CPU

etc

is there a correct way to do this ? Thank you

u/FilmDowntown1145 — 8 days ago

How to read Excel header row server-side in ServiceNow?

We want to validate the header row of an uploaded Excel file server-side before processing the import, to make sure the right template was used.

GlideExcelParser is not defined in Transform Map scripts or Scripts-Background. Any other way to do this? Thanks

reddit.com
u/FilmDowntown1145 — 3 months ago

Broke my list table with SN Utils dotwalk field

I made a mistake and added an incorrect dotwalking field to view in the list with SN utils and personalize list and now list headers load but no rows show and personalize list gear no longers opens even view options dont show

Anyone has encountered this and was able to solve it? Thank you

reddit.com
u/FilmDowntown1145 — 3 months ago

Custom view disappears from menu after selecting default view

Hello,

In the workspace of vulnerability manager, i have a custom view for a table (sn_vul_app_vul_entry). The view shows up fine in the menu but as soon as the user clicks "default view", the custom view option disappears. Only way to get it to show again is by setting system preference by admin but again it's disappears if the user select the default view.

Anyone know how to keep the custom view always visible in the menu regardless of what the user select?

Thank you

reddit.com
u/FilmDowntown1145 — 3 months ago

I'm doing some tests in the instance and I would like to know if you know any cases when the imported file triggers the state: C****omplete with errors" I already tried using a file with the wrong format, empty coalesce field, empty mandatory field or reference value but I only get the state "Complete" and skipped/ignored rows in the import set rows. Thanks in advance

u/FilmDowntown1145 — 3 months ago

Hey,

Quick question on ServiceNow reports:

I have a report using Average of Age closed (MTTR) grouped by Configuration item
By default it sorts descending (highest first), which is fine.

But I need the opposite → lowest MTTR first (ascending).

I tried adding a sort field, but it only lets me pick non-aggregated fields, not the average value.

How do you sort a report by an aggregated value in ascending order in ServiceNow?

Am I missing something or is there a workaround?

Thanks!

reddit.com
u/FilmDowntown1145 — 4 months ago