wix query is not working properly ?

Ask the community
,
1

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 Removed

Please help me understand where im doing it wrong.

2

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);
}
3

You are genius . Thank you so much, it worked like a charm.