Data query problem, working on preview but on publish...

Hi, I’m making a table for student’s list with one dataset. (e.g: stuent’s name, age, subject, teacher’s name, insert date…etc)

All data showing in the table are fine on publish. Then I make some numbers of items querying results and display on top of the table. so that people can see how many student, how many teacher, and how many student for each teacher…etc. There are around displaying 20pcs querying results. All working good in preview mode. But some of results can’t display on publish. both on Desktop browsers and phone, just some results are display again when refreshing. Only working perfectly on iphone’s ‘Opear mini’ browser.

Anyone can help this issue? Is there too many querying in dataset that cause this problem?

Thank you guys!!!

Check the collection permissions.
Don’t forget to sync sandbox and live collections.

Hi JD, thank you so much for reply.

My site only has 5 members now, and I set the collection permission to “Member Generation Content”, because of they can submit their student information on Home Page, after that will auto go to the table list page.

All data are showing prefect in the list, just the ‘Counting Number’ of these items I set on the top of the table are working unstable after publish and view from desktop browsers and phone browsers. For example. there are 20 count of items will show on the top, I only can see like 10 items works, the rest of items are not generated out or I can see the results when the page still loading, but go back to nothing after the page loading. Thats why I guess that is the problem of too many querying I set for the collection. All browsers of desktop are same problem.
On phone, ‘Chrome’, ‘safari’, ‘firefox’, ‘Opera Touch’ are same problem, only works perfectly on ’ Opera Mini’ app. So that is the interesting point. if the reason is about the permissions, it should be not working on ‘Opera mini’ too.

Any other possibility that to cause this problem?

Thank you again!!! :slight_smile:

I have the same problem. I have changed the collection permissions every which way possible. Still have queries working in Preview, but not in Live… I NEED HELP!!