Greetings
The graphql admin API appears to still have the limitation that one cannot query PUBLISHED products by a collection IN ORDER (in the order they appear on store/admin panel).
Products can be returned BY COLLECTION but they will either INCLUDE UNPUBLISHED products, or they will not be IN ORDER.
This is a limitation that the rest API did not have.
Yes we can paginate and manually filter unpublished products, but that is inefficient and could result in the first 250 products being unpublished as an edge case.
Yes we can manually store all products in our database and query there, but again it’s inefficient and cumbersome.
Yes there’s the storefront API but the resulting information doesn’t contain valuable product admin information.
Is there any solution to this problem that isn’t a hacky workaround to just query multiple times?