How can i get the number of records of an odata entity filtered through associated object?

Hello! I'm trying to get the number of records of an Odata entity through an associated object to use in pagination. This is because of the requirement says that i need to use a treenode to display the data, and this widget does not have pagination so i'm doing it through microflow in a non persistable entity.     For the pagination that we use i need to get the number of clients associated to a DistributionChannel. Is it possible in Mendix 9.18.1 using a REST call ? I've tried using $count but i don't know if it's possible to combine this with a filter, since the path /Client?$expand=DistributionChannel(?filter=DistributionChannelID eq {2}) gives me a syntax error.   Thanks in advance!
0 answers