Typesense Cloud Issue: Unable to Delete Documents by ID

Hello! 👋 I’m using typesense cloud and running into an issue deleting documents using the filter_by option. For whatever reason, I can’t seem to get it to work when filtering by the id field. The same syntax seems to work when I use a different field. Will post an example in the thread.

👋 What version of Typesense are you on?

v0.23.1

I just tried a simple example of adding a document and then deleting by the id field in the filter_by clause and it works for me. Can you please post a small reproduceable code snippet that I can try?

Yes, let me know if this helps!

   const collectionName = 'delete-test-collection';

    // create collection
    const schema: CollectionCreateSchema = {
      name: collectionName,
      fields: [
        { name: 'id', type: 'string' },
        { name: 'name', type: 'string' },
        { name: 'createdAt', type: 'int64' },
        { name: '.*', type: 'auto' },
      ],
      default_sorting_field: 'createdAt',
    };

    await this.client.collections().create(schema);
    const documents = [
      {
        id: 'a620b2c0-7b19-4d38-813c-b26efe37ccce',
        name: 'doc1',
        createdAt: 1626895838564,
      },
      {
        id: 'cbf07f65-18d3-455f-aab1-4fd98c21a740',
        name: 'doc2',
        createdAt: 1626837810820,
      },
      {
        id: '6aeb7d7a-9d9e-4849-a2d6-b7af75725ea7',
        name: 'doc3',
        createdAt: 1626883734635,
      },
    ];
    await this.client
      .collections(collectionName)
      .documents()
      .import(documents, { action: 'upsert' });

    const deleteByIdRes = await this.client
      .collections(collectionName)
      .documents()
      .delete({
        filter_by:
          'id:=["a620b2c0-7b19-4d38-813c-b26efe37ccce", "cbf07f65-18d3-455f-aab1-4fd98c21a740"]',
      });

    console.log(`${deleteByIdRes.num_deleted} documents deleted by id`);

    const deleteByNameRes = await this.client
      .collections(collectionName)
      .documents()
      .delete({
        filter_by: 'name:=["doc1", "doc2"]',
      });

    console.log(`${deleteByNameRes.num_deleted} documents deleted by name`);

Kishore Nallan just wondering if you have any thoughts on this?

Ellen Thank you for sharing that detailed code-snippet, makes it much more easy to debug 🙏

In the filter_by clause, the IDs, should not be surrounded by double-quotes.

If I remove those double-quotes, it works as expected:

  const deleteByIdRes = await client
    .collections(collectionName)
    .documents()
    .delete({
      filter_by:
        'id:=[a620b2c0-7b19-4d38-813c-b26efe37ccce, cbf07f65-18d3-455f-aab1-4fd98c21a740]',
    })```

2 documents deleted by id
0 documents deleted by name```

awesome thank you! knew it had to be something like that 😅