The orders collection in store is admin read only, so we cannot read the data from orders collection directly in the published site, only in preview site.
Is there any other way to read the data from orders collection in published site?
There is no way to change the permissions also.
I want to query the specific row based on specific value,
please help on how to do it in any other way