I am in the process of upgrading DA for a customer and found that there are a large number of pending searches in various cases. As it is recommended to check for any pending searches, exports before upgrade and reject them, I am looking for a SQL query to bulk reject all pending searches, exports.
Better laten then never.. sorry saw this post only today.
As far as I know, there is no query available. It might be possible to do this, if it is only 1 setting in a database, but you need to be really sure which one. Sometimes it is better to perform these actions manually...