Export Definition with a related list condition?

[Marlyse]

Hi 

I want to set up an export definition with a condition on a related list. => like I can do on a report (see printscreen). Exactly this Condition Iwould like to define in the export definition.  

But in den export definition I can't find the related list condition? What am i doing wrong? 
I cant use the "schedule" function in the report, because the export-excel  must be put on a filer and the anyway the file would be to big to be sent by email. 
Thx for any ideas and help. 

[Community Alums]

Hi @Marlyse ,

The trick here is to right-click on the filter within the related list and select "Open in Window". Once the related list is in a new window it can be exported.

You will need to re-create the filter you right-clicked on after you open in new window. The key here is to make sure all of the necessary fields are exposed in the new window. I found this out when exporting in Discovery. One of the unexposed fields turned out to be a critical part of the filter.

There is another way but it is a customization that may affect upgrades! Implement with caution : Enabling Related List Exports in ServiceNow - ServiceNow Guru

[Marlyse]

Hi Sandeep
Thank you for your comments/help. Unfortunately, I didn't quite understand everything. Could you possibly make a few print screens of the individual steps? I did not understand how to bring the two tables back together (ts_query_kb and Knowledge Use). I don't need just one record, i need all records of the day whith the  matching condition  Sorry, I am not a developer....I am "only" a report admin 🙂

[Marlyse]

Hi 

Finally i found quite an easy workaroud to solve my problem: i created a Database View with no left join. So the new Database view represents only records on the ts_query_kb table which have also a relation to the kb_use table. 
In the export-definition I the select the new Database View. 🙂