[BUG] deleted queries still visible via SOAP api with Status=Inactive

[JoernBerkefeld]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

searching for a query by key might return a deleted entry:

        <RetrieveResponseMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
            <OverallStatus>OK</OverallStatus>
            <RequestID>5067c2d6-5099-48b3-97b3-970b75b7bb5d</RequestID>
            <Results xsi:type="QueryDefinition">
                <PartnerKey xsi:nil="true" />
                <ObjectID>91496c83-27fb-4db5-89a6-17ae6714d46b</ObjectID>
                <CustomerKey>dataView_unsubscribe</CustomerKey>
                <Status>Inactive</Status>
            </Results>
            <Results xsi:type="QueryDefinition">
                <PartnerKey xsi:nil="true" />
                <ObjectID>8dd179c5-bc45-41a0-b971-a73a77ad9540</ObjectID>
                <CustomerKey>dataView_unsubscribe</CustomerKey>
                <Status>Active</Status>
            </Results>
        </RetrieveResponseMsg>

this will impact retrieve-by-key AND delete functionality negatively

Expected Behavior

https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/querydefinition.html

we need to filter by Status=Active on top of any key-filters

Steps To Reproduce

1. Go to '...'
2. Click on '....'
3. Run '...'
4. See error...

Version

4.3.3

Environment

• OS:
• Node:
• npm:

Participation

• I am willing to submit a pull request for this issue.

Additional comments

No response

[github-actions]

Closed by #738.