✨ [Feature request]: Ability to Get the "Only" the published plays

[atapas]

Is your feature request related to a problem? Please describe.

When we query for plays, it fetches plays that are published plus the ones WIP. We do not have a clear differentiator, causing multiple issues.

Provide a clear way to fetch:

• All plays that are published(So that we can build analytics on top)
• All plays that are WIP(So that we can determine stale and keep the DB clean in future)

Describe the solution you'd like.

We have something called DevMode but it needs manual intervention to keep it updated.

Describe alternatives you've considered.

We can still use DevMode property but in a more manageable way or come up with a complete new strategies.

Screenshot / Screenshare

No response

Additional context

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale. Please make sure to update to the latest version and check if that solves the issue. Let us know if that works for you by leaving a 👍 Because this issue is marked as stale, it will be closed and locked in 7 days if no further activity occurs. Thank you for your contributions!

[github-actions]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale. Please make sure to update to the latest version and check if that solves the issue. Let us know if that works for you by leaving a 👍 Because this issue is marked as stale, it will be closed and locked in 7 days if no further activity occurs. Thank you for your contributions!