Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

how to set filter condition into export set

BanuMahalakshmi
Tera Contributor

Hi,

BanuMahalakshmi_0-1788421639294.png

I have created a database view for Incident and Problem list exports.

The database view contains the following fields, which can be used in the export definition conditions:

  • Opened, Incident Resolved At, Problem Resolved At

My requirement is to export 25 months of data into the Snow Incident and Problem CSV file. The export should include any ticket that was either created or resolved within the last 25 months.

I have configured the filter conditions using Incident Resolved At and Problem Resolved At, but the export is not returning the expected data. pls let me know correction. thanks.

1 REPLY 1

Ankur Bawiskar
Tera Patron

@BanuMahalakshmi 

so you created database view by joining INC and PRB and then created export definition on that database view table

your image is not clear.

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader