question Unable to view extended fields on reports although available for reporting in Platform Analytics forum

Unable to view extended fields on reports although available for reporting

Irston Antao — Mon, 15 Jun 2020 10:51:01 GMT

Hi,

I am trying to add an extended field Overview [Incident] to a report created against Problem task by dot walking Problem task -> Problem -> Parent -> Overview [Incident]. As shown below i was able to select the field for reporting but on clicking Save or Run, the field doesn't show up on the report and is automatically eliminated from the Selected fields list.

Below is the generated report without the Overview field.

Not sure why this is happening is it a bug or am i missing out on a property.

Regards,

Irston

Re: Unable to view extended fields on reports although available for reporting

Ankur Bawiskar — Mon, 15 Jun 2020 11:15:06 GMT

Hi,

So you are saying in List layout of Problem Task you are able to get that field but not in reporting?

can you try to enable this property once and check? this you may need to create if not found

glide.ui.list.allow_extended_fields -> true

It worked fine for me in Reporting as well

Sample Date is on Incident Table and showing in Report

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

Regards
Ankur

Re: Unable to view extended fields on reports although available for reporting

Irston Antao — Thu, 18 Jun 2020 04:56:09 GMT

Hi Ankur,

Thank you for your reply.

The property has already been enabled glide.ui.list.allow_extended_fields has been enabled on our instance.

The field that i am referring to is a HTML field, are you able to perform the same action on an extended HTML field like Overview?

Regards,

Irston

Re: Unable to view extended fields on reports although available for reporting

Ankur Bawiskar — Thu, 18 Jun 2020 07:02:17 GMT

Hi,

Did you verify for other field type such as string or date

Regards
Ankur

Re: Unable to view extended fields on reports although available for reporting

Irston Antao — Thu, 18 Jun 2020 07:21:52 GMT

Hi Ankur,

I just tested and infact none of the extended fields are getting added at this point, somehow it seems to me that the issue is intermittent. Is there a limit to the number of fields that a report can list ? I even took an excel export and the case is the same, I am not able to get those fields.

Any leads on this issue can help .

Regards,

Irston

Re: Unable to view extended fields on reports although available for reporting

Ankur Bawiskar — Thu, 18 Jun 2020 09:23:50 GMT

Hi,

can you try to clear instance cache using cache.do and then logout and login again

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Re: Unable to view extended fields on reports although available for reporting

Bhagyashri Sort — Thu, 18 Jun 2020 09:48:55 GMT

Hi,

Please refer below link,hope this might helpful to you.

https://community.servicenow.com/community?id=community_questi on&sys_id=b67ceaffdbd55f80fc5b7a9e0f96196c

Make it correct and helpful.

Thanks

Bhagyashri Sorte.

Re: Unable to view extended fields on reports although available for reporting

Irston Antao — Mon, 13 Jul 2020 16:23:57 GMT

Turn out this is a known error with NewYork Patch 7 https://hi.service-now.com/kb_view.do?sys_kb_id=9d46eea5db8150d4190dfb2439961925