"omit_sys_original=" true Attribute significance on core_company table fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 07:53 AM
Hello All,
I see the ""omit_sys_original=" true" attribute present for core_company table fields revenue per year, profits and Market cap.
Could you please tell me what is the significance of this attribute and how it is being used. I tried to search it in servicenow docs but unable to get the documentation on this.
Your help is much appreciated.
Thanks,
Akshay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 08:17 AM - edited 07-01-2024 08:24 AM
Hi,
Seems you will need to create a case to find out. I have 5 fields on core_company with that attribute, all Currency type. It is not documented here:
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 09:01 PM
Hi Bert,
Yes there is no documentation. We are not able to query these fields from third party tool even we have provided certain roles to the authenticated user except admin.
Thanks,
Akshay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2024 10:07 PM
Hi @Akshay Bhoj ,
'omit_sys_original' can be set to true/false for Price and Currrency type field(s).
Jace documented: variable attributes
As currency/Price field involves more complex calculations in form of currency conversion rates on a regular basis in comparison to other generic attributes. So, by setting 'omit_sys_original' to true will avoid retrieving the original value of the field which will enhance the data processing and improve the performance.
So, all in all it looks like this attributes helps to reduce performance impacts for the currency or price field.
Mark this as Helpful / Accept the Solution if this helps
Mark this as Helpful / Accept the Solution if this helps.