#community-help

Bulk Updating Records via Query in Typesense

TLDR Greg inquired about bulk updating records in Typesense using a query but Jason clarified that it's not possible, instead suggesting a method to get document IDs for updates.

13mo

Join the chat

Nov 15, 2022 (13 months ago)

Photo of md5-11c0f771a29e2aa8d72ae9544cc39017

Greg

08:34 PM

Follow-up question. Can you do a bulk update via query? Let’s say I need to update the title field for every record that has a mediaId of ‘XYZ’? The docs sound like I need to have the ID for each update record.

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

08:35 PM

Bulk update via a query is not possible. So you would have to query you primary data store with that filter, get the document IDs, and then update Typesense

Greg

08:36 PM

Thank you

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3005 threads (79% resolved)

Join Our Community

Similar Threads

Bulk Updating of Record Values in Typesense

Phillip inquired about the possibility of bulk updating in Typesense. robert confirmed it's possible using .import(docs, { mode: 'upsert' }) from the API.

14mo

Querying and Updating Specific Documents in Client Collections

Philipe inquired about updating documents using a query. Kishore Nallan said it's not possible yet, requested a Github issue to incorporate it into their roadmap.

25mo

Adding and Updating Collections in Typesense Server

sonu asked about methods to add and update collections in a Typesense server. Jason advised that documents can be added individually or in bulk, and updates can be batched using the import function, even with a small React app with a MySQL database.

32mo