Fields not visible on Export Definition

[ashy]

Hi All,

 I am new to servicenow and i have a requirement to schedule a report in export sets on "cmdb_rel_ci" table. Already there is a report on the same table, where they have selected all the required fields to be listed. The issue i am facing here is that if i try to look for the same field in export set, i am not able to see it in the "Available" slushbucket and the fields that are not visible are for eg.,child.storage type[storage device], child.chassis type [storage device], child.size bytes GB[storage device] etc.. I have used filter condition also.

Could anybody guide me on this? I really want to select those fields in export sets.Thanks in advance!

Best Regards,

Ashwini

[Ankur Bawiskar]

Hi Ashwini,

That is how the export definition behaves. Not sure for reports etc.

Did you confirm on which table the export definition is present and at what level the field is created parent/child.

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

[Ankur Bawiskar]

Hi Ashwini,

I do remember there is 1 system property which if enabled will show the child fields on parent table export definition.

System property: glide.ui.list.allow_extended_fields

set this to true and it should work.

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

[ashy]

Hi Ankur,

This property is already set to "True" and that is the reason i am able to see the fields in Reports. However not in "Export Definition". The table(parent) i am referring is "cmdb_rel_ci" and the child table i am looking is "Storage Device" and the fields of it. So, as per your comment,  the child table's fields will not be selectable in Parent table on Export Defintion. Please correct me if i am wrong. And is there anyway to achieve this?

Thanks,

Ashwini

[Ankur Bawiskar]

Hi Ashwini,

In my case how it worked is:

Consider I have export definition on Task table and there is a Sample Date field on Incident table.

When this property is set to true the Sample Date field will be shown on export definition fields.

When this property is set to false this field won't be shown up.

Also I think it might be working only for immediate child i.e. Task -> Incident

In your case table Storage Device doesn't have the Cmdb_ci as parent. It's parent is Configuration Item(cmdb_ci) and not cmdb_ci_rel so it won't work here on export definition.

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