How can i get the number of records of an odata entity filtered through associated object?
0
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!