Problem/Motivation

When clearing index data this module will currently delete and recreate the collection table, but it does not do the same thing for tables that get created when you add a multi-value filterable attribute.

Steps to reproduce

Create an index, specify a multi-select entity relationship field as a filterable attribute and then index data. Then clear index and see that the collection table has been wiped clean (and all field columns removed too) and then check the table for the multi value filterable attribute, the table will still be there and will still have all of it's data.

Proposed resolution

1. Ensure that the deleteFromCollection actually deletes using the id field rather than drupal_entity_id since that is what it should be filtering against.
2. Ensure that "relation tables" are properly deleted/cleared when the main collection is.

Remaining tasks

User interface changes

N/A

API changes

N/A

Issue fork ai_vdb_provider_postgres-3538122

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

febbraro created an issue. See original summary.

febbraro’s picture

febbraro commented
Issue summary: View changes

codebymikey made their first commit to this issue’s fork.

codebymikey opened merge request !9

codebymikey’s picture

codebymikey commented
Version: 1.0.0-alpha2 » 1.0.x-dev
Issue summary: View changes
Status: Active » Needs review

Provided a MR addressing the issues with multivalue fields not being created/deleted accordingly (the additional fields are only created when you resave the search api index rather than immediately after clicking "Clear all indexed data").