Issue #3538122 by codebymikey: Clear index data properly for collection and relation tables

• Also ensures that only the correct collections are picked up.
• When the search api index is cleared, it will ensure the api fields are also created.

Closes #3538122