I’m converting some old code to ORDA and finding the conceptual shift a bit tricky (I’m a Bear of Very Little Brain).
The code loops through records in [Items] (which are dated), selecting a month at a time. [Items] is related to [Types]; the relations are ItemsToType and TypeToItems. Within each month’s worth of items, I want to find those of each of several types so I can sum [Items]Fee for that type. So in old money, having got the month’s selection in [Items], I do
QUERY SELECTION ([Items];[Types]Type<3)
QUERY SELECTION ([Items];[Types]Type=4)
and so on (the code itself looks a little different, but that’s the gist).
How would I do the equivalent in ORDA?