Explore Advance filter for Data Assets Status only shows GlossaryTerm statuses

[Prajwal214]

Affected module
Does it impact the UI, backend or Ingestion Framework? - UI

Describe the bug
A clear and concise description of what the bug is.

• In Explore, when using Advance filtering Data Product by Status, the available filter options only display the statuses configured for Glossary Terms.

The filter is not considering or displaying the statuses configured for Data Products, which prevents users from filtering Data Assets correctly based on their Data Product status.

To Reproduce

Screenshots or steps to reproduce

Expected behavior
A clear and concise description of what you expected to happen.

• The Status filter should include the statuses configured for Data Products and all the data assets, allowing users to filter Data Assets based on their associated Data Product status.

Version:

• OS: [e.g. iOS]
• Python version:
• OpenMetadata version: [e.g. 0.8]
• OpenMetadata Ingestion package version: [e.g. openmetadata-ingestion[docker]==XYZ]

Additional context
Add any other context about the problem here.