Deleting data imports

[Former Member]

Currently there are lot of records of data imports in our system. ( System Administration ->  Import and Export Tools -> Import data )

Is it possible to delete data imports for some criteria. say records older than 1 year.

Please guide how it can be done.

Regards,

Ankur Goyal

[Former Member]

Hi Ankur,

you cannot delete the entries, however, you can restrict the display to only show the last couple of imports.

The query below will restrict to the last 90 days. You can also restric the query to only show 200 entries.

SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_IMP_ACTION_DATA_IMPORT WHERE CONTEXTID=<%CONTEXT(install.FileImportAction)%> AND ((<%TODAY%> - START_DATETIME ) < 90) <%ORDERBY%>

/Anita