Skip to content

Search string not working for combined search strings #1952

Open
@wouter1975

Description

@wouter1975

Try https://orchestrator.automation.surf.net/subscriptions?pageSize=15&pageIndex=1&sortBy=field-startDate_order-DESC&queryString=tag%3ALP+testaccount

This has no results, even though these subscriptions exist.

This issue is caused by the table navigation. The page index is 1 (page 2), while the number of hits is less than 1 full page.

how to reproduce

  • navigate to page 2
  • filter on the customer string test account
  • add the filter on the product tag column
Image Note that the page number is misleading, as it shows page 1, even though it is trying to show page 2.

Possible solution

Enforce a reset to page 1 after the search term has been change

Image

The GraphQL calls return the following: on the unfiltered SubscriptionsList returns internal server error, the filtered one an empty page[]

{
    "data": null,
    "errors": [
        {
            "message": "Internal Server Error",
            "locations": [
                {
                    "line": 2,
                    "column": 9
                }
            ],
            "extensions": {
                "error_type": "internal_error"
            }
        },
        {
            "message": "Internal Server Error",
            "locations": [
                {
                    "line": 3,
                    "column": 9
                }
            ],
            "extensions": {
                "error_type": "internal_error"
            }
        }
    ]
}

variables":{"first":15,"after":15,"sortBy":{"field":"tag","order":"ASC"},"filterBy":[{"field":"status","value":"active"}],"query":"testaccount* tag:lp"},"operationName":"SubscriptionsList"}

{
    "data": {
        "subscriptions": {
            "page": [],
            "pageInfo": {
                "totalItems": 8,
                "startCursor": null,
                "hasPreviousPage": true,
                "hasNextPage": false,
                "endCursor": 14,
                "sortFields": [
                    "customerFullname",
                    "customerHasActiveSubscriptions",
                    "customerId",
                    "customerShortcode",
                    "description",
                    "endDate",
                    "insync",
                    "note",
                    "productCreatedAt",
                    "productDescription",
                    "productEndDate",
                    "productId",
                    "productName",
                    "productStatus",
                    "productTag",
                    "productType",
                    "startDate",
                    "status",
                    "subscriptionId",
                    "tag",
                    "version"
                ],
                "filterFields": [
                    "customer_fullname",
                    "customer_has_active_subscriptions",
                    "customer_id",
                    "customer_shortcode",
                    "description",
                    "end_date",
                    "insync",
                    "note",
                    "product",
                    "product_id",
                    "start_date",
                    "status",
                    "subscription_id",
                    "tag",
                    "type",
                    "version"
                ]
            }
        }
    }
}

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions