Collections created today do not return query results

Ask the community
,
1

At some point today, in both my test and premium sites, new collections set up and referenced by javascript query code return no results in the Test or Published mode–they do work as expected in Preview mode.

To test this, I set up a new test* site with 1 collection called “ParticipantTest” containing 1 field with 1 entry

which is referenced by this query in the associated code page;

import wixData from “wix-data” ;
$w . onReady ( function () {
wixData . query ( “ParticipantTest” )
. contains ( “participantId” , “121112061954” )
. find ()
. then ( partIDs => {
$w ( “#input1” ). value = partIDs . items [ 0 ]. participantId
}
);
});

The page only has the 1 textbox input element and no other buttons or controls. The collect is set to “Form Submission.”

757×250 11.1 KB

In preview mode, it works as expected (populating the input box with the returned collection table value):

However, in Test or Published modes, no results are returned.

Any help resolving this would be greatly appreciated as the site is being developed for a university medical research lab under a tight deadline.

Thanks,
Brian Roberts

*Test site link below:
test | Collection Test (wixsite.com)

2

Hi Brian,
I’m sorry to hear you’re experiencing this issue while under a tight deadline. Please report bugs to Wix Customer Care ; they track and monitor all incoming issues and will escalate bugs to product teams. Thanks!

3

I contacted them, and although I didn’t hear back from the Velo team directly, it appears they fixed the problem. I’m assuming it was a configuration error on the Collection which I had changed from “Site Content” to “Form Submission”. In the end, it really need to be “Custom Use” with Read set to “Anyone”, Write set to “Anyone”, Modify set to “Anyone” and Delete set to “Admin”. This seemed to fix the problem across the actual production site.