Hi,
My wixquery is not working properly the query used to result all the items which expirydate is older than todays date and used to delete all the items in one go ? but now its not working properly its just giving only one item and deleting only one item. i dont know what went wrong, please hep me solve this
movies Database
i have 2 items in my database for which expirydate is lesser than today's date
output in preview mode : it should be resulting 2 items but it resulted only one
"2019-11-22T06:49:23.415Z"
Movie Reviews
Line 69
{...}
"2019-11-02T18:30:00.000Z"expirydate:
"wix:image://v1/e73102_ddf09fac3bbb401eba8de2154463c312~mv2.gif/introducing-coupons-1.gif#originWidth=800&originHeight=600"movieimage:
"f3ecefe8-cf08-4bc7-8d00-0be338d1c74a"_id:
"6d2fb79f-26ab-457f-85a3-b3d778cc1701"_owner:
"2019-11-21T19:50:06.743Z"_createdDate:
"2019-11-21T20:02:53.766Z"_updatedDate:
"2d32bdba-16ee-4455-b98e-4670762e8188"language:
"test-2"title:
"/movies/test-2"link-movies-title
{...}
"2019-11-02T18:30:00.000Z"expirydate:
"wix:image://v1/e73102_ddf09fac3bbb401eba8de2154463c312~mv2.gif/introducing-coupons-1.gif#originWidth=800&originHeight=600"movieimage:
"f3ecefe8-cf08-4bc7-8d00-0be338d1c74a"_id:
"6d2fb79f-26ab-457f-85a3-b3d778cc1701"_owner:
"2019-11-21T19:50:06.743Z"_createdDate:
"2019-11-21T20:02:53.766Z"_updatedDate:
"2d32bdba-16ee-4455-b98e-4670762e8188"language:
"test-2"title:
"/movies/test-2"link-movies-title:
Movie Reviews
Line 79
Item RemovedPlease help me understand where im doing it wrong.
Hello. @Vamsi . 8th line of your code puts only first element in items variable. You can use this code
async function deleteExpired2() { const Today = new Date(); console.log(Today); //get all expired items const expiredItems = await wixData.query('movies').le('expirydate', Today) .limit(1000) .find() .then(res => res.items); //map items to id const expiredItemsIds = expiredItems.map(item => item._id); //bulk delete items with passed ids const deletedItems = await wixData.bulkRemove('movies', expiredItemsIds); }https://www.wix.com/corvid/reference/wix-data.html#bulkRemove