[Bug]: FilterBy does an like comparison instead of exact match

[wouter1975]

Contact Details

No response

What happened?

Summary

The following GQL call uses the filterBy on the customer shortcode. In one example request the service for OU will find matches for OU and Testaccount, which results in incorrect data.

Related FE ticket: https://github.com/workfloworchestrator/orchestrator-ui-library/issues/1542

query SubscriptionsForCustomerQuery($shortcode: String!, $numberOfSubscriptionsPerCustomer: Int!, $filterSubscriptionBy: [GraphqlFilter!]) {
    customers (filterBy: { field: "shortcode", value: $shortcode}) {
        page {
            customerId
            subscriptions (first: $numberOfSubscriptionsPerCustomer, after: 0, filterBy: $filterSubscriptionBy, sortBy: [{field: "productTag", order: ASC}] ) {
                page {
                    subscriptionId
                    description
                    product {
                        name
                        productType
                        tag
                    }
                    customerDescriptions {
                        description
                        customerId
                    }
                }
            }
        }
    }
}

Solution:

• [ ] Default behavior must remain available, in opensource add ENV FILTER_BY_MODE with option exact/partial
  • [ ] default value is exact
• [ ] enhance FilterBy logic to cope with this env setting

Version

latest

What python version are you seeing the problem on?

No response

Relevant log output

No response

[wouter1975]

SURF ref: https://git.ia.surfsara.nl/netdev/automation/projects/orchestrator/-/issues/2174