René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"multiple filters with offset paging","articleBody":"I have this below hierarchical query where I want to select a particular item.  this works\r\n\r\n```\r\nquery Incident {\r\n    incident(id: 1) {\r\n        id\r\n        name\r\n        code\r\n        contactEmail\r\n        logoUrl\r\n        incidentTypeId\r\n        openDate\r\n        closeDate\r\n        inventoryCount\r\n        dapStateId\r\n        dapCount\r\n        created\r\n        updated\r\n        enquiries(filter: null, skip: 0, take: null) {\r\n              items {\r\n                enquirerDaps(filter: \"dapId==209\", skip: null, take: null) {\r\n                    items {\r\n                        id\r\n                        enquiryId\r\n                        title\r\n                        gender\r\n                        familyName\r\n                        givenNames\r\n                        nationalityId\r\n                        dob\r\n                        age\r\n                        religion\r\n                        medicalConditions\r\n                        totalRoute\r\n                        knownClosestRelative\r\n                        with\r\n                        dapId\r\n                        created\r\n                        updated\r\n                    }\r\n                }\r\n            }\r\n        }\r\n    }\r\n}\r\n```\r\n\r\nThis will return every enquiry with no enquirerDap items where it doesn't match the lower filter and the enquirerDaps items populated where it does match (e.g. in this example anything with 209).\r\n\r\nIdeally I would like just the enquiry and enquiryDaps where there is an explicit match to dapId==209 so I tried introducing a filter at the enquiry level with the logic of only selecting items where there are result of the lower query.\r\n\r\n```\r\n\"enquirerDaps.count()\u003e0\" \r\n```\r\nbut I get back this message\r\n\r\n```\r\n{\r\n    \"errors\": [\r\n        {\r\n            \"message\": \"Method 'count' not found on current context 'OffsetPage`1'\"\r\n        }\r\n    ]\r\n}\r\n```\r\n\r\nI also tried creating a field on the enquiry object to say how many enquirerDaps are present however that doesn't seem to take the lower filter into account.\r\n\r\nNot 100% sure on best approach here hence trying a number of ways but would really appreciate some guidance on this please.\r\n\r\n","author":{"url":"https://github.com/MarkRuseEL","@type":"Person","name":"MarkRuseEL"},"datePublished":"2024-06-09T08:05:53.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/378/EntityGraphQL/issues/378"}