Skip to content

[FEATURE] The State column isn't included on the metadata.optionsetvalue table. #757

Description

@SiPurdy

Is your feature request related to a problem? Please describe.
When running the following query:

SELECT optionsetvalue.label,
       optionsetvalue.value
FROM   metadata.attribute
       INNER JOIN
       metadata.optionsetvalue
       ON attribute.metadataid = optionsetvalue.attributeid
WHERE  attribute.entitylogicalname = 'email'
       AND attribute.logicalname = 'statuscode';

The State property is included from the StatusOptionMetadata in the underlying api response results, but isn't included in a column on the metadata.optionsetvalue.

I have the use case of needing the state for a given statuscode value.

Describe the solution you'd like
I'd like the state available as a return column on the table, ideally also queryable.

Describe alternatives you've considered
Isn't really an alternative I can think of?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions