Question:
Query returning last item values in results disturbed that are causing greater damage to us.
Query:
wixData.query("MemberImagesBalanceActivePlan")
.ne('canceled', true)
.eq('_owner', user.id)
.ge('validUntil', today)
.ascending("_createdDate")
.find()
.then((results) => {
if (results.items.length > 0) {
items = results.items;
console.log("queryBalancesAvailable FIND items: ", items)
} else {
items = null;
}
return items;
})
.catch((error) => {
let errorMsg = error.message;
let code = error.code;
});
And here are the wrong results:
items: (2) [{…}, {…}]
0: activated: trueavailableImages256X256Px: 6availableImages512X512Px: 3availableImages1024X1024Px: 2initialImages256X256Px: 5initialImages512X512Px: 2initialImages1024X1024Px: 1invoiceId: ""invoice_number: ""month: 4planOrPackageId: ""planOrPackageName: "Free Membership"startDate: Wed May 01 2024 22:26:06 GMT-0600 (hora estándar central)Objecttitle: "6f17fcbc-34a7-4e07-a5ac-1203366a6fc5"validUntil: Sat Jun 01 2024 18:00:00 GMT-0600 (hora estándar central) {}wixPayOrderId: ""year: 2024_createdDate: Wed May 01 2024 22:26:07 GMT-0600 (hora estándar central) {}_id: "6f17fcbc-34a7-4e07-a5ac-1203366a6fc5"_owner: "18d8c91a-da80-468a-a180-1e0340a546c8"_updatedDate: Mon May 20 2024 18:17:11 GMT-0600 (hora estándar central) {}[[Prototype]]: Object
1: activated: trueavailableImages256X256Px: 5availableImages512X512Px: 2availableImages1024X1024Px: 1initialImages256X256Px: 5initialImages512X512Px: 2initialImages1024X1024Px: 1invoiceId: "46b5f8a7-7777-4406-b4ef-67ac34b069a0"invoice_number: "0000064"month: 4orderId: "8c50cca4-3e6b-40a7-8dc4-a55189df2f84"planOrPackageId: "36de7176-aa33-4ad1-b8ac-86fdcbb4557a"planOrPackageName: "Bloomy's Image Package Test"startDate: Mon May 06 2024 00:00:00 GMT-0600 (hora estándar central) {}title: "bca68912-014c-4358-8347-aae29c4449f6"validUntil: Mon May 05 2025 18:00:00 GMT-0600 (hora estándar central) {}wixPayOrderId: "5c3f7d51-87fe-4824-9294-8ee6958dce36"year: 2024_createdDate: Sun May 05 2024 20:34:13 GMT-0600 (hora estándar central) {}_id: "bca68912-014c-4358-8347-aae29c4449f6"_owner: "18d8c91a-da80-468a-a180-1e0340a546c8"_updatedDate: Tue May 07 2024 19:51:49 GMT-0600 (hora estándar central) {}[[Prototype]]: Objectlength: 2[[Prototype]]: Array(0)
Info saved in DB Collection:
"Title","ID","Created Date","Updated Date","Year","Month","Initial Images 256x256 px","Initial Images 512x512 px","Initial Images 1024x1024 px","Available Images 256x256 px","Available Images 512x512 px","Available Images 1024x1024 px","validUntil","Ids Images 256x256 px","Ids Images 512x512 px","Ids Images 1024x1024 px","planName","wixPayOrderId","planId","activated","Orderid","Invoicepaidid","Owner","Invoice_number","canceled","planOrPackageName","planOrPackageId","invoiceId","Startdate"
"6f17fcbc-34a7-4e07-a5ac-1203366a6fc5","6f17fcbc-34a7-4e07-a5ac-1203366a6fc5",2024-05-02T04:26:07Z,2024-05-21T00:17:11Z,2024,4,5,2,1,1,1,1,2024-06-02T00:00:00Z,,,,,,,true,,,"18d8c91a-da80-468a-a180-1e0340a546c8",,,"Free Membership",,,2024-05-02T04:26:06Z
"bca68912-014c-4358-8347-aae29c4449f6","bca68912-014c-4358-8347-aae29c4449f6",2024-05-06T02:34:13Z,2024-05-08T01:51:49Z,2024,4,5,2,1,5,2,1,2025-05-06T00:00:00Z,,,,,"5c3f7d51-87fe-4824-9294-8ee6958dce36",,true,"8c50cca4-3e6b-40a7-8dc4-a55189df2f84",,"18d8c91a-da80-468a-a180-1e0340a546c8","0000064",,"Bloomy's Image Package Test","36de7176-aa33-4ad1-b8ac-86fdcbb4557a","46b5f8a7-7777-4406-b4ef-67ac34b069a0",2024-05-06T06:00:00Z
This can prove that services are failing. What can I do?
Product:
Wix Editor and CMS
What are you trying to achieve:
just to get the rigth info from Collections in DB without disturbs
What have you already tried:
To standarize and format fields.
Moved from backend to frontend
Changed to async
Additional information:
We need you to inform you that WIX IDE is causing greater damage to us by disturbing essential info saved on DB and nobody in suppport attend this. Please help!